Displaying records from different querries

[rockadudele]

Hi

I am not sure how I should approach this issue. I am able to display my records in a datagrid as shown in the image. I would like to display it in the same format on a Crystal report.

Each of these data grid is a querry and is stored in a dataset. I would like to show the 'Controls' column right after the 'Hazards' column. All the colums have a reference ID by which they are filtered.

Do I use subreports to display this?

Do I write all this data into another table and then display them as a report?

You expert advice i most valued.

I'm using VB.net 2003 and Crystal reports for visual studio

Thanks

http://tapfoundationinternational.com/images/Report-screenshotCrop.gif

[riteshjain1982]

can u repost image,seems link in broken

[ranganadhkodali]

Yes, simple assume that all three will datagrids will be three reports and .. insert all these 3 reports into the main report with subreport concept