Email report ONLY if there are records ?

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?You would need to do this in a data driven subscription.
Brian Welcker
MSFT
"steve" <steve@.discussions.microsoft.com> wrote in message
news:74944DC2-1C3F-44C0-9E6B-1625D6641E0B@.microsoft.com...
> 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?
>sql

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?
>

EM not see all users from PC but I do on the server

Hi,I have no idea on why this is happening. From my pc using EM in drill int
o
a DB and under user I only see two users. Now when I do the same on the
server I see everyone. I have removed and reinstalled EM on my pc with the
same results. Any help would be great. Thanks for your time.CW wrote:
> Hi,I have no idea on why this is happening. From my pc using EM in
> drill into a DB and under user I only see two users. Now when I do
> the same on the server I see everyone. I have removed and reinstalled
> EM on my pc with the same results. Any help would be great. Thanks
> for your time.
SOunds strange, but are you using the same login registration
information on both PCs? Also, ahve you installed the same SQL Server
service pack on your PC that you are using on the server?
David Gugick
Imceda Software
www.imceda.com

EM not see all users from PC but I do on the server

Hi,I have no idea on why this is happening. From my pc using EM in drill into
a DB and under user I only see two users. Now when I do the same on the
server I see everyone. I have removed and reinstalled EM on my pc with the
same results. Any help would be great. Thanks for your time.
CW wrote:
> Hi,I have no idea on why this is happening. From my pc using EM in
> drill into a DB and under user I only see two users. Now when I do
> the same on the server I see everyone. I have removed and reinstalled
> EM on my pc with the same results. Any help would be great. Thanks
> for your time.
SOunds strange, but are you using the same login registration
information on both PCs? Also, ahve you installed the same SQL Server
service pack on your PC that you are using on the server?
David Gugick
Imceda Software
www.imceda.com

EM not see all users from PC but I do on the server

Hi,I have no idea on why this is happening. From my pc using EM in drill into
a DB and under user I only see two users. Now when I do the same on the
server I see everyone. I have removed and reinstalled EM on my pc with the
same results. Any help would be great. Thanks for your time.CW wrote:
> Hi,I have no idea on why this is happening. From my pc using EM in
> drill into a DB and under user I only see two users. Now when I do
> the same on the server I see everyone. I have removed and reinstalled
> EM on my pc with the same results. Any help would be great. Thanks
> for your time.
SOunds strange, but are you using the same login registration
information on both PCs? Also, ahve you installed the same SQL Server
service pack on your PC that you are using on the server?
--
David Gugick
Imceda Software
www.imceda.com