Reporting Services: Suppressing blank reports?

Hello,
I've got reporting services (SQL 2000) sending out daily reports by
email to a group of recipients. The reports show all new records added
to a table since the last report.
Unfortunately these reports go out even when there are no new records
added... it's just a blank report.
Is there any way to suppress these blank reports/emails so they aren't
sent'
Thanks in advance for your help...
-jasonJason,
If you are running the Enterprise Edition of SSRS, you can use a data
driven subscription to trigger the subscription only when there are
records to display.
If you are not using the EE, then it is not possible to stop the
distribution of the report, empty or otherwise. The best option
presented here has been to utilize the NoRows property in a data region
to display a message when there is no data returned. Simply select the
expression option for the property and insert the message to be
displayed e.g. ="No records were returned using those parameters"
HTH
toolman
jesrushdisposable-all@.yahoo.com wrote:
> Hello,
> I've got reporting services (SQL 2000) sending out daily reports by
> email to a group of recipients. The reports show all new records added
> to a table since the last report.
> Unfortunately these reports go out even when there are no new records
> added... it's just a blank report.
> Is there any way to suppress these blank reports/emails so they aren't
> sent'
> Thanks in advance for your help...
> -jason|||toolman,
Very helpful information -- thanks so much!
-j