sub report should be suppressed

[Former Member]

Hello;

I need a help to get rid of this sub report when there is no row returned.

I have a main report with several sub reports. One of sub report only contains a few text words on detail section. When no row returned from query, this sub report should not been seen at all. Currently this sub report gives a blank page.

I set suppress property

{Command.PageCount} mod 2 = 0

However when pagecount = 2, I got blank page from this sub report.

Please help.

Jean

[Former Member]

Jean,

Right click on the subreport, and select format. On the format subreport tab, check suppress blank subreport.

Debi

[Former Member]

Thanks Debi for your such quick response. I tried that way, it did not work.

However I just made it work by check the similar property(suppress blank section) for the section of detail where the sub report sits.

Thank you for your quick help.

Jean