Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How can we suppress repeating master data in report output using RTF template?

Received Response
58
Views
1
Comments
Brijesh Sharma
Brijesh Sharma Rank 1 - Community Starter
edited Oct 5, 2023 9:17PM in Oracle Analytics Publisher

We have a BIP report with single data set. Each row of the dataset consists of header level and line level data. Suppose there are 3 lines to an invoice, the header level data is repeated in all the three lines. The data is sorted based on the invoice number.

The requirement is to populate the header level data in only the first record of that invoice. For rest of the records, only the line data will be populated as shown in the attached example. How can we achieve this? Please help with the same.

XML (Data Set) Data format:

Expected report output using RTF template:


Answers