Hide Blank Pages Sql Reporting 2005

[gtjr921]

I have a report with some hidden fields, the report spans the hidden field to another page. The data is hidden, but it still shows the page as if data were there.
I can you supress blank pages in a Sql 2005 report?
Thanks

 

[SQLBI]

To my knowledge there's no way of not printing the blank pages. Can you move the hidden fields to an area of the report that does get printed, behind a table perhaps, so that the blank pages are no longer an issue?

Cheers,
Leigh

The problem with common sense is that it isn't that common!

 

[gtjr921]

that's a thought I'll check it out thanks

 

[Jacque]

Hi,
Here are some options that might work for you with some modifications to meet your requirements.

=iif(rownumber("DataSourceName") = 0,true, false)

=iif(Fields!FieldName.Value="",true,false)

Jacque