Merge result rows with Jasper

[amol28kulkarni]

I am new to Jasper reporting and I have a scenario where a result set returned from table is like:- 

FirstName    LastName           Stream

John              Taylor                    MSIT

John              Taylor                     MSMech

I am using Jasper studio and sql to retrieve results and fields.

On Generation of the report. I see the report like

FirstName:John

LastName:Taylor

Stream:

MSIT

FirstName:John

LastName:Taylor

Stream:

MSMech

 

but what I expect instead is something like

FirstName:John

LastName:Taylor

Stream:

MSIT

MSMech

How can I achieve this? do I need to modify the query or is there any provision in Jasper to merge the common records to one ?

Do I need to write a custom class. From what I have heard from the team is Pentaho did this automatically but we want to use jasper and are trying to migrate to jasper.

Please help and let us know the best possible solution .

Thanks

[rajesh.sirsikar]

Its simple...Create a Group on the First Name field...I created a CSV file with the example you provided above and created a report. Check it.

Rajesh Sirsikar(www.rajeshsirsikar.com)