Dont send empty squeduled emails.

Hi
I need to squedule the sending of a report.
My customers does not want empty reports.
How can I cancel the sending of the squduled report if the result has no
rows ?
I found this but dont think it is pretty:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
Any idears ?
--
Best regards
MikaelYes, use a data-driven subscription.
Are you using Standard or Enterprise version of Reporting Services?
=-Chris
"Mikael" <Mikael@.discussions.microsoft.com> wrote in message
news:B2194F7E-2BE9-46B4-84A2-15D7EEADA822@.microsoft.com...
> Hi
> I need to squedule the sending of a report.
> My customers does not want empty reports.
> How can I cancel the sending of the squduled report if the result has no
> rows ?
> I found this but dont think it is pretty:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
> Any idears ?
> --
> Best regards
> Mikael|||Hi
We are using a standard version of Reporting Services.
Also we query a SQL2000 server for data.
Can a data-driven sunscription also be "Squedulet" so the cursomers recive
the report at a specific time ?
--
Best regards
Mikael
"Chris Conner" wrote:
> Yes, use a data-driven subscription.
> Are you using Standard or Enterprise version of Reporting Services?
> =-Chris
> "Mikael" <Mikael@.discussions.microsoft.com> wrote in message
> news:B2194F7E-2BE9-46B4-84A2-15D7EEADA822@.microsoft.com...
> > Hi
> >
> > I need to squedule the sending of a report.
> > My customers does not want empty reports.
> > How can I cancel the sending of the squduled report if the result has no
> > rows ?
> >
> > I found this but dont think it is pretty:
> >
> > http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
> >
> > Any idears ?
> >
> > --
> > Best regards
> >
> > Mikael
>
>|||The standard edition does not support data-driven subscriptions. :(
You will have to come up with another way to do it.
=-Chris
"Mikael" <Mikael@.discussions.microsoft.com> wrote in message
news:E2C60101-F1E7-4867-9DA4-3B711DE7C83E@.microsoft.com...
> Hi
> We are using a standard version of Reporting Services.
> Also we query a SQL2000 server for data.
> Can a data-driven sunscription also be "Squedulet" so the cursomers recive
> the report at a specific time ?
> --
> Best regards
> Mikael
>
> "Chris Conner" wrote:
>> Yes, use a data-driven subscription.
>> Are you using Standard or Enterprise version of Reporting Services?
>> =-Chris
>> "Mikael" <Mikael@.discussions.microsoft.com> wrote in message
>> news:B2194F7E-2BE9-46B4-84A2-15D7EEADA822@.microsoft.com...
>> > Hi
>> >
>> > I need to squedule the sending of a report.
>> > My customers does not want empty reports.
>> > How can I cancel the sending of the squduled report if the result has
>> > no
>> > rows ?
>> >
>> > I found this but dont think it is pretty:
>> >
>> > http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
>> >
>> > Any idears ?
>> >
>> > --
>> > Best regards
>> >
>> > Mikael
>>|||Thank you for trying :)
So I need to cancel the sending of a report it the result of the report is
emty.
Any idears ?
--
Best regards
Mikael
"Chris Conner" wrote:
> The standard edition does not support data-driven subscriptions. :(
> You will have to come up with another way to do it.
> =-Chris
>
> "Mikael" <Mikael@.discussions.microsoft.com> wrote in message
> news:E2C60101-F1E7-4867-9DA4-3B711DE7C83E@.microsoft.com...
> > Hi
> >
> > We are using a standard version of Reporting Services.
> > Also we query a SQL2000 server for data.
> >
> > Can a data-driven sunscription also be "Squedulet" so the cursomers recive
> > the report at a specific time ?
> >
> > --
> > Best regards
> >
> > Mikael
> >
> >
> > "Chris Conner" wrote:
> >
> >> Yes, use a data-driven subscription.
> >>
> >> Are you using Standard or Enterprise version of Reporting Services?
> >>
> >> =-Chris
> >>
> >> "Mikael" <Mikael@.discussions.microsoft.com> wrote in message
> >> news:B2194F7E-2BE9-46B4-84A2-15D7EEADA822@.microsoft.com...
> >> > Hi
> >> >
> >> > I need to squedule the sending of a report.
> >> > My customers does not want empty reports.
> >> > How can I cancel the sending of the squduled report if the result has
> >> > no
> >> > rows ?
> >> >
> >> > I found this but dont think it is pretty:
> >> >
> >> > http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6d60055b22dbc4d6/cab5eb50a63735fa?lnk=st&q=%22Reporting+Services%22+dont+send+email&rnum=28#cab5eb50a63735fa
> >> >
> >> > Any idears ?
> >> >
> >> > --
> >> > Best regards
> >> >
> >> > Mikael
> >>
> >>
> >>
>
>