Vision Binary

1.Blank page between each data page.

Go to report properties check the page size and margins. Here is an example that how blank pages occurs every time between two pages which content data.

In report properties the page width  is 8.5 in, however in design panel, the real body width already exceeds the limit.

1-1  margin and page size of the report

1-2 real body width in design panel.

For this type of blank pages. Just need to adjust the  page property and the the report body  width.

body width+left margin+right margin<= pageSize width

2. Blank page occurs when insert Sub Report.

update: please do remember set ConsumerContainerWihtespace: TRUE.(I keep having blank page in between main and sup report or blank page come in the last page of whole report, after I set all properties, some report still get the issue. but after set it true both in sub and main, blank pages gone)

This can be a little bit tricky though.

a. first: still  check the Page size properties, and remember, for the Sub-report the page size, it should be much smaller than the master report, which means:

Sub report(body width+left margin+right margin)<= Sub(pageSize width)<Master(body width)<Master(body width+left margin+right margin)<= Master(pageSize width)

And how much less should be enough to eliminate the blank page? well I can say you need to keep adjusting and run it. For example. My master report page size is 11*8.5(landscape) and body width is 10.8 in ,left and right margin both are 0 in, my sub report page size width need to be less than 8.5 in, then I wouldn’t get any blank page in my whole report.

b. And second: set you right margin to 0 in your master report. I have experiences when I debug my sub report there is no blank page breaks, however when I run in master report there were breaks, after several times attemptings I found that by setting the right margin to 0 in, the breaks disappeared. It’s very annoying.

c. Third: You may need to set ConsumerContainerWihtespace: TRUE, it’s in report properties. this change will make all report act like master report.

d. Fourth: You may want to keep your sub report as tight as possible that means many be no white space after the tables, no unnecessary  footers, the Sub report basically  just contain the data you need without extra space, so it wouldn’t spill out the master report’s container or body.