If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Looping in Report Studio

Started by phoenixfire, 05 Nov 2010 06:55:40 PM

Previous topic - Next topic

phoenixfire

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.


phoenixfire

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?