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
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.
@FarheenA Create a database view using LISTAGG and connect the view with report definition
LISTAGG sample : Oracle LISTAGG() | How Does LISTAGG() Function Works in Oracle?