Filter Table By Date Parameters

Filter Table By Date Parameters

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

• 

  faqts

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

• 

  faqts

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  sergey.abakumov

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  faqts

  • Post Options:
  • Link
    Copy

  Posted 15 March 2021, 10:58 pm EST

  Fantastic, thank you for your help, that’s exactly what I needed.