how to export matrix to excel without the subtotal?
hi, we need to export a matrix that has subtotals to excel, but to download it without the subtotal groups so we can analyze the data in excel (pivot it, add graphs, etc.). how can we control the way the excel is being created?
January 2nd, 2008 2:55pm

Hi, I dont think you can control the way of rendering .What is there in your privew the whole thing will be rendered to excel or any other format through the "Rendering extensions." So you can't controll something not to come in excel view rather you can control in the reporting level and then export to excel. I dont know about the rendering extensions like which language those are written,can we change those going to the report server or not? Anyway you can give this issues to the microsoft giants. Please let me know if you are getting any solutions to this. Thanks Mahasweta
Free Windows Admin Tool Kit Click here and download it now
January 2nd, 2008 3:51pm

Actually the additinal sub total does not show in Report Viewer. But when we export the report to Excel then they appear in Excel (Magically). We are also stuggling with ways to remove these additional sub totals. We were expecting WUSIWUG (What you see it what you get). Apparently this not the case with export to excel for matrix report. Reporting Services Rendering engin assumes that we need sub totals and it adds automatically (IF we need it then we would have added to the report in design) Thanks, Anthony Desa
June 23rd, 2010 5:34pm

install update 5 for SQL Server 2008R2. http://support.microsoft.com/kb/2462084
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2011 11:50am

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

Other recent topics Other recent topics