In report definition - How to make multiple rows of a index join into a single row
Hi,
We have a RD where there is a index- Join.
the Results are like this:
Column A Column B Column C
W1 A B
W1 C D
W1 E F
W2 X Y
W2 Z A
W3 A G
But expecting the reports to display it as
Column A Column B
W1 A-B, C-D,E-F
W2 X-Y, Z-A
W3 A-G
Please help in acheiving this output in RD
Accepted Solution
Updated: 7 Oct 2024 3:41 EDT
Oligos
FR
Hi @FarheenA, seems, this is something which can not be achieved using Report definition. you may need to use a Data Page taken as source your Report definition and add a response data transform to fetch data from your report as Data Source and append it to your DP after concatenating your records based on primary key.
Maantic Inc
US
@FarheenA Create a database view using LISTAGG and connect the view with report definition
LISTAGG sample : https://www.educba.com/oracle-listagg/