Subtotals in a crosstab with iReports

[luisrpp]

Hi All,

Does anybody knows how to create a crosstab with subtotals using iReports? Is it possible or, by definition, crosstabs can not have subtotals?

I need something like this:

                                             Person A                        Person B              ...

Class 1       Product 1.1        1                                        1

                     Product 1.2         1                                       2

            Subtotal                        2                                       3

Class 2       Product 2.1        3                                        2

                     Product 2.2         1                                       2

            Subtotal                        4                                       4

Total                                          6                                       7

 

And that is what I have so far:

                                             Person A                        Person B              ...

Class 1       Product 1.1        1                                        1

                     Product 1.2         1                                       2

Class 2       Product 2.1        3                                        2

                     Product 2.2         1                                       2

Total                                          6                                       7

 

Thanks in advance,

Luis

[kchaudhry]

Assuming that  Class1 and Class2 are groups in your crosstab, you should be able to add subtotals.

Right click on the crosstab then go to crosstab properties > Row and column groups > double click on the "Class" group then go to "Print the group total at this position" and select your desired position.

Hope this helps!

[bussard]

Hi kchaudhry,

Do you know where can I find this property in iReport 3.5.1 ??

[dgangstaz]

 No

[gopalreddy436]

Hi kchaudhry, Do you know where can I find this property in iReport 4.7.1 ??