Report Studio Formatting 1

[udaykamble]

I am using a report studio.
In one of the columns, I am getting the value as "High" from database but in the final report I want to show the same column as "tick mark", how do I do that?

 

[blom0344]

Edit the label of the column header (need to unlock first)

Ties Blom

 

[subhamsan]

step 1 : unlock the report page from tool bar
step 2 : select the column header with name 'High'
step 3 : go to the properties pane for the selected column
step 4 : Change the column name to "tick mark".

 

[udaykamble]

This is not I asked for. I am sorry if I did not explain myself very clearly, but I want to format the values which are being displayed in that perticular column and not column header.

If the value is "High" then display as "tick mark" (a symbol)

 

[blom0344]

Conditional formatting will allow you to change a lot of properties (colors, formats , box-types), but not the value of the content shown.
Your best bet is to use a CASE construct on the dataitem:

CASE WHEN
[SOMEVALUE] = 'High'
THEN '--'
ELSE [SOMEVALUE]
END

Ties Blom

 

[udaykamble]

Thanks for your reply.

I am already using the case statement and
But I am not sure How will I display tick-mark as it is symbol.

Something to do with the Ascii character but I am not sure what?

 

[blom0344]

I do not know what you mean with tick-mark (being dutch ..), but you can store anything as long as you can paste it into xml. The euro has its own symbol and we can simply use alt+0128 to use it in Report Studio..

Ties Blom

 

[udaykamble]

check the symbol besides "Turn off E-mail Notification." on the this web page. Thats a tick mark....I want to show that symbol

 

[blom0344]

I think that you need this as an image file (on the server in the appropriate Cognos folder) and then refer to it in the CASE statement. This is the way we use 'traffic lights' in our reports like:

CASE 
WHEN abs([Diff % KPI]) > 0.05 THEN '..\samples\images\red.jpg'
ELSE ........ END

Ties Blom

 

[Nuffsaid]

Try this.

Use the letter "a" for your tick mark and format it as Webdings.

Nuffsaid.

 

[udaykamble]

With letter 'a', its working but let me show this stuff to my manager for his approval.

Thanks, Anyway.

 

[blom0344]

Nuffsaid, that is a cool solution. Have a star....

Ties Blom