Filtering the records

This video shows you how to filter the records you want included in a report. It describes how to filter data using record selection formulas. To filter data using parameters, please refer Using the parameters

Steps:

  • Please refer A simple report to create a simple crystal report
  • Right click on the report. Report > Select expert...
  • In the Choose Field dialog box, select a field by which to filter the data. Click OK
  • Select appropriate value from drop down in Select Expert dialog box. Set value from drop down next to it.
  • You can see the formula using Show formula button at the bottom of dialog box. Click Edit Formula to make any modification to the formula.
  • To add more filter criteria, click tab in the editor. Now follow the same step as done for first criteria.
  • Click OK.
  • Click Main report preview button to view this report.
Download video: Filtering records