Crystal Reports First Report

Create a new Web site project,

1. Setting up a database

From Server Explorer, add a new connection to the data connection and use the Microsoft Access database file as the data provider to connect to the database for the use case of the Crystal Reports Xtreme

2. Create a new Crystal Reports report

Add a Crystal Reports report to the project with the name Cr1.rpt.

3. Add XML Schema file

Add an XML schema file to the project because the XML schema file itself is also an XML file, named Order. xsd, for ease of action, you can select the file and select the DataSet Editor in the open mode. Then select the Order table in the Xtreme Library, drag and drop into this XML schema file, will automatically generate an order file, where only the schema of the table, that is, the field framework information, so automatically generated TableAdapter is useless, you can delete.

4. Add the field to the field explorer

Open field resource Management, right-click database field, select Database Expert, where we use ado.net to do the data source, double-click to create a new connection under the Ado.net, in the pop-up ado.net panel, select the file path, select the order created above. xsd, and then add to the database field , we will see that there is an extra order under the field Explorer, expand the order, and see all the fields. (XSD files are used when you design a report, so XSD is a schema file for table fields at this time)

Open the built cr1.rpt to start a real design report and now a detailed report of the order.

At the time of report design, field Explorer is a very important panel because most of the data is implemented here, not only with database fields, but also with formulas, parameters, group names, running totals, and special fields. About fields, in a future article.

Now we are in the order, select the order ID, Order amount, Order date, shipped, received the payment of several fields, respectively, into the details section of the CR1.RPT report, the system will automatically add the same field in the header processing, the following figure

Figure 1