Filtered Record Count

3 posts, 1 answers
  1. Scott
    Scott avatar
    2 posts
    Member since:
    Jun 2016

    Posted 01 Jul 2016 Link to this post

    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. Answer
    Katia avatar
    760 posts

    Posted 05 Jul 2016 Link to this post

    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.

    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
  3. Scott
    Scott avatar
    2 posts
    Member since:
    Jun 2016

    Posted 05 Jul 2016 in reply to Katia Link to this post


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



Back to Top