Greetings, I'm trying to make a report which has a group field and also subreports. My report has Group Header - Detail - Group Footer, and I have 9 subreports inside the detail.
In the main report I can group data by staffId, but I have to do the same in all of the subreports. My data source is prepared in Java and sent to the report as a parameter. For both the main report and the sub reports, the data source includes data of all staff, so when I choose the staffId as group expression, I got one page full of data for each staff member, which is what I want. But I cannot do this in the subreports.
The whole content of data source of the subreports is shown just in the first page (which means in the first staff member page) and the data is null for the remaining pages.
I have to group the data by the staffId in the subreports as well, and show each data only in the appropriate page for the staff member.
I hope I was able to explain it clearly. Please tell me what I can do, thanks in advance.
I solved the problem. The solution was setting the subreport data sources as fields in my main DTO and use them in the report accordingly.