Creating reports and dashboards | Stimulsoft community forum

Hello people,
I need an advice. I have to create a report FOR ALL the employees of my company, with a lot of information.
This information is represented with n. 5 data source.
The Data Sources are the result of very complex mysql queries. All have a field in common (cod_dipende).
In detail, these data sources contain this information:

Data Source1: little personal data - 1 record for each cod_dipende
Data Source2: month stamps - 28-31 records for each cod_dipende
Data Source3: totals of the month - 1 record for each cod_dipende
Data Source4: annual summary - 12 records for each cod_dipende
Data Source 5: annual totals - 1 record for each cod_dipende

What tools do you recommend to use?

Thank you

Hello,

You can try to use the master-detail construction, where master will contain only cod_dipende information.

Thank you.