How do I get the totals in a matrix to export to csv in SSRS 2005

Question

Hi,
I am using SSRS 2005
I have a matrix which consists of Subtotals... When i export my matrix to a CSV i get all the columns except the totals.. How do i get the Totals to show up in the CSV..

I tried using puting the an expression in the total column like ="Total" and tried the setting the DataElementOutput to Output and i also select the green mark and set the dataelementoutput to output and still dont see the total column in the csv file..

What am I doing wrong?

Any help will be appreciated.
Thanks,
Karen

Answer 1

Hi Karen,

Currently, there is no way to get the subtotal of matrix exported to CSV in SSRS 2005. This is allowed in SSRS 2008.

I found two workaround as follows, please see if it helps;

One is to export your report to Excel first and then change the excel extension name to .csv .

Another is to pivot your table into the "matrix" format and then using the table control to place these "matrix" data, and the export will have the "subtotal" data.

See http://msdn.microsoft.com/en-us/library/ms177410.aspx for more details on how to use pivot and unpivot.

Hope this help.

thanks,
Jerry