grouping over multiple columns in dynamicJasper

Question

Hello, i have a problem of creating 1 group that "spand" over multiple colums in dynamicJasper. Example would be something like this:

i get data from base, which i can not change:

id1      id2       id3         id4     id5

1       Vega    Steve      8,000.23    yes

1       Vega    Steve      3,465.33    yes

2       Minson  Mark     123,987.23    no

2       Minson  Mark       3,465.33    yes

5       Lucky   Luck   3,123,465.33    no

after grouping over first 3 columns report would look like this:

id1      id2       id3         id4     id5

1       Vega    Steve      8,000.23    yes

                           3,465.33    yes

2       Minson  Mark     123,987.23    no

                           3,465.33    yes

5       Lucky   Luck   3,123,465.33    no

Is this possible to achieve in dynamicJasper?

Answer 1

yes its possible.

You can generate a group by a report.

GroupBuilder gb = new GroupBuilder(); DJGroup g = gb.setCriteriaColumn((PropertyColumn) columnname) .setGroupLayout(GroupLayout.VALUE_IN_HEADER) .build(); .firstReport.addGroup(g);

you can add multiple groups.

create the same code for next column. and please add it in the order of there grouping level. like first add company, then department and then designation.