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.
- Open the report and add all the graphics you will be using.
- Right-click on the first graphic and select Format Graphic from the pop up menu.
- On the Format Editor dialog, make sure you are on the Common tab.
- Click the Conditional Formula button next to the Suppress check box.
- 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" - Click Save and Close to save the formula and close the Format Editor.
- Repeat steps 2-6 for each graphic. In our case that means applying the following formula to the Democratic Donkey:
{Sheet1_.Party}<>"Democrat" - 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.
- Here’s the result:
