Thursday 23 August 2012

Oracle BI, break table after number of columns on same page

I have a report with a dynamic number of colomns. However, in the rtf-template you want to break the table after a predefined number of columns and continue on the next line.
You can use <?horizontal-break-table:number?>,however that breaks the table to a new page. The solution is (with a maximum of total columns of 100 and 5 columns on 1 row):


Instead of defining a 'hardcoded' value for maxcol of 100 the max number of columns can be calculated with distinct_values.
example:
<?variable:maxcol;count(xdoxslt:distinct_values(/FOTOLINKORG1))?>

No comments:

Post a Comment