Skip to content
 

Add a Conditional Graphic

You can use this approach to make a different graphic appear, depending on a value or condition. In our example, we’re looking at a report of presidents and will show a party graphic if they are democrats or republicans.

  1. Open the report and add all the graphics you will be using.
    insert images
  2. Right-click on the first graphic and select Format Graphic from the pop up menu.
    format graphic
  3. On the Format Editor dialog, make sure you are on the Common tab. 
    format editor
  4. Click the Conditional Formula button next to the Suppress check box.
  5. Enter the formula to determine when to hide the graphic. In our case, since this graphic is the Republican Elephant, we want to suppress the image anytime the Party<>”Republican”:
    {Sheet1_.Party}<>"Republican"
  6. Click Save and Close to save the formula and close the Format Editor.
  7. Repeat steps 2-6 for each graphic. In our case that means applying the following formula to the Democratic Donkey:
    {Sheet1_.Party}<>"Democrat"
  8. Now, select both the graphics and use the align command to stack the graphics in the location on the report where you want them to appear.
  9. Here’s the result:

samplereport

Leave a Reply