Automate SSRS report

5 pts.
Tags:
Microsoft Visual Studio
SSRS reports
I have a monthly task where I have to run an SSRS report for each contractid we service and export each one to excel.  The problem is that there are over 800 contracts and the tool only allows me to enter 1 at a time.  I would like to somehow enter maybe 50 contractid's and have the tool run each one and export to excel, then move to the next one in the list.  I'm guessing this is best done with a stored procedure but I don't know enough about writing the script to know what to write and where it would go to execute properly.  Any suggestions would be appreciated. Thanks

Software/Hardware used:
Visual Studio 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

You might be able to pass the values for all of the contractid’s at the same time, then split them in the report so that it runs for all of them at the same time.

Then you can set up the reports to automatically send and you won’t have to do anything manually…I love technology!

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following