PC1MH techlog

Personal techlog from PC1MH
Stuff you will not find in the manual.
Tricks, hacks and discoveries in a journey through the world of technology.

Showing posts with label Cognos. Show all posts
Showing posts with label Cognos. Show all posts
Monday, July 21, 2025

Cognos report, how to count double items in a list?

›
Create a Data Item  count ( [item] for [item] )  The amount of appearances of [item]  in the list is counted. Item    count A          2 A  ...
Tuesday, September 08, 2015

How to search for % in a string in Cognos Report Studio

›
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...
Thursday, February 13, 2014

How to concat in Cognos report studio, blank / null problem Oracle

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

Cognos Report Studio: How to add one title to one list.

›
How to add one title per list. If there are two lists in one page body the titles should appear only at the top of the list it belongs to an...
›
Home
View web version

About Me

My photo
Marc
Twente, Netherlands
View my complete profile
Powered by Blogger.