Question about a Blob field and an image

[Fadius]

I am using Crystal XI. I have a blob field that contains an image. There can be several types of images. What I am trying to do is get it so only the image type of "Photo Image" displays. SOme records may not have an image, and I need the data to still print for them without the image.

If I use Select Exprt and have that field = "Photo Image", it will print only the records for thos that have a "Photo Image" and will not print them if they do nto have a "Photo Image".

There are several types of images, but for this report, the only image I need to print is the Photo Image and no image if they have no photo image with ot without any other type of image.

And of course, the image is contained in a blob field. The Image type firls is called: type_rtk_of_images

and the blob field which contains the images is called: imagecontents_of_images

I am also not able to use a blob field in a formula using XI as well.

Thanks in advance for the help.

 

[beltmanjr]

Cant you simply suppress the blob field using a formula?

 

[Fadius]

I tried that, but it will suppress all images for that person if they have multiple images of different types.

 

[beltmanjr]

I meant to use a suppression formula on the blob field that reads true when the type of image is not "Photo Image".
So

isnull({type_rtk_of_images}) OR {type_rtk_of_images
} <> "Photo Image"

If this doesnt help, you'll need to provide some more information

 

[Fadius]

Actually, I just got it to work. I created a sub report grouped on the image type and then suppressed the group if it was not equal to Photo Image. I then placed this sub report into the main report and linked it and it works great.