I have a basic form which records events and any correspondance related to that event.
I would like to produce a "report" where the user can select from the predefined date ranges (this week, last week, this month , last month, etc...) and have the list return only the results from the specified range.
Can someone point me inthe right direction?
There are probably a number of ways to do this, but this is one way using only smartforms.
If you need to precise about the date range, for example you want Last Week to be Monday - Sunday of the previous week (not just the last seven days from Today) then you can use some of the other date functions, such as Start of Week, End of Month etc. You might need to get a bit creative with these to get the dates you need.
I will have a look at this.
If I drop the OOB report header onto a blank form then there is the ability to select predetermined date ranges, to be honest I was hoping these would be avialble easily so I don't have to recreate the wheel (as per the attached screen shot).
This appears to be reporting base don workflows, there are no workflows in my system, purely some forms which populate and report on a SQL table.