COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Steve on 15 Feb 2011 02:34:04 PM

Title: Sorround values in single quotes
Post by: Steve on 15 Feb 2011 02:34:04 PM
I am wrecking my brains to make the sq macro work but it doesn't !

I have a prompt for selecting multiple years which results in a value like ' aaa, bbb, ccc'.

I need to break those 3 values and come up with 'aaa', 'bbb','ccc'.
Let's say the data item name is 'Item'. What would be the syntax?

Thanks