Drill down and export to excel
I have a report where within the tablix i have set up the toggle item, it currently defaults to collapse. When i view the report in report manager i get what i expect to see, a couple of single rows where they have been collapsed and all the column headings. When i export to excel the fun begins, it now shows none of the columns, they have been collapsed, as well as the rows. I have set the columns to show, so i suspect it is either an overriding setting i have missed or the export process is doing something strange. Any help would be greatfully recieved.
April 28th, 2011 8:39am

Hi jamdog, Do you mean tablix's column also has the toggle function just like row? If so please confirm with me these questions: have you update your Reporting Services? Have you make use of new feature (Globals!RenderFormat.Name ) to have a different behavior when export the report to Excel? If so please remove this, Please have a check, if the issue still exist, could you please send your exported excel, report's picture on report manager and RDL file to sqltnsp@microsoft.com with the beginning "Hi Challen", please attach this thread link as well. Once I receive your email, I will do some further troubleshooting and give you a feedback as soon as possible. Thanks, Challen Fu
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 11:39pm

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

Other recent topics Other recent topics