December 7, 2015 at 12:40 am
Hi All,
So this morning I got this requirement where I need to run a report each time for values stored in my table as parameter values and export this to a location.
DETAILS :
The report has one parameter for which there could be 100 values. I need to store these values in my SQL Table and should be able to read the values from this table and run the report 100 times for these 100 values and then automatically exported to excel to a predefined location.
e.g. Report has parameter called Country. The values for this parameters would be FRANCE, GERMANY etc...
I can store these values in a table t_country and would try to read it in the parameter values and run the report (either on demand or scheduled to run every day, thats not imp for now)
Storing the 100 available values in Table is not mandatory, if there is another option to do thats fine as well.
Am I missing something really simple ?
While I am checking the feasibility of this I would also like to know any suggestions on this. Thanks in advance for your help.
Regards,
Athar Iqbal
December 7, 2015 at 3:54 am
Hi,
If you are using Enterprise Edition this is a perfect use-case for Data Driven Subscriptions.
Check out the MSDN article for more details: https://msdn.microsoft.com/en-us/library/ms159150.aspx
December 8, 2015 at 4:39 am
Hi,
Data Driven subscription it is then. Thanks.:-)
I successfully managed to create one and got my reports in excel format.
Even after working with SSRS for long now I never actually used this feature. Glad that it came to use at perfect timing.
Regards,
Athar
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply