none
Grouping in Report Viewer RRS feed

  • Question

  • 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
    Tuesday, October 6, 2009 8:11 AM