RE: Creating a Report Dennis 01.11.2005 11:45:02 Assuming you have the material in a sorting/grouping section, then look at the properties of the section. There is a 'force new page' property. Set this to After section and you should get each material details on a separate page. "Marcel Stoop" wrote: [Quoted Text] > Hi everyone > > My Report retrieves data from a specific MS SQL Table. The report is > filtered by a SQL Statement. > The Data within that Table can be defined into 3 sub-categories; say > Material A, Material B, Material C > > My Question is: > Is it possible to tell the Report to start a new Page as soon as data from > the next category appears. So, as soon as all the Data concerning Material A > has been retrieved and put into the report, the report should start a new > page for Material B. > > Thanks for the help > > Marcel > > >

Re: Creating a Report "Douglas J Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 01.11.2005 11:50:16 Just to piggy-back on Dennis's post, if you want the data sorted, you MUST use the Sorting/Grouping feature in the report. Reports don't respect the underlying order of their recordsources. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Dennis" <Dennis[ at ]discussions.microsoft.com> wrote in message news:FC98816A-C226-4737-88C4-2946D254B75A[ at ]microsoft.com... [Quoted Text] > Assuming you have the material in a sorting/grouping section, then look at > the properties of the section. There is a 'force new page' property. Set this > to After section and you should get each material details on a separate page. > > "Marcel Stoop" wrote: > > > Hi everyone > > > > My Report retrieves data from a specific MS SQL Table. The report is > > filtered by a SQL Statement. > > The Data within that Table can be defined into 3 sub-categories; say > > Material A, Material B, Material C > > > > My Question is: > > Is it possible to tell the Report to start a new Page as soon as data from > > the next category appears. So, as soon as all the Data concerning Material A > > has been retrieved and put into the report, the report should start a new > > page for Material B. > > > > Thanks for the help > > > > Marcel > > > > > >

Re: Creating a Report "Van T. Dinh" <VanThien.Dinh[ at ]discussions.microsoft.com> 01.11.2005 14:30:42 If you wait until 2007, everything will be done automatically for you ... -- Van T. Dinh MVP (Access) "Marcel Stoop" <marcel.stoop[ at ]freesurf.ch> wrote in message news:%23KvI1Ws3FHA.3296[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > Hi everyone > > My Report retrieves data from a specific MS SQL Table. The report is > filtered by a SQL Statement. > The Data within that Table can be defined into 3 sub-categories; say > Material A, Material B, Material C > > My Question is: > Is it possible to tell the Report to start a new Page as soon as data from > the next category appears. So, as soon as all the Data concerning Material > A > has been retrieved and put into the report, the report should start a new > page for Material B. > > Thanks for the help > > Marcel > >

Re: Creating a Report Bob Miller <Bob.Miller.1xtqts[ at ]news.officefrustration.com> 01.11.2005 15:49:12 If Material A, etc. is a value in a field e.g Material, then you can group on Material and in the Group Header properties set it to Force New Page Before Section. Marcel Stoop Wrote: > Hi everyone [Quoted Text] > > My Report retrieves data from a specific MS SQL Table. The report is > filtered by a SQL Statement. > The Data within that Table can be defined into 3 sub-categories; say > Material A, Material B, Material C > > My Question is: > Is it possible to tell the Report to start a new Page as soon as data > from > the next category appears. So, as soon as all the Data concerning > Material A > has been retrieved and put into the report, the report should start a > new > page for Material B. > > Thanks for the help > > Marcel -- Bob Miller

Creating a Report "Marcel Stoop" <marcel.stoop[ at ]freesurf.ch> 01.11.2007 09:18:36 Hi everyone My Report retrieves data from a specific MS SQL Table. The report is filtered by a SQL Statement. The Data within that Table can be defined into 3 sub-categories; say Material A, Material B, Material C My Question is: Is it possible to tell the Report to start a new Page as soon as data from the next category appears. So, as soon as all the Data concerning Material A has been retrieved and put into the report, the report should start a new page for Material B. Thanks for the help Marcel