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

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

Other recent topics Other recent topics