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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need some formula help please

Status
Not open for further replies.

Tailgun

Technical User
Mar 30, 2002
417
US
Here is what I have

IsNull({tblClaim.AppraiserLastName})

To this I want to also include

Or {tblClaim.AppraiserLastName} = UNASSIGNED

I'm very new to Crystal and especially formulas so any help
will be greatly appreciated.

Thanks for any help.
 
Assuming "UNASSIGNED" is the actual value in that field,
the expression would be:
------------------------------------------
IsNull({tblClaim.AppraiserLastName}) OR
{tblClaim.AppraiserLastName} = "UNASSIGNED"
------------------------------------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Thanks loads IdoMillet

I could have sworn that was exactly what I tried but obviously it wasn't because your post solved the formula problem.

Thanks again :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top