COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => SDK => Topic started by: cognos_geek on 14 Jan 2010 02:13:46 PM

Title: Commas Messing Up Parameter Values
Post by: cognos_geek on 14 Jan 2010 02:13:46 PM
I'm writing a C# SDK app that runs a report containing a multi-select prompt; i.e., there's a filter where [Manager] in ?ManagerName?. The names in the manager column are formatted as "SMITH, JOHN A". I suspect that the comma after the last name is causing problems with the filter, because I'm getting no rows back where there should be many. Is there a way to escape the comma character so that it works in the filter?