Session–06–Report studio

Download Report

Transcript Session–06–Report studio

Gourav Atalkar
Software Engineer
bispsolutions.wordpress.com
•
•
•
•
Report Studio Basics.
Report Studio Interface.
Creating Sample Report.
Adding print button to report.
Report Studio is one of the component of reporting tool in Cognos 8 BI
suite which is extensively used for creating simple and advance
reports.
Report Studio is a Web-based tool that professional report authors use
to build sophisticated, multiple-page, multiple-query reports against
multiple databases.
With Report Studio, you can create any report that your company
requires, such as invoices, statements, and weekly sales and inventory
reports.
Tool Bar
Query Explorer
Insertable Object
Properties of Objects
Insertable object pane has all the query subjects and query items
from framework manager.
The Properties pane list the properties of objects in the report
creation.
The Tool Bar has all the operations that can be performed on the
report like group ,sort and so on.
Query Explorer provided the query generated for the report.
Open the Report Studio.
Select the New List Report option.
From the Insertable Object Pane drag the column(query items)
you want in the report to the report page.
Run the report by clicking on start button on the Tool Bar.
A List report will be generated in a new page.
A button is a control which is used to initiate an action. When
user click on button it trigger an action.
Following are the steps for the insertion of print button on the
report:
Step:1)
From Cognos Connection open Report Studio, In Report studio select
the Package for you want to create the report now select the type of
report from New tab like List, Cross tab, Chart , Map etc..
Step:2) Insert the columns from
insertable object Pane.
Step:3) From Insertable Object
Pane drag and drop “HTML ITEM”
Into the report.
HTML ITEM
Step:4) Double Click the html item and write the html code
(A code to create button is given below):
<input type="button“ onClick="window.print()“ value="Print
This Page"/>
Step:5) Press ‘OK’
Step:6) Now after writing the html script press the “start button”
Step:7) Now click on
Print Report button.
Step:8) Select printer
and have a print.
Presented By  Gourav Atalkar
Email [email protected]