ACE Analytics About Formatting

The following elements have a Format attribute, which can be set to format the appearance of their data:

• Analysis Grid Column
• Crosstab Table Value Column
• Format Font
• Formatted Column
• Gauge Label
• Heat Map Column
• Input Date, Input Text, Input Text Area
• Label
• Mdx Calculated Measure
• Pdf Form Field
• Schedule
• Word Form Field

Format attributes are not always context-sensitive, so it may be possible to select formatting options that are not appropriate for the data. See our document Classic Chart Label Formatting for more information about chart title and label formatting techniques for the Classic Charts family to produce special effects such as sub- and super-scripting, mixing fonts and colors, and stacking text.

Many of the formatting types available are drawn from the Microsoft Visual Basic predefined format types and are dependent on the Regional settings in the web server's operating system.

For example, as shown above, Regional and Language options are available on Windows-based web servers through the Control Panel. The "Currency", "Short date" and "Long date" formats defined here can be used by name in a Format attribute.