Forum Stats

  • 3,851,533 Users
  • 2,263,994 Discussions
  • 7,904,770 Comments

Discussions

Shared Components>>Reports>>Report Queries

HawkerHunter
HawkerHunter Member Posts: 498 Bronze Badge

Hello Friends,

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.

pastedImage_0.png

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:

pastedImage_1.png

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

Hawker

Tagged: