Designer Subreports Duplicating Data

Lisa Callahan

I have created a container report with HR Organization as a group. I have added subreports next to each other in the group footer to mimic a Lawson payment details report. However, Birst is not playing nice. It is duplicating the data on one of the subreports when the other subreport goes over one page.

Here is a screen shot of the container report -

The difference in the subreports is the payroll register item category. This is page 1 of the result -

And this is page 2 -

Four of the five taxable amounts are duplicated on the second page. I am not sure why - I have tried all the tricks I can think of to get this to work and I have gotten nowhere. Does anybody have any experience with doing something like this? I welcome all ideas :)

Please and thank you.

Tamas Molnar

Hi, If you would like to put 2 independent report in a report, then use header or footer, and both report should be a sub-report.

Details are for a standard report, using the sub report there can be dependent on it.