Use the reporting format string of services in the auto-format cell data, for example "C2" Formats to display in the form of currency with precision.
Do anyone know that where should I get an extensive list from all the different formats?
Reporting Services. Net uses formatting strings. So you can see them on MSDN Here's a link and reference to make it.
A standard code is like "C2" given in an example and the advantage is that you are "aware" that you have regional settings. So in the United States, C2 has been formally formatted for C2 in Japan.
A custom code allows you to roll your own, like "#, ## 0.0" format a number with a thousand separators in a decimal place and if between 1 and 1 - If there is between 1 then a leading 0, with a custom string, you can also make different formatting if it is positive, negative or 0.
Comments
Post a Comment