SAP Knowledge Base Article - Public

1306120 - How to count blank values in Crystal Report?

Symptom

For group how to count the blank values in Crystal Reports.

Resolution

1) To count the blank values in Crystal Reports:

    'IF IsNull({CHG_Change.Resl Compliance}) THEN 'null'

2) To count the blank values in the report and to put it in the Group Footer:

    numberVar a;

    if isnull({CHG_Change.Resl Compliance}) then

    (
       a:=a+1;
    )

Now place this formula in the Group Footer.

Keywords

calculate, value, report , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2