Weekly and Monthly Email Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DotNetGruven - 03 Aug 2006 11:45 GMT

Is Service Broker a good way to automatically create and email weekly and
monthly reports?

The content of these emails is easily generated with SQL Queries.

If so, any pointers to how this could be done.

Thanks In Advance,
geo

Reply to this Message

Kent Tegels - 03 Aug 2006 14:13 GMT

Hello DotNetGruven,

> Is Service Broker a good way to automatically create and email weekly
> and monthly reports?

Nope, not really. Reporting Services would be a better bet. Notifications
Services might be too.

Or at least less code intensive... :)

Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/

Reply to this Message

DotNetGruven - 04 Aug 2006 15:54 GMT

Thanks for your reply Kent...

Having reviewed Reporting Services (SSRS) I see that it appears to supply a
Report Designer, which is useful, but I was primarily looking to solve the
problem of periodic reports being generated automatically.

Is there something I am missing within SSRS that will meet this
requirement??

Thanks,
George

> Hello DotNetGruven,
>
[quoted text clipped - 9 lines]
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/

Reply to this Message

Kent Tegels - 04 Aug 2006 20:24 GMT

Hello DotNetGruven,

> Having reviewed Reporting Services (SSRS) I see that it appears to
> supply a Report Designer, which is useful, but I was primarily looking
> to solve the problem of periodic reports being generated
> automatically.

Once you've designed the report, you can shedule it to be run periodically
by the Reporting Services service. {0} for more information.

If you're looking for magic beans that will write the report for you, good
luck :)

{0}:http://msdn2.microsoft.com/en-us/library/ms159767.aspx

Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/

Reply to this Message