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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!