Objectives

IBM Cognos BI Report Studio (Fundamentals) is a two-day, instructor-led course. It is designed for report authors to learn report building techniques using relational data models, and ways of enhancing, customizing, and managing professional reports.

It is required that the attendees are able to work with Query Studio. Query Studio skills will help the attendee to differentiate Report Studio from Query Studio. In addition it will help the attendee to better understand and apply the theory.

This course applies to both Cognos version 8 and Cognos version 10: the course will be based on one version, but differences will be pointed out when neccessary.

Main topics

Attention will be paid to techniques to optimize the layout of reports.

• Orienting in Report Studio
• Create a simple list
• Creat a second page
• Format lists – Part 1
• Format lists – Part 2
• Use clipboard to save a report
• Learning to understand queries
• Detail or grouped
• Running totals, summaries and summary filters
• Create a prompt page in order to develop an interactive report
• Two lists with one query
• A list in a list in a list ...
• Point of attention: remove fields from a list
• Add additional totals to a crosstab
• Learn more about queries
• Headers and footers
• Understanding the layout structure and navigating
• How to manage the layout better?
• Create graphs and make changes to the layout
• Calculated fields and IF THEN ELSE
• Multiple data items in one column
• Create a drill-through
• Multiple pages within a repeating unit
• Repeaters
• Conditional layout
• Conditional styling
• No data available
• Singletons
• PDF layout
• Add table of content
• Bursting