Thousand separator

[Cognos8]

To display Thousand separator i Use data format property "Use thousand separator"
and it works fine. i need to have with this , when i have negative number it
should display (1,236) instead of -1,236.
So i used pattern    = #,###0
     Negative pattern = (#,###0)

SO three data format i used.

Use thousand separator = yes
used pattern    = #,###0
Negative pattern = (#,###0)

But i get wrong output : 1,21,23,54.

Is there anything wrong in pattern and negative pattern

[CognosPaul]

Two things:

The pattern should be #,##0 and (#,##0). For this you shouldn't need to use the patterns though. Set the Negative Sign Symbol to (). It should also be in the drop-down menu.

As for the output, check the Group Size. If it's set to null or 2 set it to 3.

[Cognos8]

Hi,
Your point is valid , even after doing this it does not work. 3 things i have in mind.
1) if tha data stored in that way will it get change if we do this?
2) is there any option in FM mean report studio will override right ?
3) Is there  any report cache properties? because i did set negative symbol as down  arrow instead of (). still it shows () only. where is the property to clear the report cache. i did in internet option.

[CognosPaul]

Do you mean the data is stored as 1,21,23,54? Is the data numeric or char?

Any formatting change you make in the report will override the any formatting set in the framework.

[Cognos8]

This report is upgraded from 8.2 to 8.4.In 82 it works fine. 8.4 does not. if i change the negative symbol to down arrow it is not applying. any idea to clear the report cache.

[vinu]

HI,

To remove report cache
Select Query-->In properties-->Use Local Cache set to No

Thanks,
Venu