I have the following field(Fields!SequenceNO.Value), coming form database.
i would like to have an expression IIF...
if the value coming from database is just 1, then make it 1.00 or
if the value coming from database has a period or point say 1.01 then show as it is.
thank you very much for the help / information....
Hello,
You can do this a couple different ways...
1. Select your textbox that will hold Fields!SequenceNO.Value, then change the Format property to #.00
or
2. Replace Fields!SequenceNO.Value with the expression: =Format(Fields!SequenceNO.Value, "#.00")
Both of these will make all of your numbers in the column have 2 decimals.
Hope this helps.
Jarret
No comments:
Post a Comment