Insert Picture as Result of Formula - - CR XI 1

[RoMarcus]

I think I originally posted this in the wrong forum - so let's try here....

I have one picture that I would like to display depending on the result of the formula.

If totaldeposit <> PaymentsEntered then show the PHONE.JPG image

I clicked on insert, picture, and placed the phone on the report. I selected 'Format Graphic', selected 'picture' then went into formula editor for 'graphic location' but I cannot seem to get the syntax to work properly for the formula. All suggestions appreciated.

 

[LizSara]

as posted in the other forum do you want to supress the picture if totaldeposit = PaymentsEntered ?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[RoMarcus]

No - the opposite. I want to show the picture.

 

[RoMarcus]

I just realized that you typed in EQUALS instead of <> so YES - I want to supress if formula result equals...

 

[LizSara]

if you want to show the picture if totaldeposit = PaymentsEntered then go to format graphic and click the formula button next to supress and enter totaldeposit <> PaymentsEntered.

If, as i think you said originally you want to show the picture if totaldeposit <> PaymentsEntered then go to the same formula and enter totaldeposit = PaymentsEntered

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[RoMarcus]

I keep getting the error message: "The formula result must be a string

 

[LizSara]

are both the items you mention there formulas?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[RoMarcus]

Yes - they are and they produce a numeric result

I've tried other basic formulas like

@GROSSAMT > 4999 this produces an error that says "The formula must be a string.

So then I try
@GROSSAMT > "4999" and get this error message : A number is required here


I'm sure it's something simple ... have you tried it?

I'm placing this in a group footer - do you think that matters?

 

[lbass]

What is the exact formula you are entering, and where are you putting it?

-LB

 

[RoMarcus]

Sum ({@GrossAmount}, {@CLINIC-SORT}) > 4999 ---> this produces an error that says "The formula must be a string"

So then I try ...

Sum ({@GrossAmount}, {@CLINIC-SORT}) > "4999" ---> and get this error message "A number is required here"

This is placed in Group Footer 1f "@Clinic-Sort" which creates a specific sort order that is a number

 

[lbass]

After you place th picture in your group 1F section, you would right click on the picture->format graphic->common tab->suppress->x+2 and enter:

Sum ({@GrossAmount}, {@CLINIC-SORT}) > 4999

If you still get that message, then you need to show us the content of {@GrossAmount}.

-LB

 

[RoMarcus]

LB-
When I researched this, all of the references that I reviewed said that I had to go into graphic location on the picture tab - not on the common tab as - what you suggested worked perfectly! Thank you very much!