I have made a report containing 2 subreports. The report appears tidy in the Report View. But in Print Preview there appear many blank spaces and blank pages.Hoaw can I avoid these?
I have made a report containing 2 subreports. The report appears tidy in the Report View. But in Print Preview there appear many blank spaces and blank pages.Hoaw can I avoid these?
in each sub report, tighten up the page,
narrow the paper width and length borders,
turn on : can shrink
cant say anymore without seeing it.
The spaces caused in the Print Preview are due to the Report extending beyond the page limits. Is there any option in the Design or Layout View which can shrink the Report and bring it within the page limits thus eliminating the spaces.
Design view is used to move items manually.
As Ranman has already said,
1. You will need to move controls up or to the left to make them fit removing any unnecessary 'white space'
2. You can also reduce the page margins to fit more on the page