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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Showing & Hiding Objects Conditionally 1

Status
Not open for further replies.

SDS100UK

MIS
Jul 15, 2001
185
GB
Hi,

Being very new to CR formulas could someone please tell me simple how to achieve the following and where to put it.

I have 3 images and I only want to display one of them depending upon the value in a field.

So-
If FieldA value = 1 to 50 then show image1
If FieldA value = 51 to 70 then show image2
If FieldA value = 71 to 100 then show image3
Hope you can help

Thank in advance

Steven
 
Put all three images in the report.

For each image go to the format editor and, on the common tab, there is a formula box opposite the suppress check box.

This is a formula that will allow you to conditionally suppress the image if the result of the formula is true.

Insert the appropriate formula. This should do the trick.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top