Inserting Pictures via Formula 1

[Lacapa]

I want to insert pictures based on the content of my detail field - if the item changes I want the correct picture to be displayed. I want to do it like an if then else statement but I cannot find anything.

 

[dgillz]

What version of Crystal?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Lacapa]

I am using Crystal 10

 

[dgillz]

Sorry,

Crystal XI or 2008 will allow you to create a formula with a file name and path where the picture is located, and the picture is displayed.

Prior versions of Crystal require that the picture itself be in the database as a blob field.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[dbaJSmith]

dgillz:
Now *I'm* curious. How do you do that?

 

[kskid]

What type of database are you using? I believe Oracle 8i handles blob fields. As DGILLZ said, the image must exist on your database.

 

[dgillz]

How do I do what?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[CR85user]

Just add all of the possible images overlaying each other and conditionally suppress the images not required based on your requirements.

'J

CR8.5 / CRXI - Discovering the impossible

 

[chelseatech]

My cViewIMAGE utility lets you use dynamic images in any version since CR 8.5. You can download a trial version from my web site.

There is a FAQ here on Tek-Tips about dynamic images and a long article in our Crystal Clear newsletter talking about the various ways of doing this.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[dbaJSmith]

dgillz: I was asking about how you display different pictures in CR XI ("Crystal XI or 2008 will allow you to create a formula with a file name and path where the picture is located, and the picture is displayed"). However, I now realize what you were saying; just create a formula that references the drive location of the image. I'm with you now.

Cr85User: That becomes very time consuming when you have anything over 5 or 10 images. Imagine having 500 images to set up that way.

Chelsea Tech: Where's the next issue?!?