Jump to content
Sign in to follow this  
Jed69

Creating a Filtered Summary Report

Recommended Posts

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

Picture_3.png

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.