Skip Navigation
Expand
Column formatting not working when the report is displayed in the record layout
Answer ID 9898   |   Last Review Date 11/18/2018

Why is my column format not applied anymore when I switch the report to the record layout?

Environment:

Analytics, Column Formatting
Oracle B2C Service, All versions

Issue:

A custom format is set for a certain column, but after the report is changed to display in a record layout, this format is not applied anymore and the column is displayed in the default format.

Resolution:

Open the report in edit mode, right click on the column with the custom format and select Edit Format. After the column format window opens, click on the Styles tab and change the format of the Record Labels and Record Data entries to the desired one.

Right click on column heading. In Column Format window, select Styles tab, then set the Record Labels and Record Data format.

Click OK to close the column format window and save the report.

Cause:

When the record layout is selected from the Home tab in the ribbon, the applied column format changes to the one present in the Record Labels and Record Data. This allows you to have different formats for each separate layout (tabular or record).