Attribute Details: Format

Allows a string to be formatted in various ways, especially for numeric and date values. Specifies formatting characteristics for the data.

This attribute has been borrowed from the Microsoft Visual Basic Format function. For more information:

For dates, the non-specific formats, such as "General Date", "Short Time", etc., are converted according to the browser's international setttings. Also, for very large reports, the non-specific formats perform better.

There are also some special formats.

"<" and ">" change strings to lower and upper case.

"Expanded Spaces" preserves space characters that would otherwise be collapsed by the web browser.

"HTML" preserves HTML tags so that they are not encoded - they are embedded rather than shown.

"Preserve Line Feeds" preserves line feed and cariage return characters so that the following characters appear on a new line.

"mp" formats numbers with the "metric prefix". To format 1,234,567 as "$1.23M", use Format "$#.00mp". Supported metric prefixes are from 1000^6 to 1000^-6 For more information:

"mpsx" formats the value with x number of significant figures in addition to the metric prefix. So a value of 123456, with format set to mps3 will return 123k.

"qq" returns the number of the quarter when the value being formatted represents a date. To return the year and quarter together like "2010 Q1", set the format to "yyyy Qqq".

"fyy" and "fyyyy" return the fiscal year. "fqq" returns the fiscal quarter. The fiscal year start date may be configured in the settings' Globalization element.

"ww" returns the number of the week. The first day of the week may be configured in the settings' Globalization element.




Click element to drill down for more information.

Analysis Chart Column
Analysis Filter Column
Analysis Grid Column
Animated Map Color Spectrum Legend
Caption Style
Caption Style
Chart Grid Column
Color Spectrum Legend
Crosstab Comparison
Crosstab Table Value Columns
Data Labels
Data Labels
Data Scale
Drill To Column
Drillthrough Column
Formatted Column
Gauge Label
Heatmap Group
Heatmap Label
Heatmap Label Style
Input Combo List
Input Date
Input Number
Input Telephone
Input Text
Input Text Area
Input Time
Label Scale
Label Style
Marker Label Style
MDX Calculated Measure
PDF Form Field
Polygon Color Spectrum Legend
Quicktip Row
Side Label Style
Stack Labels
SubCaption Style
Word Form Field
XOLAP Calculated Measure
XOLAP Measure
XOLAP Member Property

 Back to top