Blank report page

[SHK]

Hi! I have created a crosstab report that contains two pages. The second page may be blank depending on the number of records. I am wondering if there is a way to hide the second page of the report when it is blank. Or, Is there a way I can set the printer to print only the first page when the seond page is blank.

Thanks in advance for any advice.

SHK.

 

[mark curtis]

The report should only print the data you return.

Check that for any sorting/grouping footers that you do not have force new page after section selected. also your page settings may be too wide and therefore returning a blank page.

 

[SHK]

Hi Mark, thanks for the reply.
It is a crosstab report. There are unbound textboxes on the first page and the second page. Depending on the number of columns returned from the query, the script will hide the extra textboxes from the screen. So, the unbound textboxes on the second page will be invisible if the data can all fit onto the first page. Thus, the second page is blank. In this case, is there a way to not print the second page?

Thanks once again for your help.

SHK

 

[jtvcs]

Just thinking from the top of my head...is the report always two pages ? and will all the page 2 textboxes be blank as a group ? then you might want to consider adding VB code to block the printing of page 2 (I did that a few years ago but can't put my hands on the code right now). Maybe if the two questions are answered YES, someone else on the forum can help you with the code itself. HTH JT

 

[Rich]

Set the Can Shrink to yes

 

[SHK]

Can Shrink does not work. I am going to look for the vb code to stop the printing of second page. At least now I know it is doable. Thanks for the suggestions.