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!

Image field and displaying Y or N after testing for null values

Status
Not open for further replies.

davismar

IS-IT--Management
Apr 1, 2010
85
US
Hi! I have an image field that I would like to add to a report.

Basically, if the image field contains a signature, I would like to have a column that says Y for yes.
But if the image doesn't have any data, I would like the column to say N for no.

Would anyone be ale to help me with this formula?

The boss is very anxious for this report. Basically, we want to know if a customer signed a service ticket or not, based upon this image field, which is named Signature Image.

Thanks very much for helping me out - I've never dealt with image files in a Crystal Report before.

Thank you, thanks you![bigsmile]
 
I have not previously had a need to deal with images in databases either but I would try a formula like this:

Code:
If	Isnull({Table.ImageField}) 
Then 	'N'
Else 	'Y'

Let me know whether it works or not.

Cheers
Pete
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top