Apply format definitions

You can apply format definitions to rows in a Dynamic Report. Apply format definitions if you have changed the label of a format definition or if you have created new format definitions.

About this task

If your Dynamic Report uses more than one format definition, the format label column (typically column A) of the first row in the Dynamic Report must contain a function that resolves to one of the format definition labels in the format range. The format label column is set in the TM1RPTVIEW function by using a cell reference or a named range.

To maintain dynamic formatting, do not use hardcoded values when you specify format definition labels in the format label formula.

Procedure

  1. Click the cell at the intersection of column A and the first data row in the Dynamic Report.
  2. Modify the IF function to resolve to the format definition labels set in the format range.
  3. Repair the Dynamic Report and view the formatting.
    For more information, see Refresh, rebuild, or recreate.
    Note: If the function in column A resolves to a value that is not used as a format definition label, no formatting is applied to the Dynamic Report row.