Search
Resolved
as By Design Help for as By Design

1
Sign in to vote
0
Sign in to vote
Sign in
 to vote
Type: Bug
ID: 508823
Opened: 11/6/2009 12:03:28 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
I have a report that groups with summarized values that can be toggled to hide show details. When I export the results to excel, some of the detail rows duplicate in excel, but the summarized results are fine. The report display is correct and exporting to CSV or PDF matches the report results. The same exact serenio occurs in Visual Studio 2008.
Details (expand)
Product Language
English

Version

SQL Server 2008 - Enterprise Edition

Category

Reporting Services

Operating System

Win2003 Standard Server (SP2)
Operating System Language
US English
Steps to Reproduce
1.Set the expanded parameter to Yes, to expand the details for each group.
3.Run Report and export to Excel
3.Then export via CSV and import the csv file into excel and compare the results.
Actual Results
You will see that the exported excel file has duplicate detail rows compared to the copy with the imported CSV file, with no pattern I could notice.
Expected Results
The expected results are that the exported excel file will match the report per group and line item.
Platform
32
File Attachments
4 attachments
GRIR by Business Unit.rdl.data
GRIR by Business Unit.rdl
GRIR by Business Unit using imported CSV.xlsx
GRIR by Business Unit exported to excel.xls
Sign in to post a comment.
Posted by Microsoft on 11/11/2009 at 8:07 PM
Hi,

Thank you for reporting this issue. The extra row is a generated auto subtotal that in this case is the first row of the group. The reason behind the extra row is to provide at least one row for excel that always displays regardless the toggle state.

Now there is a way to avoid it: there are two groups in the table and Group1 has a header row that can be used by Detail group as a toggle item. The attached report is almost perfect, however there is a static node that represents the detail row and it’s supposed to belong to the Detail group, instead it is a child of its parent which causes the problem.

You can fix the report: select the second column and insert a column to left. Copy the cells from the first column and delete the first column (notice a double dash line that separates the first column from the rest: it has to disappear). Don’t forget to change the name of the cell that contains “Business Unit” to Group2 to keep the toggle reference. Try to render the report.

Regards,
Krisztian Bocso
© 2009 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement