Hi,

I have a problem with the default grouping the report viewer is doing. My data table looks something like this:

- Customer 1      
   - Article 1          10.0       20.0      30.0
   - Article 2            0.0        5.0        5.0
- Sum                   10.0      25.0      35.0
- Customer 2      
   - Article 1          20.0       30.0      40.0
   - Article 3          10.0        5.0        5.0
- Sum                   30.0      35.0      45.0

This is what I expect to see in the report viewer. However, a grouping by name is performed for the first column, and all the Sum rows are collapsed under a single group.


- Customer 1      
   - Article 1          10.0       20.0      30.0
   - Article 2            0.0        5.0        5.0
- Customer 2      
   - Article 1          20.0       30.0      40.0
   - Article 3          10.0        5.0        5.0
- Sum                  
                           10.0      25.0      35.0
                           30.0      35.0      45.0

This is not OK, since the report becomes meaningless. Then I can have for instance customers with the same name. Instead of seeing 2, I see only 1. Their data is mixed.

So is there any setting to stop this grouping? Thank you.
Microsoft MVP VC++ | www.mariusbancila.ro/blog | www.codexpert.ro