Skip Navigation
Expand
Some columns within the report are not displaying data
Answer ID 10957   |   Last Review Date 06/28/2019

Why some columns within the report are blank?

Environment:

Analytics/Reports
Oracle B2C Service, All Versions

Resolution:

In most of the cases, you'll notice this behavior when those particular columns are configured to hide repeating values. This can be verified as following: edit the report > right click on the affected columns > Edit Format > Alignment tab > if the option 'Hide Repeating Values' is checked, remove it.

This option is meant to hide consecutive repeating values in the column. For example, if the name of a staff member is shown in the column in five consecutive rows, you can hide repeating values to show the name in only the first column.

You can also hide repeating values on the Column Format window. This window has an option to exclude hidden repeating values from consideration in column calculations and column auto-filter options. When you hide repeating values from the ribbon, they are still included in column calculations and auto-filtering.

For additional information, refer to the ' Report Designer Format tab' section in the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.