Cognos Queries Sometimes people want to see every day in a month even if there aren’t records. For instance show me the entire month and the number of marketing transactions that happened per day (...

SQL Functions in Cognos If you have tried using certain SQL functions that you know should work but you get errors…you may have to modify your syntax slightly for Cognos. Example: dateadd(mm...

Case of the corrupted pdf file in Cognos Recently one of our clients experienced an issue with a Cognos report that was not correctly saving as a PDF. When they tried to reopen the report from their ...

Dashboards: More than just a pretty face! You know you need business intelligence (BI), but you want it to be successful and have substance. Like they say, not just another pretty face. If you think ...

Hey folks, If you’ve ever set up page breaking (for statements and such) then you may or may not have realized your page numbers don’t automatically reset for each new report/statement.  Cogno...

Cognos: Remove Horizontal Pagination on Reports Today’s tip is something that seems like it would be pretty simple, however, it can cause issues!  Are some columns in your report going to the next...

Automoated Reports with Cognos Ever feel like creating a report is an act of congress? Many of our customers were manually assembling reports using the valuable data they get from various differ...

Subject:  Dynamic Sort and Group Steps for Sorting: Build a dynamic “data item” based on a prompt. If (?Sort Prompt? = ‘Sort Column’)Then ([Sort Column])… Add the new “data ...

See how how report authors can easily create interactive disconnected reports with the Cognos Active Report feature. With Cognos Active Report, authors can create reports that meet the needs of ever...