Help: want to check if the report has any data

Hi ,
I have some Reports that don't always return data.
I want to check if the report returned any data and if it does then
send it out the plp on the subscription list.
What would be the best way to approach exception reporting In RS ?This has been requested a lot and unfortunately there is no good way to do
this. The only way to achieve this would be through Data Driven
subscriptions. The query used for the subscription would need to return no
rows if the report will not have any data. This is a pain because the query
could be difficult to write (and not possible if there are multiple data
sets in the report) and the query could become out of date if the report
query changes.
We are looking to add this functionality to a future release.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Suket" <Suket@.discussions.microsoft.com> wrote in message
news:EA2DE894-359E-4FD5-875F-20484C70B90D@.microsoft.com...
> Hi ,
> I have some Reports that don't always return data.
> I want to check if the report returned any data and if it does then
> send it out the plp on the subscription list.
> What would be the best way to approach exception reporting In RS ?
>
>|||That would be excellent Daniel. A great improvement on a great product.
regards
Matt
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ea4HRuXeEHA.236@.tk2msftngp13.phx.gbl...
> This has been requested a lot and unfortunately there is no good way to do
> this. The only way to achieve this would be through Data Driven
> subscriptions. The query used for the subscription would need to return
no
> rows if the report will not have any data. This is a pain because the
query
> could be difficult to write (and not possible if there are multiple data
> sets in the report) and the query could become out of date if the report
> query changes.
> We are looking to add this functionality to a future release.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Suket" <Suket@.discussions.microsoft.com> wrote in message
> news:EA2DE894-359E-4FD5-875F-20484C70B90D@.microsoft.com...
> > Hi ,
> >
> > I have some Reports that don't always return data.
> > I want to check if the report returned any data and if it does then
> > send it out the plp on the subscription list.
> >
> > What would be the best way to approach exception reporting In RS ?
> >
> >
> >
>|||Hi Daniel,
As a further comment on this, (I'm sure you guys have thought of it but just
in case):
Sometimes, we want to notify the user (particularly in the case of external
clients) that there is no data for a given report, other times we would just
not send the email. It would be great if you can supply these options.
Perhaps even the ability to supply a custom message.
many thanks
Matt
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ea4HRuXeEHA.236@.tk2msftngp13.phx.gbl...
> This has been requested a lot and unfortunately there is no good way to do
> this. The only way to achieve this would be through Data Driven
> subscriptions. The query used for the subscription would need to return
no
> rows if the report will not have any data. This is a pain because the
query
> could be difficult to write (and not possible if there are multiple data
> sets in the report) and the query could become out of date if the report
> query changes.
> We are looking to add this functionality to a future release.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Suket" <Suket@.discussions.microsoft.com> wrote in message
> news:EA2DE894-359E-4FD5-875F-20484C70B90D@.microsoft.com...
> > Hi ,
> >
> > I have some Reports that don't always return data.
> > I want to check if the report returned any data and if it does then
> > send it out the plp on the subscription list.
> >
> > What would be the best way to approach exception reporting In RS ?
> >
> >
> >
>|||Hi Suket,
one of the things we are doing is putting a comment in the report which
indicates there is no data. It's a bit cludgy, but for the time being it's
the only thing we could come up with.
cheers
Matt
"Suket" <Suket@.discussions.microsoft.com> wrote in message
news:EA2DE894-359E-4FD5-875F-20484C70B90D@.microsoft.com...
> Hi ,
> I have some Reports that don't always return data.
> I want to check if the report returned any data and if it does then
> send it out the plp on the subscription list.
> What would be the best way to approach exception reporting In RS ?
>
>