BI Publisher (MOSC)

MOSC Banner

BIP RTF How to Create Dynamic Columns with Variable Data

edited Jan 19, 2020 4:01AM in BI Publisher (MOSC) 5 commentsAnswered

Using BIP in Cloud Fusion, I have created dynamic columns using <?for-each-group@column:GroupName;Element?> syntax.

This creates all of the required columns successfully.

However, when populating the data in these columns using <for-each-group@cell:GroupName;Element?> the data values do nto appear in the correct columns even when the sort order is the same as for the columns.

For example, the columns represent allowances and the rows represent employees.  If there are 50 possible allowances in total and an employee only has values for 5 of them, their allowance values always end up in the first (left most) 5 columns instead of under the correct column headers.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center