SSRS 2008 R2 - report extract to excel repeat group by columns ?
Hi, I have SSRS 2008 R2 10.50.1753 on SharePoint 2010 integrated mode.
I have a report with Matrix on it and matrix has few GROUP BY columns/rows. Report display correct group by and data on IE but when it extracts to excel, it generate extra GROUPING colmuns into it (for two group by columns in matrix, it extract two group by
correctly and extract same two columns as duplicate next to it). Any idea why SSRS 2008 R2 doing 'duplicate' or 'repeating' column grouping in excel format? Thanks.
April 18th, 2011 3:19am
Hi KM IT,
Do you apply visibility toggle on the column groups? If so, I’m afraid by design an extra row for each group is generated for subtotal. For more information and workaround,
please refer to the official confirmation at
http://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok
However, if you haven’t applied any toggle in the report or I have something misunderstood, please point out, and also post an example to show the matrix structure.
Then, I will try to reproduce the issue and provide you further assistance.
Thanks,
Tony Chain
Tony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2011 11:06pm
Hi, Yes I have visibility toggle on column groups. Example:
+Account
CodeLevel1
Account CodeLevel2
Month-Year Date Amount
+Debit
Account
Db Acc1 Db Acc2 Db Acc3
January-2010 01-Jan-2010 50.12 78.25
33.44
02-Jan-2010
80.78 12.23 87.10
03-Jan-2010
63.78 25.69 12.00
Any idea why it repeating group by column when exprt to excel? Thanks.
April 18th, 2011 11:49pm
Hi,
Thank you for providing the example. I also did a test on a report within the similar matrix, and got the following result in exporting Excel
Debit Account
Db Acc1
Db Acc1
Db Acc1
January-2010
01-Jan-2010
50.12
78.25
33.44
161.81
02-Jan-2010
80.78
12.23
87.10
180.11
03-Jan-2010
63.78
25.69
12.00
101.47
The last column for each column group shows the total of it. This total column is generated atomically by design. If you get the same result, I would recommend you read the official
confirmation at
http://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok. If not, please also point out.
Thanks,
Tony Chain
Tony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2011 4:02am