Email report (or link), only if there are records to be viewed.

Any idea how to have a Report Subscription only email the report or link if
there are records returned by the reports query or dataset?The only way I've seen to do this is with a data driven subscription.
Unfortunately, DDS is not available in non-Enterprise edition
installations. If you can't do DDS, the best you can do is use an
expression like ="No data available to report" in the NoRows property.
The subscription email still goes out but the report contains an
explanatory message instead of a blank page.
HTH
toolman
Corvallis wrote:
> Any idea how to have a Report Subscription only email the report or link if
> there are records returned by the reports query or dataset?|||Hi Corvallis,
Were you able to do this? Have the same need to email the
report ONLY if there are any records. Please let us know.
Best regards,
Steve.
"Corvallis" wrote:
> Any idea how to have a Report Subscription only email the report or link if
> there are records returned by the reports query or dataset?|||Hi Toolman,
Do you have any examples of this
? We need the same logic. Am looking at the step 3 window and the place to
put this in but am not sure.
Thanks, Steve.
"toolman" wrote:
> The only way I've seen to do this is with a data driven subscription.
> Unfortunately, DDS is not available in non-Enterprise edition
> installations. If you can't do DDS, the best you can do is use an
> expression like ="No data available to report" in the NoRows property.
> The subscription email still goes out but the report contains an
> explanatory message instead of a blank page.
> HTH
> toolman
> Corvallis wrote:
> > Any idea how to have a Report Subscription only email the report or link if
> > there are records returned by the reports query or dataset?
>