sql server reporting services: Not creating report when no data is present -- sql server reporting services

You're in the

sql server reporting services

group:

Not creating report when no data is present

Steve
6/11/2006 4:15:02 PM

sql server reporting services: I have a subscription that is set up to run each night. The report creates a
list of updated information during the day. If there is no updated
information during the day I still get the report header but the report is
blank. I would like to not create any report (or at least have it not email
the report) when there is no data returned from the query. Is that possible?

Re: Not creating report when no data is present

Tim Dot NoSpam
6/12/2006 12:00:00 AM

If you're using Enterprise edition, you can use data driven subscription and
write the query so no recipients are defined when changes are not present.
I don't know of any way to force a subscription to NOT publish if there are
no data rows.

[quoted text, click to view]

Re: Not creating report when no data is present

Steve
6/12/2006 6:48:01 AM

Tim,
Thanks for the info. That is what I did but I was hoping that there might
be a parameter that I could set to not write the report when the query
returned no rows. Thanks...

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn