Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Pictures in a formula Post Reply Post New Topic
Author Message
Eany
Newbie
Newbie
Avatar

Joined: 21 Nov 2007
Location: United Kingdom
Online Status: Offline
Posts: 17
Quote Eany Replybullet Topic: Pictures in a formula
    Posted: 04 Sep 2008 at 7:31am
I have XI.
My report accesses data from an SP.
I have a detail section into which I need to display one of 2 pictures (BitMap Images). I thought I could introduce a formula with coding like :

If {SP.FieldA} = "X"
then   Picture1
Else   Picture2
End If

But how do I get the pictures into the formula ?
I cannot select the "Insert > Picture" option from the top of the screen, as this is not available.

Many thanks
Eany
IP IP Logged
roxanne_2929
Newbie
Newbie
Avatar

Joined: 17 Sep 2008
Location: United States
Online Status: Offline
Posts: 9
Quote roxanne_2929 Replybullet Posted: 17 Sep 2008 at 3:25pm
Put both pictures in the report using the insert picture function and suppress each one by right clicking, format picture, click the suppress box.
 
Picture 1 click the suppress box and in the formula type
{SP.fieldA}<>'X'
 
Picture two click the suppress box and in the formula type
{SP.fieldA}='X'
 
You can even put them on top of each other because only one will be showing at a time. I do this often with text boxes and data fields.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.035 seconds.