none
RDLC grouping problem RRS feed

  • Question

  • Hi, I have problem with grouping in RDLC report.

     

    the sql query is:

    select headstruct, struct,name,surname rate from someTable;

     

    which return data with the following structure:

    headstruct1,struct1,name1,surname1,0.1

    headstruct1,struct1,name2,surname2,0.4

    headstruct1,struct2,name3,surname3,0.9

    headstruct1,struct2,name4,surname4,0.8

    headstruct1,struct2,name5,surname6,0.9

     

    headstruct2,struct11,name6,surname6,0.1

    headstruct2,struct11,name7,surname7,0.4

    headstruct2,struct11,name8,surname8,0.9

    headstruct2,struct22,name9,surname9,0.8

    headstruct2,struct22,name10,surname10,0.9

     

    I created a table with double grouping, first by 'headstruct' and the second by 'struct' columns. It's working. It looks like

     

    headstruct1

                    struct1

                                    name1,surname1,0.1

    name2,surname2,0.4

                    struct2

                                    name3,surname3,0.9

    name4,surname4,0.8

    name5,surname6,0.9

     

    headstruct2

                    struct11

    name6,surname6,0.1

    name7,surname7,0.4

    name8,surname8,0.9

                    struct22

                                    name9,surname9,0.8

    name10,surname10,0.9

     

    The problem is how can I show summary of rates for each structure in headstruct shown below?

    I tried to add third group in the same level as second group, but found that only nested groups are allowed and the third group become nested to second one.

    headstruct1

                    struct1,0.5

    struct2,2.6

     

                    struct1

                                    name1,surname1,0.1

    name2,surname2,0.4

                    struct2

                                    name3,surname3,0.9

    name4,surname4,0.8

    name5,surname6,0.9

     

    headstruct2

                    struct11,1.4

                    struct22,1,7

     

                    struct11

    name6,surname6,0.1

    name7,surname7,0.4

    name8,surname8,0.9

                    struct22

                                    name9,surname9,0.8

    name10,surname10,0.9

     

    Thank you.

     

    Wednesday, February 23, 2011 8:30 AM