Search code examples
wpfcrystal-reports

Why Crystal Report Formula is not working to Group Data

I am using formula fields and have created this formula to group data on the basis of null or not. but it is not working and always group data in just one Completed group. Why ? 

 if (Not IsNull({MRSReportProject_MRSReportClass.Actiontaken})) 
    and (IsNull({MRSReportProject_MRSReportClass.actioncomplete})) then "Pending"

    else if (Not IsNull({MRSReportProject_MRSReportClass.actioncomplete})) then "Completed"

else "Nothing";
Solution

  • Most likely your null values are not null values.

    One reason could be Crystal Report option convert null values to default - if this is checked, then formulas don't see null values, but empty strings or number 0, depend on field type.

    Another possibility is that already your data source does not return null values.

    You should then use simple comparison operators (=, <>) to compare values; if sometimes null values can occur, then you must consider all combinations (using both comparison operators and isnull() functions). I have sometimes used intermediate variables or formulas for eliminating null values, simplifies code a bit (some formulas can be pages long).