This is a migrated thread and some comments may be shown as answers.
Filtered Record Count
2 Answers 19 Views
This is a migrated thread and some comments may be shown as answers.
Scott
Top achievements
Rank 1
Scott asked on 01 Jul 2016, 02:55 PM

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?

2 Answers, 1 is accepted

Sort by
0
Accepted
Katia
Telerik team
answered on 05 Jul 2016, 01:02 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Scott
Top achievements
Rank 1
answered on 05 Jul 2016, 01:07 PM

Katia,

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

Thanks,

Scott

Asked by
Scott
Top achievements
Rank 1
Answers by
Katia
Telerik team
Scott
Top achievements
Rank 1
Share this question
or