Arul's.TEG Blog

When an email is sent through Cognos with a link to a Cognos report output, a message with 'Invalid URL syntax' is seen intermittently. Multi-server environment with a stand alone Content Manager (no gateway URI field in Cognos Configuration). Issue seen intermittently as it only fails when delivery done through Content Manager. When delivery through Application Tier service, link works. Depending on mail client, will either see 'Invalid URL syntax' or the link is simply not 'clickable'. If the URL is visible in the mail client, the server name (gateway) will be missing from the URL. Cause By default the Delivery Service is enabled on CM only and App Tier only installs. When running a report and sending link via email, you must have saved output. When the Delive...

This technique will allow users to enter a comma-separated string of multiple values that can be passed to a report parameter as a list of multiple items (essentially behaving as a mult-select prompt.) Text box prompts in IBM Cognos ReportNet (CRN) and Cognos 8 (C8) have a special 'Multi-Select' mode that allows users to enter multiple values to pass to a parameter in a report. To use a multi-select text box prompt, a user has to enter a value and hit an 'Insert' button to take a just-entered value and add it to a list of items that will be passed to the report parameter. In some cases, a more efficient way to pass multiple text strings to a parameter in a report is to enter comma separated values such as, "Camping Equipment, Mountaineering Equipment, Golf Equipment" rather than entering each value and hitting the "Insert" button in a multi-select text box prompt. There is no direct way to have a text box prompt handle a comma-separated value st...

Use a filter expression to parse out the values. For example, a report has a prompt with parameter ?ParamZipCode? and is used to filter query item [Zip Code] The filter expression would be as follows: cast([Zip Code],varchar(200)) in ( #csv ( split(' ', split(',', split(' ,', split(' , ', split(', ', prompt('paramZipCode','token') ) ) ) ) ) ) # ) This filter converts the Zip Code to text and looks for the value IN a list of comma separated values. Due to the nature of the macro functions, the result of the function is a series of string elements. The cast function applied to a numeric field ensures that the appropriate data types are being used within the filter expression. The split() macro functions are in place to handle additional white space that users may enter between the comma-delimited values.