471,627 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,627 software developers and data experts.

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

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.

Dec 27 '05 #1
1 1840
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

Dec 27 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

22 posts views Thread by Nunaya | last post: by
11 posts views Thread by Arsen Vladimirskiy | last post: by
7 posts views Thread by Jack Addington | last post: by
50 posts views Thread by Jay Balapa | last post: by
6 posts views Thread by rodchar | last post: by
5 posts views Thread by Matthias S. | last post: by
reply views Thread by YellowFin Announcements | last post: by
9 posts views Thread by SAL | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.