How to design and build reports which data source from business logic layer ?

  • Thread starter Thread starter abc my vclass
  • Start date Start date
A

abc my vclass

How to design and build reports which data source from business logic layer
?

Is there any documents or tutorials explain the steps to design and build
reports if my projects' data source from business logic layer, not directly
connecting database.
 
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/d...en-us/crystlmn/html/crconreportdataaccess.asp
 
Back
Top