asked on

How to Automatically Run Same report Multiple times with Parameter changing each time

Hi there,

I have a report I run for my clients - when I run it I choose client name from a list and run.
What I want to do is create a subscription monthly that will run the report for all the clients and then store the reports in a file share.

Is this possible?
Do I need to do it in the report itself and basically get the report to run for each client or do you do in SQL Reporting Services.

Thanks

Michael

tigin44

you can do this in an sql job. Define the process (generating reports, deleteing or archiving the old reports saving the reports to file system, mailing the reports to subscribers etc.) that will execute in a stored procedure. Cretae a job. call the procedure that you defined and schedule the job runing times.
Regards.

mickinoz2005

ASKER

Hiya tigin44.

thanks for that but could you give me a little more detail or little bit more instructions on what needs to be done. I am relatively new to this whole process.

From a stored procedure in SQL SErver can I call a report to run with parameters? I could then schedule that job to run in SQL Agent.

Or am i totally on the wrong track here.

Michael

ASKER CERTIFIED SOLUTION

shorak

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mickinoz2005

ASKER

Hiya,

I just discovered a problem I have to overcome first and that is that Data Driven Subscriptions are not supported in Standard SQL only Enterprise

I will rectify this and then give it a go.

Thanks for your help.

michael

mickinoz2005

ASKER

thanks have not been able to try it yet but appreciate the effort.