Summary

Unable to achieve the RTF template for generating the report using BI Publisher

Content

We are doing a PoC to replicate a legacy report in BIP 11.1.1.7. And below is the requirement-

1. If a Oracle DB column stores n number of values it should render the graph with 4 line graphs per page.

    i.e.,  The line graphs should be rendered as 2 rows (2 line graphs horizontally) and 2 columns (2 line graphs vertically)

   The number of pages generated will depend on the data stores in the column or it is more like looping or grouping based on the column

2. Further, in the above graph apart from the X-Y axis columns another column data should be printed in the legend section.

3. If there is a tabular report, if the data reaches the end of the page then the content in the cells should word-wrap intelligently or data should be

     moved to the next page without word-break.

4. The table of content should display the page number range rather than the actual page number. For example if the line-graphs are printed from

        page 1 to page 10. It should show as Page 1-10 rather than just Page 1.

I tried XPT template for report creation and it just does the grouping in a single column.

Then, used Word RTF template for ToC and it prints on the page start numbers.

If this can be done using XML coding with RTF template please advise the steps.