I have a Master Detail Crosstab report that must be printed. Some Sections span more than one page horizontally, some do not. Blank pages are generated because of the section(s) that spill over more than one page. How can I remove the blank pages or stop them from printing. I cannot reduce the size of the columns, so the spill over is going to happen. Using the <“Fit to n pages wide”> will not correct the issue. (see attachment)
Any suggestion that stop the printing of the blank horizontal pages in a crosstab is appreciated. Even macro code would be welcomed.
If Fit to 1 page wide is not what you are looking for.
I would go in structure mode and delete unwanted cells.
The reason why you are getting blank pages while print out could be possibly due to the presence of these unwanted cell and youo can have a better view in structure mode.
The blank pages are caused by report section(s) being wider than one page horizontally. ALL sections will have the same number of horizontal pages as the widest section. Example: a report with 3 sections, each only 1 page in length vertically and only one section is 2 pages horizontally, then the total number of pages is 6+.
Example:
(I do not want to print (or number) Blank page 2 and 6)
But, Let up say you have crosstab1 in your report and you had set master detail structure. Now your page 2 and 6 are blank since there is no data for that paricular instance of master.
To over come this, you can define a filter on the master dimension. Defining something like,
I am facing the same issue in on of the reports that you had earlier. Were you able to get rid of blank pages. Please let know if you have any solution in mind for this issue.
(BOB member since 2006-12-21)
(BOB member since 2005-02-24)