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.
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
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
(ii) Report output – when United States selection
(iii) Report output – when United Kingdom selection