New table for new value for Grouping

[edward.lee_1]

I am using iReport Designer to develop the report. Table is used to display the result. Below is the sample of my data set:

Coupon ID, Store ID

29 1328

32 3035

37 3035

37 1328

37 1328

 

I would like to group Coupon IDs at different tables.

 

It will be something like the following:-

Table A

Coupon ID, Store ID

29 1328

 

Table B

Coupon ID, Store ID

32 3035

 

Table C

Coupon ID, Store ID

37 3035

37 1328

37 1328

 

Can iReport Designer be done? Please advise.

 

Thanks!