I'm working with database table where is for example workers number, name, main contractors number and contact person, subcontractors number and contact person, our contact person etc.
I need report where data is grouped in 4 levels by:
Our contact person
Main contractor and contact person
Subcontractor and contact person
Can I do this so that data is in one database component or shall I need many components?
I get this almost work with 4 query components but if our contact person have many main contractors, only first one is printed on report and also if main contractor have many subcontractors, only one is printed.