Stop main report repeating

[matthewnsarah07]

Hi

I have a main report 'WeeklyReport' that is currently 7 A4 pages long that works fine.

I have an additional report that users a similar layout but different data that I wish to add to the end of the main report if possible 'WeeklyReport2'

I have initially added the second report as a subreport under the first and that worked in that is appeared after the 7th page - however the report then repeats itself 7 times - is there anyway to stop the report repeating?

Thanks

 

[vbaInet]

Put the subreport in the Report Footer section and set that section to Force New Page Before Section.

 

[matthewnsarah07]

I have put the subreport in the footer - how do I force the page as you mentioned - this is in Access 2003

 

[vbaInet]

Look in the property sheet of that section (by right clicking the section's bar and selecting properties). Under the Format tab you will find the Force New Page property.

 

[matthewnsarah07]

Thanks for your help

I have set the Force Page propery but that seems to just put the footer over the main report which is full A4 - now only the top inch shows then the footer - any ideas??

 

[vbaInet]

Check the Can Grow property of the other section and ensure it's set to Yes.

 

[matthewnsarah07]

Set the Can Grow to yes, but still the footer covers the main report not sure why at all

 

[vbaInet]

Let me see a screenshot of what you're talking about.