SSRS Hierarchy
Hi there, I have a production report with a simple matrix using row hierarchy, when i export for excel it brings all lines of hierarchy even if toogle is "+". Anyway i export what is expanded? Or exactly what is on screen? Fabrizzio A. Caputo MCT Certificaes: Oracle OCA 11g MCITP SQL Server 2008 Implementation and Maintenance MCITP SQL Server 2008 Developer Blog Pessoal: www.fabrizziocaputo.wordpress.com Blog Empresa: www.tripletech.com.br/blog Twitter: @FabrizzioCaputo Email: fabrizzio.antoniaci@gmail.com
November 28th, 2012 11:13am

Hi Fabrizzio, This issue is not related your operation or your report design. This is a common issue. I have tested it on my test environment (SQL Server 2012 and Microsoft Office 2010), it does not support recursive hierarchy in Excel. If you have any concerns about this feature, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Thank you for your understanding. Regards, Charlie Liao If you have any feedback on our support, please click here.Charlie Liao TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 28th, 2012 10:36pm

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

Other recent topics Other recent topics