Print Page - How to generate Top N Active Reports

Title: How to generate Top N Active Reports
Post by: Prem Mehrotra on 31 Mar 2013 12:21:09 AM

I have developed a non active Report using ReportStudio, where I select no of Top N rows to be shown as a pull down list. Then the value select is passed
To a cross tab summary which uses an expression:
RankEventCount <= ?ParamTopXRows?

Where ParamTopXRows is set by the pull down list.

I converted this to Active Report. I have a Data Drop Down List (similar to pull down list) and it sets Active Reports Variable ParamTopXRows. Now set up a connection between Data Drop Down List and Crosstab, but do not know how to pass the value of variable to Summary Filter.

Any pointers will be greatly appreciated.

Title: Re: How to generate Top N Active Reports
Post by: Rahul Ganguli on 02 Apr 2013 01:12:16 AM

Hi,

You have to create a connection between the dropdown and dataset.
Add recieving event on Dataset from Dropdown.

You can refer the following link for a good insights on Active reports
http://www.ibm.com/developerworks/data/library/cognos/reporting/active_report/page593.html

Regards,
Rahul

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: Prem Mehrotra on 31 Mar 2013 12:21:09 AM