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

Commas Messing Up Parameter Values

Started by cognos_geek, 14 Jan 2010 02:13:46 PM

Previous topic - Next topic

cognos_geek

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?