Share via

Configuring the Report for the CrystalReportSource Control

  • Article

In this section, you use the Report Wizard to configure the report and add it to the CrystalReportSource control. You create a database connection, set up the fields for the report, and then add the report to the control. Once you are finished, you test your reduced-code Web Site.

To configure the report for the CrystalReportSource control

  1. If the Registration Wizard dialog box appears, you need to register your copy of Crystal Reports. You have two choices:

    • Click Next to register now.
    • Click Register Later to register later.
After registering or choosing to register later, proceed to the next step.

  1. In the Create New Crystal Report Document panel of the Crystal Reports Gallery dialog box, select Using a Report Wizard.

  2. In the Choose an Expert panel, select Standard, and then click OK.

  3. In the Available Data Sources panel of the Standard Report Creation Wizard window, do the following:

1.  Expand the Create New Connection folder.
2.  Expand the ODBC (RDO) folder.

  1. In the ODBC (RDO) window, select the correct ODBC DSN entry for your version of Crystal Reports, as explained in ODBC DSN Entry for Xtreme Sample Database, and then click Finish.

  2. Expand the Tables node and select the Customer table.

  3. Double-click the Customer table to move the table into the Selected Tables panel, and then click Next.

  4. Expand the Customer table, then CTRL-click Customer Name, Contact Title, Address1, Contact Last Name and City.

  5. Click the > symbol to move these fields into the Fields to Display panel, and then click Next.

  6. In the Available Fields panel, under Report Fields, select Customer.City, click the > symbol to move the field into the Group By panel, and then click Finish.

    The XtremeCustomers report is created and loaded into the main window of Visual Studio.

  7. At the bottom of the window, click Main Report Preview.

    Note

    The Preview button is available for the first time in the embedded Crystal Reports Designer that ships with Crystal Reports for Visual Studio 2005.

    The report is displayed in preview mode and shows data from the Xtreme database.

  8. At the bottom of the window, click Main Report to exit preview mode.

  9. Open the Web Form.

  10. From the View menu, click Designer.

The report is displayed in Design Time Preview mode, which shows the graphic layout for the report on the Web Form.
  1. From the File menu, click Save All.

To test the reduced-code Web Site

Your report is created and designated as the report for the CrystalReportSource control. You are now ready to build and run your project.

  1. From the Build menu, select Build Solution.
  2. If you have any build errors, go ahead and fix them now.
  3. From the Debug menu, click Start.
  4. The XtremeCustomers report is displayed in the Web browser.
  5. Return to Visual Studio and click Stop to exit from debug mode.