Development

Active Reports Using the Data Toggle Bar in Cognos

Active reports are highly interactive and make business intelligence easier for the casual user. Any report generated within Cognos can be saved as an Active report and consumed remotely with no connection to the BI Server. The report is created in the MHT format and the report and its data are saved in a single easily distributed document. The recipient needs no access to the BI Server to consume the report, just a simple browser with MHTML support.

Sales Analysis using Active Report
The user requirement is to create an active report analyzing sales by country. A list report is used to show sales by country, with a Data toggle bar control to allow users to move between different country regions. Users will have the option to show or hide the country by respectively selecting or clearing a toggle bar.

Active Reports Using the Data Toggle Bar in Cognos

Open a new active report and create queries for the Data toggle bar to display country and list report to display detail for sales information

Active Reports Using the Data Toggle Bar in Cognos

Create a connection between the Data toggle bar and the list report with the filter option using country region and set the default sorting option based on the requirement. Run the report.

(i) Report output – when no country selection

Active Reports Using the Data Toggle Bar in Cognos

(ii) Report output – when United States selection

Active Reports Using the Data Toggle Bar in Cognos

(iii) Report output – when United Kingdom selection

Active Reports Using the Data Toggle Bar in Cognos

About the Author

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories