asked on

How to suppress report print if no data

I have a subreport that I do not want to print if the subreport has no data. The subreport has 1 table.
Main report A has an embedded subreport B. If subreport B has no data to display, it should not print.
How do i do that?

AntonyDN

If there's no data in your subreport, then it won't display

Brenda Wilkerson

ASKER

The report has only one table of data but there is a lot of hardcoded text so if there is no data to populate the table then the report still displays. I only want the report if there is data in tha table. I have set the NoRows property in the table to "CnData" but I can't determine how to set the visibility of the report based on that.

Chris Luttrell

Then you want to check something in an expression in the visability property and set to False if no data.

ASKER CERTIFIED SOLUTION

Chris Luttrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rustypoot

The reporting system will be modified to look for a special phrase, “[SUPPRESS REPORT]”, in the
Microsoft SQL Reporting Services report. If the reporting system finds the phrase the report will not be sent
to a printer. This IS the answer.....

jrmc-pgmr

rustypoot,

Where can you add "[SUPPRESS REPORT]” in SSRS? I try to find a way to stop sending print job to printer if the report is blank. I am using VS 2008 to develop the report .

Thanks