Two separate data in a detail section??? 1

[soweyoung]

Hi all.
I am developing a .net web appplication that has a crystal report in it.
My report needs three tables in order to display all information I want on it.
One master table and two separate detail tables.
The master table has a parent-child relationship with the two detail tables and two detail tables has no relationship at all.
What I am trying to do is I want to display all master table data on the report header and two separate detail table data in the detail section.
I have no problem getting master data into the report header, but I can't think of any way to get the two detail table data into the detail section for each detail table data with their own headings.
I have tried grouping, but I guess it not the way to do.
How do I achieve this?

 

[lbass]

If you want to show all the details from one table first and then all the details from the other, then use a subreport for the second detail table, and place it in the report footer--assuming you really meant you were placing all master table data in the report header.

If you meant you are grouping by some master table field, you would use the detail section for the first detail table, and then add the subreport with the fields from the second table to the group footer, linking the subreport to the main report on the group field.

-LB

 

[soweyoung]

Thank lbass.
I thought about using a sub report but I wasn't sure if there would be some other options.
You gave me a clear idea with it.
Thanks again.