 |
 |
|
Stop Lights in Cognos ReportNet Query StudioApplies to Cognos ReportNet Query Studio Synopsis Would you like to show stoplights in your ReportNet List Report? Solution 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. Questions Have a question for our trainers? Click here to send your questions! |
