Grouping in RTF

Question

Hi,

I am trying to make a create a report, for which I have two groups in XML file

Group 1 has Bill ID, RefID.

Group 2 has Code,Bill Amt, Total Amt

I cannot flatten the query and convert it to one query as relation between Bill ID,RefID and code is 1 to N ie one Bill can have many codes

so sub query gives me error like "ORA-01427: single-row subquery returns more than one row"

so I have created two query Group's

When I Try to achieve this by grouping in RTF Format template it gives me either

1) Data of only group 1

2) Either Data of Only group 2

3) or No data

based on position of start and end of the group.

Can any one help me on how to group this in RTF

my report structure is like

BIDREFIDCode
Bill Amt
Total AmtI123S345s1124124T323434TotalXXXXXX

924768 · Answer

Thanks for reply I tried by making 3 queries as well but same result. Actually there are few more columns which are based on Status column as shown below. in Q3 of below query (for eg GLOG_UTIL.REMOVE_DOMAIN(ILIR.INVOICE_LI_REFNUM_QUAL_GID)='SERVICE' WILL BE ONE MORE COLUMN) Please find below Query Template Format template INVID SHIPMENTNO MFG BASEAMT I INVID S SHIPMENTNO M MFG BASEAMT EM ES EI No data is retrieved Kindly Advice.

Venkat Thota - BIP · Answer

Is there any common column between two queries ? if possible please provide query structure so that we can try to achieve requirement either in query level or data model level or in RTF template.also two data model has common column then you can achieve this at data model level.Thanks

please upload xml and template.