How to generate Top N Active Reports

[Prem Mehrotra]

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.

[Rahul Ganguli]

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