Cross tab report - display multiple columns (code and desc) per row in addition to matrix grid
I am using BI Publisher Enterprise 10.1.3.4 and trying to create an RTF template for my cross tab report.
I am almost happy with the layout but would like to reference a code and description at the row level, without breaking on the description.
The following is my xml data :
<LIST_G_ITEM_SUPPLIER>
<G_ITEM_SUPPLIER>
<SUPPLIER>2910</SUPPLIER>
<SUP_NAME>Local Supplier #2</SUP_NAME>
<LOCATION>1241</LOCATION>
<LOC_NAME>Cleveland</LOC_NAME>
<ITEM>100000091</ITEM>
<ITEM_DESC>Test Item 100000091</ITEM_DESC>
<STANDARD_UOM>EA</STANDARD_UOM>
<DEFAULT_UOP>EA</DEFAULT_UOP>
<TRAN_DATE>JUN-10</TRAN_DATE>
<SUM_UNITS>45</SUM_UNITS>
<SUM_COST>5200</SUM_COST>