How to add a prefix/suffix to an attribute using custom formatting in a report


Sometimes Users may wish to add a prefix or suffix to an attribute in a report for display purposes by using custom formatting. Using custom formatting avoids the need of using ApplySimple statements in the definition of the attributes, providing a simpler way to format these objects.
The following below procedure describes how to define the prefix/suffix using the custom formatting:

  • Create a report that includes the attribute to be formatted. Place the attribute in the report template. When running the report, the attribute displays the attribute data as pulled from the warehouse, as shown below: 
  • Right-click on the attribute and select the 'Formatting' option. Then select '<AttributeName> Values' as shown below:

  • In the Number tab, under `Category`, select Custom.
To define a prefix/suffix, use double quotes to enclose them. The number zero (0) represents the attribute value pulled from the warehouse. For example, define a prefix 'Year': 
 
  •  Click OK to accept the changes
Notice how the attribute now shows the prefix defined followed by the value retrieved from the warehouse:

Comments

Post a Comment