Format decimal Places based on variable

[Frank]

I have a text box on a report that I would like to be able to format to a specific number of decimal places based on a variable.  Say if I pass a the value 3 it will be 3 decimal places or if I pass it a 5 it would be 5 decimals places.  Is something like Format("{0:N?}"  where the ? would be a variable, of is it only possible through a series if iif statements? 

[Stef]

Hi Frank,

Please test using the built-in Format text function in an expression like:

=Format('{0:N'+ Parameters.Parameter1.Value+'}',1233311.001234567)

where Parameter1 is an integer value in the example.

The idea is to build a dynamic format string.


I hope this information is helpful.

Regards,
Stef
Telerik by Progress