Posted: 26 Nov 2020 5:12 EST Last activity: 3 Dec 2020 15:30 EST
Comma Separated Report Column Values in Single Row
In Report Definition, how can we get column values in a single row if their PYID is same. For instance: If PYID 1 has corresponding 3 statuses, it should display all the statuses in one single row separated by comma rather than displaying 3 rows. Please refer attachment for more clarity.
***Edited by Moderator: Pooja Gadige to change category from General to Product, add product details, add platform capability tag***
***Edited by Moderator: Pooja Gadige to update product version***
If there are "concat" functions available in your database, you will need to write a SQL function alias to use them. Just know that if you change databases in the future, the function alias will stop working, so there is a potential maintenance issue.