My apologies for the late reply, due to other issues I have not been able to test your approach. I will certainly try and will update you. On 17 Oct 2017 09:39, "community-admin" <community-prod-admin_ww@oracle.com>

Constrict your data template based on that global temporary table. This is where I have one problem, the data from refcursor varies based on the parameter and the column heading will have different names, to be precise the headings are dynamic in nature, it is not static. So how do I need construct data definition and…

Thanks ​ for the valuable help.

I will certainly try this approach. I have a question, is it possible to have column values as headings instead of typing or manually creating headings in the RTF template? On 27 Sep 2017 13:42, "community-admin" <community-prod-admin_ww@oracle.com>

Hi, I have included XML with the date. <?xml version="1.0" encoding="UTF-8" ?> <Test> <LIST_G_TEST> <G_TEST> <P_START_DATE>18-SEP-2017</P_START_DATE> <MONDAY>Yes</MONDAY> <TUESDAY>Yes</TUESDAY> <WEDNESDAY>No</WEDNESDAY> <THURSDAY>Yes</THURSDAY> <FRIDAY>No</FRIDAY> </G_TEST> </LIST_G_TEST> </Test>

Hello, My expected output is shown in the enclosed screenshot,

you can user <?format-date:ParameterName;'day-dd';'Asia/India'?> I presume that I can exclude the day as I need only the date which is 'dd' and second question is do I need Asia/India? Can I substitute with any Country/Region?

for the format 'day-dd' if date is 25-Sep-2017. it will return Monday-25. You may need to do substr to get Mon-25 The heading already exist, all I need to do is concatenate 'dd'.

I have tried as shown in the enclosed screenshot, however, the date is getting displayed along with the heading.

I have emailed you the sample test data and rtf. Thanks

This has helped to resolve the issue, appreciated.

Hi, I have tried your suggestion, however, Product Number, Description, Location and suchlike are getting repeated for detail group. Secondly, in the screenshot Prod Main Seq, Prod Mast Name are shown, how to display this? My expected output is shown in the enclosed screenshot.

The issue has been resolved, thanks for the help, much appreciated.

Brajesh, Would you suggest good articles, tutorials and suchlike for these kinds of BI Reports (XML Publisher)?

1. Output of each new Product Number (e.g. Product Number: P5900) should start with new page? Yes, that's right. 2. Any one Prod Main Seq.(Prod Main Seq. 30) should not split into two pages in this case it should ideally come to one page? Yes, one Prod Main Seq should not be split into two pages, ideally as one group. Ex.…

Hi, Thanks for the detailed replies with the files and the output. I have a question regarding the generated XML, my data definition is not generating the output as you had generated and to be honest I am not sure how to change my data definition to generate the expected XML output. I have attached my data definition XML…

Excuse me for my ignorance, I am unable to find an option to attach files. I could email you the files as an option.

Hi, Can you try accessing from https://www.dropbox.com/s/5kv6ewqlsmzmp1o/Files%20%281%29.zip?dl=0 Regards

Thanks for the update. When I tried to provide the bind variable in the detail query, I am not getting the details in the XML output, only master information I appearing. Regards

I reckon that bind variable should not be passed as a parameter.