Prefix status column in list report with a circle,diamond and square color icon

[vincydza@gmail.com]

In the attached list report how can I prefix the status column with a coloured circle, diamond and square icon.

Vince

[cognostechie]

You will have to save the icons as images first. For how to use them in the report, I did this sometime back and don't exactly remember but I think you can insert an image and then using a case statement based on Status, you can point it to those icons.

[BigChris]

If you save the images to your Webcontent folder you can just put the URL into the case statement. If you take a look you might find that there are already some images in there that you can use...the ones that metric studio uses are pretty useful.

Obviously you're installation may be different, but try referencing ../alp/images/symbol_4_lrg.gif , ../alp/images/symbol_5_lrg.gif and ../alp/images/symbol_6_lrg.gif

[Michael75]

@ Vince

If you want source code for an IBM Cognos Samples-based report which does just this, take a look at the attachment attachment_14809690_Image_xml.txt in this post: https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014809626&ps=25

Note that there is a small error in the source code, which some kind poster </blush> corrected in the post dated 20th Aug.

[vincydza@gmail.com]

Got it, Thanks a lot.

Vince