How to display Report results based on Date range Selection
I have a table called General Ledger and I can make a nice report out of it which displays:
Invoice Number, Invoice Date, Supplier Name, Type of Transaction
I'd like to have to drop lists somewhere on the Layout where I could choose date range of that report i.e. a tax year: so the first would be a date field with 4th April 2013 and second 3rd April 2014.
That way the report would only show the transactions between these dates.
Something like the Excel function "Data Filter".
Define two global date fields. Use them with a script to perform a find where the two dates selected in the global fields are used to do a date range find.
See this thread for examples of that find and many others: Scripted Find Examples