Table of Contents

 Cognos Connection Website
           Exercise 1—Open the Cognos Connection Web Site.

Open Report Studio        
           Exercise 2—Open Report Studio and Begin a New Report.

The Report Studio Window      

Report Terminology    

Add Data to a Report      
            Exercise 3—Add Data to a Report and Save It.

Run the Report    
             Exercise 4—Validate and Run the Report.

Types of Reports                                                                              
List Reports        
Grouped List Reports      
            Exercise 5—Create a Grouped List Report and Set the Level Span

Create Repeated Form Frames from a List      
             Exercise 6—Create Repeated Form Frames from a List

Crosstab Reports                                                                                                                    Exercise 7—Create a New Crosstab Report.
             Exercise 8—Create a Crosstab Report from an Existing Report.

Charts                                                                                                                  
             Exercise 9—View the Types of Report Studio Charts.
Create a Chart    
             Exercise 10—Create a Column Chart.
             Exercise 11—Create a Combination Chart.

Manipulate Data in Reports                                                                    
Filters        
             Exercise 12—Add a Filter.

Filter on Details and Summaries      
             Exercise 13—Filter on Details
             Exercise 14—Create a Summary Filter.

Filter Groups      
             Exercise 15—Filter Groups.
Filter Crosstabs    
            Exercise 16—Filter a Crosstab Report.

Prompts      
            Exercise 17—Add a Prompt.
            Exercise 18—Use the “Build Prompt Page” Tool.

Cascading Prompts      
            Exercise 19—Build a Cascading Prompt.
            Exercise 20—Create a Single-Value Cascading Prompt.
            Exercise 21—Create a Multiple-Value Cascading Prompt.

Optional Prompts    
             Exercise 22—Add an Optional Prompt.
Drill Throughs    
            Exercise 23—Create a Target Report.
            Exercise 24—Create a Parent Report with a Drill Through.

Report Layouts                                                                                            
            Exercise 25—Create a Report Layout.
            Exercise 26—Create a Crosstab Report from Scratch.

Advanced Techniques                                                                                              
            Exercise 27—Change the Organization of a List Report.
            Exercise 28—Add Styling at a Higher Level.
            Exercise 29—Add an Image or Annotate a Crosstab Report.

Report Studio Queries                                                                                  
            Exercise 30—Explore the Report Studio Tabular Model.
            Exercise 31—Work with the Report Studio Cube Definition.

Master-Detail Reports                                                                                              
            Exercise 32—Create a Master-Detail Report.
            Exercise 33—Add a Filter to a Master-Detail Report.

Parent-Child Report                                                                                  
          Exercise 34—Create a Parent-Child Report.

Create an Invoice                                                                                                    
            Exercise 35—Create a Query for an Invoice.
            Exercise 36—Build the Invoice Page Header.
            Exercise 37—Create the Invoice Page Body.
            Exercise 38—Add Data to the Invoice.
            Exercise 39—Add a List Footer to the Report.

Create a Template                                                                                                  
            Exercise 40—Create a  Report Template.