November 13, 2013 at 2:10 am
Hi,
I have a subscription created on SQL 2012 and the export in excel is saving the reports in Excel 2003 version rather than Excel 2007/xlsx.
Can you please help me where to change the settings.
Regards,
Ankit
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
November 13, 2013 at 2:30 am
Create, Modify, and Delete Standard Subscriptions (Reporting Services in Native Mode)
What did you select for render format?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2013 at 2:59 am
Excel
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
November 13, 2013 at 3:38 am
Is there no Excel 2007-2010 option?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2013 at 3:44 am
No I guess
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
November 13, 2013 at 3:48 am
Are you sure you are using SSRS 2012?
According to this article, you'd have to explicitly enable Excel 2003.
http://msdn.microsoft.com/en-us/library/dd255234.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2013 at 4:18 am
Thanks K,
I hope the solution is :-
Use the Excel renderer (xls) by changing the value of Visible to true, in the following line in the RSReportServer.config file.
<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="true"/>
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
November 13, 2013 at 4:25 am
You'll need that rendering option if you want to export to Excel 2003. Is that what you want?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2013 at 8:59 am
Either use RenderFormat = ExcelOpenXML
or Excel in ReportServices.config file add Visible = "false"
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply