merge cells with same values оn previous column row

[UUsatova]

I have a list of data retrieved from a database that contains a lot of redundancy. The data includes fields such as user, users access groups, access levels within each group, and doors within each access level. When there are identical values across multiple rows, i wanna to merge those values. However, the merging should happen within the record of the previous column.

Does anyone know if it is possible to do this with dynamic jasper

[danielpeintner]

I am not sure if there is a way to do it with Dynamic Jasper but you can always do it yourself by iterating over each row and remembering the last value per column.

[UUsatova]

Thanks for your answer, but I export my report in different formats like pdf, xlsx, docx, At what stage should I do iterating? After converting my DynamicReport into JasperPrint?

[danielpeintner]

You can remove the data before giving it to DynamicJasper.

Anyhow, I think you can also use "groups" in DynamicJasper and it does it for you.
see https://github.com/intive-FDV/DynamicJasper/blob/master/docs/getting-started.md ..see "ar.com.fdvs.dj.test.GroupsReportTest"