What reporting package are you using?
If you are using Crystal.NET, you can do the following:
1. Place your data in a DataSet, with relationships between the various
DataTables. Note that Crystal.NET can handle only multiple DataTables
that have parent / child relationships, so if you have three tables,
they must be grandparent / parent / child, or (if you prefer) major
header / minor header / detail. You can't report on multiple
stand-alone tables.
2. Use the WriteXmlSchema() method of the DataSet to write out the XML
schema corresponding to your DataSet tables.
3. Design a Crystal report in your project using the data source: Other
Data Sources, ADO.NET, and then direct Crystal to your XML schema.
4. In your program that will print the report, create a ReportDocument
class's Load() method to load the Crystal report template (.rpt file).
5. In that same program, use the ReportDocument's SetDataSource()
method to point the report to the ADO.NET DataSet containing the report
data.
6. Call PrintToPrinter to print the ReportDocument.
You can read more here:
http://msdn.microsoft.com/library/de...dataaccess.asp