identify all the properties and the corresponding classes which you want to show in the grid then use the data access tab on a report definition to join the classes to get the required output. if you need to drill down use a summary view instead.

The base line is you need to identify the key's on which you need to join the DB tables which will give you the desired output.

Thanks!

Thanks for the response.

I have the report definition working and have the classes identified but it requires grid at two levels which looks like i can achieve with a pagelist only

The requirement is

Pagelist (Parent)

Case ID | Status | Assignee | Account Name

    Pagelist(Child1)

             Sub Case ID | Status | Assignee | Account Name

    Pagelist(Child2)

             Sub Case ID | Status | Assignee | Account Name