Creating a Filtered Summary Report

[Jed69]

I have a summary report which works fine. It shows actions taken, grouped by staff and the specific action, and then it counts the number of actions. Each action has a date and I want to be able to filter the results if they fall between set dates. The dates which form the criteria for the report are entered in a custom dialogue box and become variables in the script. I have used these dates to give either a Yes or No result in a filed in the relevant table, the idea being to run the filter if the field says yes. So far so good, all works, but when I put the filter into the script the report does not run properly. Does anyone have any ideas? Picture of script attached

[comment]

Why don't you use the entered dates to find the records to report?

[Jed69]

Ok would love to but can not work out how to do it. The find will not let me put in the variables as a filter parameter. Can you tell me how I would do it?

[comment]

You cannot use dynamic criteria in a stored request. You need to do it this way:

...

Enter Find Mode []

Set Field [ Date ; $startDate & ".." & $endDate ]

Perform Find []

...

Note that Enter Find Mode [] and Perform Find [] have no selected options.

[Jed69]

OK thank you. That filter works and seems to have solved the other problem as well. Many thanks again