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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics