Should be easy: what's the new name of the Excel render format in SSRS 2012?
The following code for a Hidden property is never True in SSRS 2012 when I'm exporting to Excle but I'm having trouble finding a listing of the new render format names. (I want to export to the xlsx format.) What should the Name property be, please?
=(Globals!RenderFormat.Name = "EXCEL")HomeCookN
July 24th, 2012 4:43pm
The name of the new Excel renderer is EXCELOPENXML.
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2012 4:54pm
HI Home !
Your expression seems to be fine;
Please have a look at below MSDN for render formats in SSRS;
http://msdn.microsoft.com/en-us/library/ms154606.aspx
Please let me know if this helps. Hopefully i have answered you correctly.
Thanks, Hasham
July 24th, 2012 4:56pm
Thank you very much, Tristan; that's all I needed.
I guess I'm not a very good (re)searcher; couldn't find any listing of the new renderers.HomeCookN
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2012 8:19am
Thanks for your interest, Hasham, but the correct answer is:
The name of the new Excel renderer is EXCELOPENXML.
Proposed As Answer bySyed
Qazafi Anjum<abbr class="affil">Moderato</abbr>HomeCookN
July 25th, 2012 8:21am
Thanks for the correction.
<Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/>
Here is the link to get updated MSDN information;
http://msdn.microsoft.com/en-us/library/dd255234.aspx
Thanks, Hasham Niaz
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 6:32am
Thanks for the helpful link, Hasham. I appreciate your interest. We both learned something on this one.HomeCookN
July 26th, 2012 9:15am