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:
