[Inquiry] How to display dynamic rows and cols data set thru XML publisher/RTF
Hi Gurus,Just want to seek any inputs from here. I wanted to design a report(XML to eBS) that would output in Excel(csv format). I already have the query on the rdf source file. But now when feeding the xml output to publisher with my created RTF template, Im not getting what is required. Probably i need to tweak my sql query or it is in my template formatting?
Could someone advise on the approach i need to apply with the below request? From my sample below, I need to generate accounts(could be more than 1) then (ROW data) per account there will be 2 parent(only) and then each parent could have 1 or more child account. and Currency(could be more than 1) - my COLUMN Data - each child account could have many records of currencies.With this my set of records varies in number of rows and columns.
Could someone advise on the approach i need to apply with the below request? From my sample below, I need to generate accounts(could be more than 1) then (ROW data) per account there will be 2 parent(only) and then each parent could have 1 or more child account. and Currency(could be more than 1) - my COLUMN Data - each child account could have many records of currencies.With this my set of records varies in number of rows and columns.
0