Blank Page Print While No Data

[sam85]

Hi,

I have many reports where I use the Detail Area and everything else is surpressed. When there is no data, I get a Blank Page even while printing. Can I surpress this behaviour somehow?

Thanks for any reply.

(CR 11.5)

Kind regards

Sam

[DellSC]

I usually handle this by creating a formula that will cause an error when there is no data. An easy way to do this is to divide by 0. Put this formula in the report header - it will run even if the report header is suppressed.

I assume that you're running this through a program. If it's a program you, or someone in your company, has written, you can then catch the divide by 0 error and ignore it.

-Dell

[sam85]

Hi Dell,

i was trying to divide my order number through zero and put the formula into the page header. but i am still getting a blank page. i already have a blank page even without that formula. maybe i did something wrong?

yes you are right, i am running the report through a program. do i need to catch the error to handle the "don't print that blank page while error"?

PS: i only get that dividing error when i put that formula into my detail section.

Greetings

Sam

[DellSC]

You can put the formula in the details section and "hide" it by making the text the same color as the background.

Another thing you can do is put a suppression formula on each of the sections in the report that will display if there is data. DO NOT check the suppress checkbox and add a formula like this:

IsNull({some key field that will always have data})

This will evaluate to True when there is no data, in which case it will suppress the section.

-Dell