I am currently working on Report Queries to develop some BI Publisher reports.
I have developed a few source queries and have downloaded the XML data.
The data structure basically has "ROWSETS" like ROWSET1, ROWSET2 with repeating rows of data which we can use to populate Tables in the RTF.
The data structure looks like as shown in the following image.
But for report header, we also need some non-repeating data like Project Number, Project Name etc. which we can put at header of the report for which the XML data structure should be like as shown below:
Can anyone help me to know how to build such a data structure using the tools given in Oracle APEX Shared Components>>Report Queries?
Thanks and Regards