Skip Navigation
*To search for student contact information, login to FlashLine and choose the "Directory" icon in the FlashLine masthead (blue bar).

Find out about our services
Three ways to get support
Learn how we provide educational tools for in the classroom and online

Cognos Resources


Cognos is used to create and distribute custom reports of Banner and other data. 

Cognos Open Labs for report writers are held on the first and third Thursday of the month
in 103 Stewart Hall, from 9:00 am to 4:00 pm. 


Karate Belt

"Master the Art of Business Intelligence"


White Belt
  • Report Studio (PDF)
Yellow Belt  
Series I
  • Inserting Code and Description in Prompt (PDF)
  • Inserting Code and Description in Report (PDF)
  • Prompt Value in Title (PDF)
Series II
  • Cascading Prompt (PDF)
  • Building Drill-Through Reports (PDF)
Series III
  • Inserting Charts (PDF)
  • Multiple Queries (PDF)
Orange Belt  
Series I
  • Create a Portlet (PDF)
  • Limit Number of Records Returned (PDF)
Series II
  • Condensed List Report (PDF)
  • Using the List of Values (PDF)
  • Change Sort Order (PDF)
Series III
  • Headers and Footers (PDF)
  • Crosstab Reports (PDF)
  • Conditional Formatting (PDF)
Blue Belt  
Series I
  • Street Address and E-mail Slot (PDF)
  • Page Breaks (PDF)
Series II
  • Return Part of a Field (PDF)
  • Advanced Sorting Techniques (PDF)
Series III
  • One-Click Dynamic Column Sorting (PDF)
  • Using Banner and Metadata to Locate Query Items (PDF)
Green Belt  
Series I
  • Nesting Chart and Crosstab Data (PDF)
  • Customize and Reuse Color Palettes (PDF)
Series II
  • Add Custom Properties to Charts (PDF)
  • Prompt Types (PDF)
Series III
  • List vs. Crosstabs (PDF)
  • Online Report Inventory (PDF)
Purple Belt  
Series I
  • Functions (PDF)
  • Function Definitions Table (PDF)
Series II
  • User Defined Prompts and Maps (PDF)
Series III
  • Best Practices PowerPoint (PDF)
  • Adding Kent State Portlet (PDF)
  • List of Values (PDF)
  • Scheduling (PDF)
Brown Belt  
Series I
  • Joins (PDF)
  • Reference Queries (PDF)
Series II
  • Personalized Letters (PDF)
  • Page Sets (PDF)
Series III
  • Creating Slots (PDF)
Black Belt  
  • Eligible Candidates Contacted



Please contact with any questions regarding the Cognos Karate Belt System