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

Suppress a field if another field does not exist. Crystal Reports 11

Status
Not open for further replies.

cyreports

Programmer
May 12, 2010
89
0
0
US
I am using Crystal Reports 11 and I need to suppress a field if another field does not exist. I am trying to use this on my field and its displaying still.

Trim ({Claims_txt.Proc6CPTCode}) = ""

If Proc6CPTCode does not exist, I need my field to not appear. It continues to populate a 0.00 in my field, which I do not want.
 
test for nulls, not just blanks:
isnull({Claims_txt.Proc6CPTCode})
 
Hi,
depending on what you have set for the 'Convert NULL values to Default' option, you may need to test for both:

Trim ({Claims_txt.Proc6CPTCode}) = ""
OR
isnull({Claims_txt.Proc6CPTCode})

[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top