Filtered Record Count

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

    Posted 01 Jul 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
    Admin
    Katia avatar
    309 posts

    Posted 05 Jul 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.


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

    Posted 05 Jul in reply to Katia Link to this post

    Katia,

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

    Thanks,

    Scott

Back to Top