PC1MH techlog

If you need to search in a report for % it will not work. The % character is reserved in SQL. The solution is to use \% (Backslash Perce...

In certain reports, either data contains null values or the results of a complex query can return null values. When performing a calcu...

Sometimes a count needs to be made on data that needs to meet certain requirements. There are several ways to accomplish this. Here are two...

Edit the definition of the date/time field in Framework Manager. cast( [field in framework] as DATE )

If you need to replace the values '1' and '0' with 'Yes' and 'No' in Cognos Report Studio you will need to a...