Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shared Components>>Reports>>Report Queries

HawkerHunterAug 9 2020

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

Comments

Vladimir Zhilyaev

Try to check this http://jdevadf.oracle.com/adf-richclient-demo/faces/components/inputComboboxListOfValues.jspx

Vladimir

Timo Hahn

***Moderator note (Timo): Vladimir

Please don't just answer by giving a link. Provide some more information on how you think the link will help to solve the problem. The Oracle Community – General FAQ state:

I have an excellent blog entry that answers a very complex user question. Can I just post a link as the answer?

Unfortunately, a link is not an answer. It’s a location of relevant and correct material to answer the question. And while the link to the blog is probably very useful, it will be flagged for review by the system moderators who are dedicated to ensuring the Community Platform is not susceptible to spam or any forms of promotion.

The best approach is always to “Answer in the Discussion” and in this case, that would mean providing enough content to address the question and answer it completely--if not in absolute detail at least to the extent that it achieves content correctness. Additional resources such as links to relevant and correct material can be offered as “for more information” or further explanation, but the answer should be complete. If an external blog entry is being linked, please provide a substantive quote from the blog entry to add context for users.

***

1 - 2

Post Details

Added on Aug 9 2020
#apex-discussions, #bi-publisher
0 comments
128 views