BIP RTF How to Create Dynamic Columns with Variable Data
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.