1900957 - Alert not triggered in Crystal Reports when data is not fetched in the report.

SAP Knowledge Base Article - Public

1900957 - Alert not triggered in Crystal Reports when data is not fetched in the report.

Symptom

  • Crystal report alert not triggered when data is not fetched in the report
  • Crystal report alert not triggered for the record having NULL value in the database

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

For No record in the Database:

  1. Create a Crystal report and select the field which has No record in the database
  2. Add an Alert in the report and refresh the report
  3. An Alert will not be triggered as there is no record in the database

No record for specified condition: 

  1. Create a Crystal report
  2. Select few fields in the detail section of the report
  3. Add a filter and select the field value which has no record in the database
  4. Add Alert in the report, select the field on which the filter is applied in the alert formula and refresh the report
  5. An Alert will not be triggered as there is no records retrieved after refreshing the report

Cause

  1. There are No records in the database.
  2. Alert formula can be based on print-time fields.

Resolution

An Alert can be triggered if following two conditions would satisfy:

  1. Report should retrieve at least one record from database. It cannot be triggered if there is no record in the database.
  2. Alert formulas can be based on recurring records (records returned after reading the records from database) or on summary fields but cannot be based on print-time fields (records returned after applying the filter at Crystal reports designer level).

Keywords

Crystal Reports, Alert, No records, Zero records, Null , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011