In my crystal report, I am trying to display only those records that do not have a charge number associated. I have tried the following formula and I do receive any records:
Is that in your records selection formula? If so, what is the drop down box for null settings say? Default value or Exceptions for Null?
If it is set to Exception for Null and you still aren't receiving any records with that formula, remove the formula from the record selection and place the field in your detail section and see if it is returning a value.
_____________________________________ Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection
Yes, the formula was in the records selection formula and the drop down states exceptions for nulls. I tried your suggestion of putting the field in the detail section and it did not work. I only received records that had a charge number (were not null). Any other ideas?
You need to describe your table joins. The null will only show up if you have a left join FROM some table TO the phcharge table, with no selection criteria applied to the phcharge table (except for the isnull()).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.