Formatting decimal values in rdlc

thankesh

Hi,

I have developed a report in which I want to show the decimal values to US currency format & if the currency is "0", then it should show "-" in rdlc. Which format should I use? I tried with the standard formats in rdlc. :-k

postsaurav

Hi thankesh,

Please describe the issue as i am unable to get the same.

Thanks & Regards,
Saurav D

kine

Format it in this way in NAV classic and you will get same in RDLC...

NaviDev

You can also apply an IIF statement inside the textbox. :roll:

thankesh

NaviDev wrote:

You can also apply an IIF statement inside the textbox. :roll:

I have designed more than 10 rdlc reports which has more than 100 columns. If i change the format for each and every column in NAV itself, the values with the correct format should be entered once again by removing the existing expression in the text box in rdlc.

But in rdlc reports, If I add "IIF" statement, it should be entered for all the text boxes. So, it would be great if there exists any custom defined format for USD currency format (where, if the currency value is 0 then "-" should also appear).

I tried the following format. But, it displays the rounded value. I need to display two decimals.

Format ###0 ;(#,##0);- ;

kabroco

Is this any help:

viewtopic.php?f=32&t=48851