I'm working on a report with multi level data.
let's 4 levels: project level, subproject elvel, component level and item level.
report need to display:
Project name and 3 other project leel data fields
subproject associated with each project, and other subproject level data fields
component associated with each subproject, and other component level data fields
item associated with each component, and other item level data fields
I was thinking to build 4 levels of drill down to display each level, but each level has its own level fields to display, which make column title issue. Then I thought about subreport, but I still have no idea.
How to display or make the report? What would be the normal way to deal with such kind reports? Please help.