Running a report for mulitple clients

[samiam07]

Using SQL Server 2008 SP2, SSRS 2008 SP2

I have a working report with multiple tables, charts, etc.
The end result is exactly what it should be....for a single client. We have almost 100 clients and growing, so I need to run this report for each client.

I don't want to run one at time, nor is it practical to set up a subscription for each client. Just the maintianence would be a nightmare.

There must be way to run this report for each client in some kind of automated way.
I've looked at running them via a command prompt, but have not been able to get that to run.

Is there a way to create a SQL command that would pull in all the client id's and call the report once for each client?

Any guidance or assistance would be appreciated.
sam

 

[xlbo]

Yup - you need to create a data driven subscription

See this:

http://msdn.microsoft.com/en-us/library/ms169972.aspx

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question