Master Detail Report - XML output is incorrect.

Question

Summary Master Detail Report - XML output is incorrect. Content Hello, I have the following contents in the datatemplate.xml The XML output generated based on the above is as follows SB1002 1002 Square Boxes SB1002 1002.1 12 inch box 1002 SB1002 1002.2 24 inch box 1002 SB2006 2006.1 Small size box 2006 SB2006 2006.2 Medium size box 2006 SB2006 2006 Misc. Boxes SB1002 1002.1 12 inch box 1002 SB1002 1002.2 24 inch box 1002 SB2006 2006.1 Small size box 2006 SB2006 2006.2 Medium size box 2006 The output is what is not what is expected, Ideally, I would like to have the detail for the corresponding or related PROD_SEQ, the expected XML output is as follows SB1002 1002 Square Boxes SB1002 1002.1 12 inch box 1002 SB1002 1002.2 24 inch box 1002 SB2006 2006 Misc. Boxes SB2006 2006.1 Small size box 2006 SB2006 2006.2 Medium size box 2006 How can I achieve the above output? Appreciate any insight

Brajesh Shukla-95078 · Answer

I think prod_mast_seq in prod_det contains the proj_seq of master table so you can do the below

Brajesh Shukla-95078 · Answer

Can you just copy paste your dataQuery only?

Brajesh Shukla-95078 · Answer

Do you have prod_seq column in table prod_det? If you have you can pass the prod_seq from the parent sql to child sql as below. This will restrict child sql to pick the value related to parent sql