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

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

Other recent topics Other recent topics