Is it possible to write loops in report studio?
ID Type Info
---------------------------------------------
0001 AAA XYZ
0001 BBB WXY
0001 BBB VWX
0001 CCC ABC
0002 GGG UVW
0002 HHH TUV
I need to be able to display XYZ,WXY,VWX,ABC for ID 0001.
For ID 0002, it should be UVW,TUV and so on for all IDs.
Is there anyway for me to do this in Report Studio? Basically, I need to create a comma separated value column that shows the 'Info' column values separated by a comma for each ID.
::)
Thank you very much in advance.
Please refer http://www.cognoise.com/community/index.php/topic,4748.msg16642.html#msg16642
Thank you but the technique described in the article works only for display purposes. I need to create a comma separated value so I can use it in a filter.
Any ideas?