Why some columns within the report are blank?
Oracle B2C Service (OSvC), All Versions
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 online documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.