Render report automatically in MS Excel
I have built a report and all is well with the information that is populated on this report. My users like to see their report within MS Excel instead of the native view therefore, they ALWAYS export the report to MS Excel after it has populated the report
with information.
Is there a way where i can automatically display the report in MS Excel rather than have it display in the native view and then have the users export it to MS Excel?
Let me know,
Macha.
September 29th, 2010 7:02pm
Look at SSRS Subscriptions
Free Windows Admin Tool Kit Click here and download it now
September 29th, 2010 7:29pm
I have built a report and all is well with the information that is populated on this report. My users like to see their report within MS Excel instead of the native view therefore, they ALWAYS export the report to MS Excel after it has populated the report
with information.
Is there a way where i can automatically display the report in MS Excel rather than have it display in the native view and then have the users export it to MS Excel?
Let me know,
Macha.
Hi macha73,
Based on your requirement, I think CincyMark’s reply has given the right direction. With subscriptions you could customize
the distribution of a report based on dynamic subscriber data and distribute reports to a specific group of recipients based on predefined criteria.
For more information of details steps, please refer to these links:
http://technet.microsoft.com/en-us/library/aa237461(SQL.80).aspx
http://msdn.microsoft.com/en-us/library/ms169673.aspx
Thanks,
Challen Fu
October 6th, 2010 8:50am
I wrotre a blog about the subject
http://dimantdatabasesolutions.blogspot.com/2009/02/how-to-render-report-to-pdfexcel-format.htmlBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
October 6th, 2010 8:54am