Hi all,
I am using a relational package and a list report.
Currently my report looks like this
Col 1 | Col2
A | abc
A | xyz
B | def
C | pqrs
C | tuv
I want to display it like this
Col 1 | Col2
A | abc;xyz
B | def
C | pqrs;tuv
Is there any technique to achieve this??
I have tried group by, running count along with conditional styles but data still appears on different rows. I need to concatenate the data into a single row.
Please help.
Hi,
Have u tried repeater table option. I think this can be acheived by using Repeater.
HTH
Hi Kattaviz,
your soln. of using a repeater works perfectly.
I had fact1 being joined with fact2 to make final_qry.
I have made a copy of final_qry and used the copy for Col2 (which is in a repeater) while the original final_qry is used for the entire list.
Thanks.