Filtered Record Count

[Scott]

I am creating a report in the report designer.

My rows looks like this:

Name, TripID, DepartureDate

I have a row group that is grouping by Name.

I have two parameters, Start and End.

My table displays:

=Fields.Name, =Count(Fields.TripID)

My row group has two filters, so that the Start and End parameters filter rows if the departure date is not between Start and End.

Right now my display for Count(Fields.TripID) always displays the count of unfiltered rows.  What do I need to do to get the Count of filtered rows?

[Katia]

Hello Scott,

Check what filtering rules are applied to the Table item - How to: Add filtering to Table item and Crosstab item. Attached you can find a sample report demonstrating the scenario you described where the table records are filtered as expected (Count() function aggregates only the filtered records).

You can compare the settings in the attached report with those you have. In case, your scenario is different please attach a sample report demonstrating your current settings in a support ticket.

The attached report can be opened with the latest version of Standalone Designer or imported to Visual Studio.


Regards,
Katia
Telerik by Progress

[Scott]

Katia,

That was exactly the problem.  I had created a filter but not applied it to the row group.  Thanks!

Thanks,

Scott