Disable HideDuplicates from Report Builder

I have some business analysts (I guess Microsoft would call them Information Workers) using Report Builder to design reports, but also as a querying tool. They often times dump the results of their reports/queries into Excel, do some crunching, and then come back to write a better report.

When the Report Builder builds groups, it inherently turns on the HideDuplicates property / element so that it only displays distinct values on the group by fields. This looks great on a report, but is impractical for Excel, where the data is going to be manipulated by row.

In the .rdl, I found the element "HideDuplicates" http://msdn2.microsoft.com/en-us/library/ms152916.aspx controls this behavior of the report. However, I cannot find any option in Report Builder that would allow an Information Worker (i.e. non-codie), to alter this property. My work around for now is to edit the .rdl manually, creating two versions of the report. Very impractical.

Any ideas or info on how to do this in Report Builder would be much appreciated.

louise

There are two things you can do:

1) Don't create groups - by default if everything is in a single group, duplicates will not be hidden.

2) Edit the RDL produced by Report Builder by hand and set the "Hide Duplicates" property as desired. Warning, reports that have their RDL changed may not load again in current versions of Report Builder.

|||

I appreciate your help, but can you be more specific?

In Report Builder, I do not see any GUI control for removing groups. They are created as you pull items over. I can see how to remove groups in the .rdl. But, my current work around of removing the HideDuplicates property is the same amount of work.

Thanks,

louise