Share via

Filtering Data in the Report

  • Article

In this section, you learn how to set the Data Context field to filter data that is displayed on the report. For more information about Data Context settings, see Implementing Report Part Drill Down.

To filter data in the report

  1. Open the Crystal report.

  2. Right-click in an empty area of the report. Select Report, and then click Report Options.

  3. In the Data Context field, type "/Country[USA]".

  4. Click OK to close the Report Options dialog.

  5. From the Build menu, select Build Solution.

  6. If you have any build errors, go ahead and fix them now.

  7. From the Debug menu, click Start.

The report displays only records from the USA.
  1. Return to Visual Studio and click Stop to exit from debug mode.