BI Publisher (MOSC)

MOSC Banner

Dynamically add columns to a table: Blank rows are rendered.

edited May 3, 2012 1:55AM in BI Publisher (MOSC) 5 comments
Followed the steps to dynamically add columns as in Oracle® Fusion Middleware
Report Designer's Guide for Oracle Business Intelligence Publisher
Release 11g (11.1.1)
Part No. E13881-02

However, the rows doesn't contain information.
But when the group by clause is removed, only the first element/row appears.

Template: 2x2 table


ItemInformation |ColumnHeader

Groupby           |ColumnData


Where:

ColumnHeader: <?split-column-header:Parts?><?Number?>

Groupby: <?for-each:BOM?>

ColumnData: <?split-column-data:Parts?><?ItemNumber?>

XMLData as below:

<?xml version="1.0" encoding="UTF-8"?>
<Data>
<Parts><TitleBlock><Number>F0007</Number><PartType>Formula Inner</PartType></TitleBlock>
<BOM><ItemType>Inner Nutrition</ItemType><ItemNumber>0661</ItemNumber><ItemRev>CO04347</ItemRev></BOM>
<BOM><ItemType>Inner Nutrition</ItemType><ItemNumber>0670</ItemNumber><ItemRev>EO01765</ItemRev></BOM>

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