You can create a new report by inserting objects from the data source in the Query Studio. You can also change an existing report and save it with different name.

You can open Query Studio by going to Query my data option on the home page or you can go to Launch → Query Studio.

How to open, create, save, run and print report in Cognos

In the next screen, you will be prompted to select a package to add objects in the reports. You can select a recently used package or any other package created in the Framework Manager.

How to open, create, save, run and print report in Cognos

You can see Query items listed on the left side. You can add data and save the report.

How to open, create, save, run and print report in Cognos

Cognos – Open an Existing Report

You can open an existing report in the Query Studio and save it with a different name after making changes.

To open an existing report, locate and click the name of the report you want to open.

The report opens in the Query Studio. You can use the Open with Query Studio to identify a Query Studio report in the Cognos Connection.

Or you can launch Query Studio and go to open option at the top.

How to open, create, save, run and print report in Cognos

Search the report in the list of Available folders → OK

How to open, create, save, run and print report in Cognos

Cognos – Add Data to a Report

You can add objects from a data source. Each object has a representative icon and can insert all the following objects to a report.

How to open, create, save, run and print report in Cognos

Cognos – Saving a Report

When you save a report in the Query Studio, it saves the query definition. It doesn’t save the data while saving the report. When you run a report saved a week back, the data in that report reflects the recent changes in the data source.

To save a report, click on the Save icon at the top.

How to open, create, save, run and print report in Cognos

In the next screen, enter the name, description and location where you want to save the report → OK.

How to open, create, save, run and print report in Cognos

Saving a Report with a different Name and Location

You can use Save as option to save a report with different name or at a different location as shown in the following screenshot.

How to open, create, save, run and print report in Cognos

Specify a name and location − To include a description, type the information you want to add in the Description box.

How to open, create, save, run and print report in Cognos

Click OK.

Cognos – Run a Report

A report in the Query Studio runs when you update data from data source in the report. When you open an existing report or make any changes to a report, Query Studio again runs the report.

You can use the following options to run a report −

• Run with Prompt − You can run a report using a user prompt. When you run the report, you are prompted to select the value.
• Run with all Data − The Run with all data command runs the report using the full data source. Running a report can take a long time. If you plan to make several changes to a report, run the report in preview mode to save time and computer resources by limiting the rows of data that your report retrieves.
• Preview Report with no Data − You can use the preview option when you want to see how the report will look like.This is useful when you want to make formatting changes.

Open the report that you want in Query Studio. From the Run Report menu, choose how to run the report −
To run the report using all the data, click Run with All Data as shown in the following screenshot.

How to open, create, save, run and print report in Cognos

To run the report using limited data, click Preview with Limited Data.

How to open, create, save, run and print report in Cognos

If the package that the report is based on contains a design filter, performance is improved.

To run the report using no data, click Preview with No Data.

Run a Report in PDF, XML, and CSV format

You can run a report in PDF, XML or in a CSV format. To run a report in different formats, select the report and click on Run with options.

How to open, create, save, run and print report in Cognos

Select the format in which you want to run the report. You can choose from the following formats. Select the format and click Run at the bottom as shown in the following screenshot.

How to open, create, save, run and print report in Cognos

Cognos – Printing a Report

You can also print a report to get a copy on paper. You can directly enter the Printer location while running the report or you can run the report in a PDF format and later you can take a printout of the report.

To take the print of the report directly, select the report and click on Run with options.

In the Delivery mode, select print the report and enter the location as shown in the following screenshot.

How to open, create, save, run and print report in Cognos

So, this brings us to the end of blog. This Tecklearn ‘How to open, create, save, run and print report in Cognos’ blog helps you with commonly asked questions if you are looking out for a job in Cognos BI. If you wish to learn Cognos Analytics and build a career in Business Intelligence domain, then check out our interactive, IBM Cognos Analytics Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

IBM Cognos Analytics 11 Training

IBM Cognos Analytics 11 Training

About the Course

IBM Cognos 11 training provides in-detailed knowledge on how to build complex and advanced reports and dashboards using IBM Cognos reporting tool, and this will enable you to become a Cognos developer. Major topics of this Cognos reports and dashboard training include Cognos architecture, the components of Cognos, Analysis Studio, OLTP system, Query Studio, advanced report designing, Cognos Framework Manager and Cognos Administration. By the end of this training, you will get an insight into working with IBM Cognos reporting tool by implementing real-time Cognos projects, and you will be able to use this knowledge in real-time environments.

Why Should you take IBM Cognos Analytics 11 Training?

• The average Cognos developer salary is $78417 or an equivalent hourly rate of $38-Erieri.com.
• Cognos has a market share of around 9% globally.
• Cognos Analytics V11 enhances the efficiency and capabilities of business users, report authors, and administrators alike through a simplification of and the graduated nature of its user experience.

What you will Learn in this Course?

Overview of IBM Cognos BI and Cognos BI Architecture

• Overview of IBM Cognos Analytics 11
• IBM Cognos Framework Manager Modelling
• New UI features of Cognos Analytics 11

Cognos Analytics 11: Data Modules

• Overview of Cognos Analytics 11 Data Modules
• Creation of Data Server Connection
• Using Data Modules to modulate data without using the Framework Manager
• Data Discovery through intent-based modelling
• Creating Data modules with inputs from various sources

Working with Dashboards

• Process of Dashboarding in IBM Cognos
• Creating a Dashboard
• Filter Data in Dashboard
• Widget-to-Widget Communication
• Sorting, Grouping and Calculating Data
• Storytelling

Cognos Environment

• Active Report
• New Visualization Types
• Sharing and Embedding Contents

Cognos Reports

• Cognos Report Studio
• Reporting using Filters, Formatting, Charts
• Advance Report Building Techniques
• Cognos Active Reports
• Geo Spatial Analytics

Cognos Administration

• Deep Dive into Cognos Administration
• Analysing and Administering Queries

Dimension Modelling

• New Features in Smart Modelling
• Transformer Cube and Drill through
• Dynamic Cube and Drill Though

577