I am new to crystal reports. I am trying to create a crystal report from my database that is structured similar to this:

Company
JobNumber
Platform
Level
Area
Item
Component

I need to create a report from this hierarchy. Each table is linked by a foreign key. I need to be able to select the database based on the ID i pass to the report. What is the best way to create a report like this? Do I use a sub-report? Or is there a better way?

Thanks

Use drill-down report.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.