Data window prints blank pages?

[Former Member]

I have a few reports in my application that seem to be printing blank pages. It looks like the first page is correct with the correct data. I have a page count on the bottom of the page using "'Page ' + page()+ ' of ' + PageCount()".

The next page is blank. The 3 page just says page 1 of 1 on it and the last page is blank?

Does anyone know of a reason why blank pages would be printing out from a data window report?

SQL only returns 1 record from the database. So i am puzzled as to why i get 4 pages printed and why 3 of the pages are blank.

[Former Member]

Hi Steven;

   This typically happens when controls are placed outside the DW's print area. Check for both visible and non-visible objects. You might want to make sure that you have RULERS & display invisible turned on in the DW Painter - plus, toggle back & forth in/out of print preview mode to check for how the DWO will behave during printing.

HTH

Regards ... Chris

[Former Member]

I guess the part that is odd is when i do the rows -> retrieve. It is showing up in that preview as one page?

but when i do the .print() on that data window it is printing two pages.  the first page is what i see in the preview the second page is blank with just page 1 of 1 on it.

I looked for hidden data elements and i did not find any.

How does PB know how many pages to print?

[Former Member]

Right, if you are seeing Page 1 of 1 on the 2nd page that is getting printed, then look at the paper settings and see if you can play around that. If you enable the margins in the datawindow painter preview, what do you see?

[Former Member]

The page count pertains to vertical pages. Your problem is more than likely horizontal pages. Methodically remove objects from the right side of your dw until the horizontal page count in print preview mode goes to 1.

[Former Member]

This usually happens when you have any controls outside the page margins. You can open your Datawindow painter, enable the rulers, and check for any visible or invisible objects or controls that lie outside the frame.

This should give you an idea.

[Former Member]

Hi Steven,

Temporarily change the border of all your objects to a box. The blank page should display the border of the offending object. Don't forget to change the borders back when done.

hth,

Mark