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
