Go to Top

Blog Archives

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, 1, getdate()) Result in SQL Server Management Studio: Mar 16, 2015 12:19:27 PM Result in Cognos: Parsing error before or near position: 12 of: “dateadd(mm,” Solution: You must wrap the “mm” in curly brackets “{}” Working Query Calculation: …Read More

Cognos Page Numbering

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.  Cognos will page break but continue with the same page numbering unless you tell it to reset.  Let’s lock this down. If haven’t done page sets for page breaks then just file this tip away until …Read More

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 page?  If so, simple solution:  Uncheck “Horizontal Pagination” in your reports and all columns will force themselves onto a single page. Rows will still break.