Skip to Content
0
Former Member
Feb 16, 2011 at 12:20 AM

Count of Rows Displayed after Filter Applied

2276 Views

Hi,

I have a WebI report where I am manually filtering the data displayed within the report based on user input. For example, a user enters a Max Value and I am filtering out all employees who have a total value (mulitple rows summed up) greater than the prompt value.

The issue I am facing is displaying a row count at the top of the report in a free-standing cell. Normally I would simply use count(Field;All) but since the number of rows returned by the query is different from the number of rows actually displayed in the table, this option isn't available.

Any ideas would be greatly appreciated.

Thanks!

Jeff