Do we have any control over export functionality of SSRS to excel
Our requirement is to export SSRS report to excel and create pivot tables. But we found thats not possible as exported result is just snapshot and it doesnt store result set in proper excel format. Do we have any control over export functionality of SSRS to excel?
January 21st, 2011 1:14am

Hi, According to your description, I recommend that you add a matrix to display grouped data in your report. Matrices provide functionality similar to crosstabs and pivot tables. Please see: Adding a Matrix (Reporting Services) http://technet.microsoft.com/en-us/library/ms157334(SQL.100).aspx There is no control over export functionality of SSRS to excel. For more information, please see: Exporting to Microsoft Excel http://msdn.microsoft.com/en-us/library/ms159836(v=SQL.100).aspx Thanks, Ai-Hua QiuAi-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 24th, 2011 5:16am

Hi, According to your description, I recommend that you add a matrix to display grouped data in your report. Matrices provide functionality similar to crosstabs and pivot tables. Please see: Adding a Matrix (Reporting Services) http://technet.microsoft.com/en-us/library/ms157334(SQL.100).aspx There is no control over export functionality of SSRS to excel. For more information, please see: Exporting to Microsoft Excel http://msdn.microsoft.com/en-us/library/ms159836(v=SQL.100).aspx Thanks, Ai-Hua QiuAi-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
January 24th, 2011 5:16am

That doesnt solve my problem fully. @Moderator : Please close the thread
Free Windows Admin Tool Kit Click here and download it now
January 28th, 2011 8:39am

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

Other recent topics Other recent topics