Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 report data issue

Author  Topic 

niha.736
Starting Member

4 Posts

Posted - 2012-11-02 : 00:38:40
Hi in my report some values are negative , they are showing like
(12131).
i just want to show them as -12131

what could be the best solution for this?

actually i have used
" #,0;(#,0)" this format for my text box properties.
this format is for thousand separator without decimal values.
can anybody suggest something?


thanks,
Niahrika

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-11-02 : 06:58:34
Just remove those two brackets - I usually use this:
#,##0;-#,##0;""
The first part before the first semi-colon indicates how positive numbers should be displayed. The second part indicates how negative numbers should be displayed and the third part is for zeros.
Go to Top of Page
   

- Advertisement -