March 3, 2010 at 12:08 pm
How to move the data from SSRS Report to Specific Cell of Specific Sheet of an Excel File. Please Suggest?
March 5, 2010 at 10:03 am
I don't think you can do this with SSRS. When you render to Excel, it will try to create an Excel file with a format similar to the report. If you want to create a Excel file with specific data in specific places, you may need other tools like VB, C#. You can also connect to a DB from Excel, and populate data from there.
March 5, 2010 at 10:14 am
Ya been there. The only to export the report from SSRS is with the export button or with a subscription.
From there on out you can always save the file to a drive or shared folder... and then go into the excel file and do changes programmatically. That's the only way I know that may work (never done it myself... but I'm sure you could start a job to check for file existance before starting a process, which means it should be doable.)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply