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