sub report repeating first page in print preview

tvman5683

Board Regular
Joined
Mar 23, 2009
Messages
94
Hello, I added a subreport to a main report, It has 29 lines of date pulled from a table. When I view the subreport alone it looks fine. When it appears under the main report it shows the first page. When I look at the print preview it shows the same data set page after page (for 76 pages). I've tried moving the subreport to other sections of the main report but no change. When I added it to the footer I did see all 29 lines but there was pages of blank space between the header and footer.

Any help or ideas would be appreciated
Thanks
tvman
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
How is your Subreport linked to your Main Report?
What section did you put the body of your Main Report in?
What section of the Main Report did you put the Subreport in?
 
Upvote 0
Solution
How is your Subreport linked to your Main Report?
What section did you put the body of your Main Report in?
What section of the Main Report did you put the Subreport in?

I figured out the 76 pages. Some areas were over the margins creating blank extra pages.
Now I can see all 29 lines of the subreport and can scroll down thru them to see the total but print preview only now shows one page with 12 lines


sub repor tis under page header, main is up under report header
 
Upvote 0
Main report is just a header for an invoice creator
sub report is the details for the invoice
 

Attachments

  • Main report.png
    Main report.png
    99.4 KB · Views: 13
  • sub report.png
    sub report.png
    95.2 KB · Views: 13
Upvote 0
Main report is just a header for an invoice creator
sub report is the details for the invoice
I moved the sub report up into the main report header area and it seems to work fine. I see all the 29 lines of data and the report prints out in 2 pages.

Thanks for taking a look at this for me.
 
Upvote 0
You are welcome.
Glad you were able to get things sorted out.
 
Upvote 0

Forum statistics

Threads
1,223,566
Messages
6,173,106
Members
452,501
Latest member
musallam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top