Scribd
Upload
4 views5 pages

Practical 3

The document outlines a practical exercise for formatting reports using IBM Cognos Analytics, including steps to create a list report, apply headers, footers, and color formatting, as well as grouping and sorting data. It emphasizes the importance of enhancing report presentation and readability through these formatting features. The exercise aims to familiarize users with the tools and options available in IBM Cognos for effective report creation.

Uploaded by

nishantthewine
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views5 pages

Practical 3

The document outlines a practical exercise for formatting reports using IBM Cognos Analytics, including steps to create a list report, apply headers, footers, and color formatting, as well as grouping and sorting data. It emphasizes the importance of enhancing report presentation and readability through these formatting features. The exercise aims to familiarize users with the tools and options available in IBM Cognos for effective report creation.

Uploaded by

nishantthewine
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Practical-03

Definition:

Apply formatting like header, footer, grouping, sorting, color, and font on list and other
reports.

Aim:

To create effects in reports with the help of formatting features.

Working/Perform:
1. Open IBM Cognos Tool.
2. Select the Present Data option and then choose the Report option.
3. Select the template and theme which you want to apply.
4. Now select the data source from where you want to use the data.
5. Insert a List report and drag and drop the required data items from the Data Source
panel.
6. Apply formatting options such as adding Header and Footer, changing font style,
size, and color, and applying background colors if required.
7. Apply Grouping and Sorting to organize the data properly in the report.
8. After completing the formatting, save the report and run it in HTML form to view
the formatted report.

Outcomes/Learning:
• Understanding formatting options in IBM Cognos reports
• Learning how to apply header, footer, grouping, and sorting
• Improving the presentation and readability of reports

Required Tool:
IBM Cognos Analytics

Ved Mahindru 202410702190065 BBA(BA)


1) Open IBM Cognos Home Page

Open the IBM Cognos Analytics tool and the Home Page will appear on the screen.

2) Create an Empty List Report

Click on Present Data → Report, then select a Blank template and insert a List report.

Ved Mahindru 202410702190065 BBA(BA)


3) Select the Data Source

Choose the data source / package from which the data will be imported into the report.

4) Insert Data into the List

Drag and drop the required fields (for example: Country, Branch, Sales, Revenue, Year)
from the Data Source panel into the List report.

Ved Mahindru 202410702190065 BBA(BA)


5) Apply Colour Formatting

Select the required columns or rows and apply background color or font color using the
Properties or Formatting options to make the report more attractive.

6) Sort Year in Descending Order

Select the Year column, then apply Sorting → Descending Order so that the latest year
appears first.

Ved Mahindru 202410702190065 BBA(BA)


7) Combine Two Columns

Select two related columns and combine or group them using formatting or grouping
options to organize the report properly.

8) Run the Report

After completing all the formatting and data arrangement, save the report.
Then click on the Run As button available at the top of the screen and select HTML to
execute the report and view the final output.

Ved Mahindru 202410702190065 BBA(BA)

You might also like