August 14, 2006 at 7:21 pm
Hi,
I am trying to format a number field in my report so that the number of decimal places shown is based off another field in my report.
eg. I have two fields, MyNumber and DecimalPlaces. I want MyNumber to show x number of decimal places where x is the value of the DecimalPlaces field.
Is this option not available in reporting services?? is the only sort of formating available based off strings such as "0.##"?
Thanks for your help,
Carolyn
August 15, 2006 at 7:48 am
The formatting is based on a string. I haven't tried it but you might be able to use an IIF statement to calculate and create the string on the fly.
Stuart
August 15, 2006 at 9:40 am
Try
="#." & String(Fields!DecimalPlaces.Value, "0")
August 15, 2006 at 6:57 pm
Thanks! That didn't quite work, but i wrote my own function to do it using the PadRight string function.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply