If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Summary row count for filtered list in active report

Started by JBCLARK20, 21 Nov 2013 10:44:58 AM

Previous topic - Next topic

JBCLARK20

The active report has lists which are filtered by a hierarchy.
The hierarchy has multiple levels and each level has a variable : V Hier 1, V Hier2 and so on.
The user can select each level of the hierarchy from a separate data list.
Hierarchy 1 Data list filters Hierarchy 2 Data list and so on.
The user filters the list based on the user's selections in the hierarchy.

The desired result is a count of rows in the list after the user has filtered the list.
Just to make it fun, I also want to have the list area display "No data to report based on the selection criteria" if the number of rows in the list is 0 if the user filters away the results.

Thank you.