Filter Table By Date Parameters

Posted by: faqts on 15 March 2021, 6:54 am EST

  • Posted 15 March 2021, 6:54 am EST

    I am having difficulty filtering a table by date parameters. The attached report made in the standalone report designer has two parameters: a start date and an end date. I would like to filter the table by the [Date] field for records that fall between these dates.


    I have added a filter expression that I believe should work but it returns no records. If you remove the filter expression on the table you can see there is sample data for 1/25/21. Parameter date ranges that include 1/25/21 should show results, but aren't.

    Can you assist me in determining what is wrong it please?
    TimecardStatusReport - Sample.zipTimecardStatusReport - Sample.zip
  • Replied 15 March 2021, 6:56 am EST

    I seem to have attached the .zip twice, it's the same file, please ignore the duplicate upload.

    Thanks in advance
  • Marked as Answer

    Replied 15 March 2021, 9:00 pm EST

    Hello, Michael,
    Please find the fixed report in the attachment. I made a couple of adjustments
    1) Json Path in the data set should be $.* You can read more about Json Path syntax at https://goessner.net/articles/JsonPath/
    2) I tagged the Date field in the data set with the [Date] suffix. You can read about it at https://www.grapecity.com/activereportsjs/docs/ReportAuthorGuide/Databinding#data-set-fields

    Hope this helps!

    TimecardStatusReport - Sample.zip
  • Replied 15 March 2021, 10:58 pm EST

    Fantastic, thank you for your help, that's exactly what I needed.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels