Cognos Tech Tip: Punch up your Cognos. Our experts provided this tip on how to keep totals and footers from breaking onto a separate page. Go to Properties on a list Select Pagination L...
Cognos Tech Tip: Do you ever wish you had a query with every day?
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 (...
Cognos Tech Tip: SQL Functions in Cognos
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...
Cognos Tech Tip: Case of the Corrupted PDF File
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 ...
Cognos Page Numbering
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
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...
Cognos Tips & Tricks: Dynamic Sort and Group
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 ...