VisualStudioFeeds

All Visual Studio blogs in one place

AddThis Social Bookmark Button
As we know, we can easily export SSRS reports to excel file.  But, sometimes there is a user requirement to automatically refresh the data in the excel file when user opens the file again. Robert Bruckner has written this excellent post for doing this using inserting a image file into the World or Excel.  http://blogs.msdn.com/b/robertbruckner/archive/2010/03/20/refreshable-reports-in-word-powerpoint-excel.aspx But, now as per post it will become an image and it will not be possible to do any further calculations in excel file which will be needed by analysts sometime.  The one workaround to this problem can be a Macro in excel file. Let’s see
how to do this: Reports can be directly executed from URL and we can also pass parameters and rendering format details in URL. For more details on this, you can refer http://msdn.microsoft.com/en-us/library/ms153586.aspx Now,  As we can take any of the report and try to call it from URL. You can find this report attached below. For Example,
http://gnsez-pc-158/ReportServer?/Mytest/MultivlaueParameter&rs:Command=Render&ReportParameter1=1&rs:Format=CSV Here, we are exporting it to CSV to get data irrespective of page break, but we can use excel if report has charts and report do not have page breaks. Now, We can start creating VBA code in Excel file. To write the code in excel...(Read whole news on source site)

Search

Subscribe

Enter your email address:

Delivered by FeedBurner

Increase your website traffic with Attracta.com

Contact

Email:
Subject:
Message:
Anti-spam: How many eyes has a typical person?

Follow us on FB

Home : Blog List : Chintak's Blog : Refreshable SSRS reports in Excel