Hi,
Let say I have 3 tables:
- Time: containing employee name with hours
- Expenses: containing amount and justification
- Projects: containing a project name list for the above
If a have 2 projects, I am able to create a main report with 2 subreports where the information will be displayed :
- Project 1 Time
- Project 2 Time
- Project 1 Expenses
- Project 2 Expenses
What I am trying to achieve is:
- Project 1 Time
- Project 1 Expenses
- Project 2 Time
- Project 2 Expenses
Since each subreport do not contains the same column names, I must admit that I really don't know how to achieve this.
Thanks in advance for your help.