Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Select Expert Null
- Thread starter random621
- Start date
Don't use the select expert for this, just write a record selection formula.
Click on report, edit selection formula, record and enter a formula:
Isnull({Account}) or {Account}="Prospect"
It is important to always make the null test first, as crystal has trouble processing nulls at times.
Also, unfer file, options, reporting tab, there is a "convert null field value to default" checkbox. Make sure this is not clicked as it may get in the way of your null test.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Click on report, edit selection formula, record and enter a formula:
Isnull({Account}) or {Account}="Prospect"
It is important to always make the null test first, as crystal has trouble processing nulls at times.
Also, unfer file, options, reporting tab, there is a "convert null field value to default" checkbox. Make sure this is not clicked as it may get in the way of your null test.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question