How2suppress generating report in crystal report report 10 when no data.

[Former Member]

I am using crystal report v10,

1.I would like to suppress the generating of the report(Main report itself), when no data is returned by the main report query.

2.How crystal is able to identify that no data is returned and if i try to print it, it doesn't print the blank page?

Thanks & Regards,

Kiran

[Former Member · Accepted solution]

Got to

File -> Options - Reporting tab

Check - Suppress printing if no records selected

Ian

[Former Member]

You can use 'Suppress Blank Section' in Section Expert for 'Details' section and other sections that are showing database fileds only.

For other sections, like Page Header, Report Header, footer etc, where constants along with data fields, you can write a suppression formula as given below:

isnull({PrimaryKey Filed used iin the report})

Hope this helps.