crystal reports conditional value 1

[mstepPCI]

I dont have very much experience with crystal reports or this website so please don't flame. I was wondering if there was a way to test a database field to see if it is empty, and if it is then place a hardcoded string into a text box. If its not empty then place the value of the db field into the text box.

Something like

db field contains "coke"
drink: coke

db field contains ""
drink: No drink specified!


sorry for the basic question.

 

[spedi]

Check as follows:

If Not IsNull(db field) then
"drink:" + db field
Else
"drink: No drink specified!"


Srinath

http://www.nhsonline.org

srinath_p (at) yahoo.com

 

[mstepPCI]

where exactly do i type this? I'm using crystal reports 8.5. THANKS

 

[spedi]

You have to create new formula and inside new formula type the following:

If Not (IsNull(db field) and Trim(db field)="") then
"drink:" + db field
Else
"drink: No drink specified!"

and put this formula in the detail section of the report.


I would advice you to take crystal reports I classes.

Srinath

http://www.nhsonline.org

srinath_p (at) yahoo.com

 

[mstepPCI]

Thanks worked perfectly.