I am trying to implement a report delivery mechanism which is file based. So the report will be generated in pdf or excel and placed in file share location. The name of the file needs to be dynamic. For e.g. : if the report I am running is Daily sales for store 101 with a sales amount of $150 and for the date 03/22. I need to generate a pdf with file name dailysales_101_150_032210.pdf
There are some parameterized report generation scenarios as well. In that case the report name should include the parameters provided. In the above example itself if all the values above are provided as parameter, the report should be generated for the given parameter and the name should contain the parameter.
Has anyone had this requirement and implemented a solution before ? Can this be implemented in a standard subscription & data driven subscription. any custom code is required in order to implement this or can this be done by configuration in SSRS ?
thanks for your help.
View Complete Post