|
|
| The information in the article refers to |
Cognos ReportNet
Cognos ReportNet Query Studio
Would you like to show stoplights in your ReportNet List Report?
Short solution:
In short, use conditional formatting. You’ll need two or more images and then you simply show the image you want for the condition you want.
Long solution:
We’ll be creating a report that has 2 images (red and green) based on revenue
Insert a table into your report. Make it 1 column by 2 columns (if you only have 2 images to display.) We will use a Green Check mark and a Red X.
Insert a conditional block into each of the cells
Insert the images into each of the conditional blocks.
Select a conditional block and double-click on the Conditional Style property
Click Variables then click the new variable button
Name one variable Red and another green. Make them both Boolean.
Give each variable a condition such as [Revenue] > 500000 for Green and [Revenue] <= 500000 for Red.
Move the table to the side of the list report to add it as a column. Now run the report.
Voila!!! You have a report that shows Green Check Boxes for Revenues over 500,000 and Red Xs for Revenues less than 500,000.
Have a question for our trainers?
Click here to send your questions!
|
|
