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
Report with Groups very complex
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Report with Groups very complex
Hello,
You can try to use the master-detail construction, where master will contain only cod_dipende information.
Thank you.
You can try to use the master-detail construction, where master will contain only cod_dipende information.
Thank you.