Selection Record Formula filitering on 'not between an entered date range
Crystal 2008
I am trying to show personnel that did not attend classes between a
certain date range. For example, the user may enter the date range
between 01/01/2006 and 07/11/2011. I would like to show all who have not attend
class during this date range.
In other words, is there a way in the selection record formula, that I can
say not between entered date ranges
In the personnel records you may have for example:
John Doe Lecture 101 01/01/2007
John Doe Lecture 102 04/21/2008
Mary Doe Lecture 100 12/31/2005
In this case John Doe would not show up on the not attend class list but Mary Doe
would.
I am trying to show personnel that did not attend classes between a
certain date range. For example, the user may enter the date range
between 01/01/2006 and 07/11/2011. I would like to show all who have not attend
class during this date range.
In other words, is there a way in the selection record formula, that I can
say not between entered date ranges
In the personnel records you may have for example:
John Doe Lecture 101 01/01/2007
John Doe Lecture 102 04/21/2008
Mary Doe Lecture 100 12/31/2005
In this case John Doe would not show up on the not attend class list but Mary Doe
would.
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
No, you would use this for the report as the COMMAND.
mlmcc
mlmcc
To do this in your record selection formula, you need to first determine if you are using one range parameter or two individual parameters to get the start and end dates of the range.
Once you have that, you can use one of the solutions below depending on what you determined above. Either way, I would use these in the Record Select Formula under Report->Selection Formulas->Record.
//One Date Range Parameter
Not({table.datefield} in Minimum({?Date Range Param}) to Maximum({?Date Range Param}))
//Two individual date parameters
Not({table.datefield} in {?Begin Date Param} to {?End Date Param})
Once you have that, you can use one of the solutions below depending on what you determined above. Either way, I would use these in the Record Select Formula under Report->Selection Formulas->Record.
//One Date Range Parameter
Not({table.datefield} in Minimum({?Date Range Param}) to Maximum({?Date Range Param}))
//Two individual date parameters
Not({table.datefield} in {?Begin Date Param} to {?End Date Param})
He needs to find all who aren't in a range so he needs to use a Command. The select expert won't allow a subquery to find all in the range
mlmcc
mlmcc
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
I am unable to ask a new question because this question is showing an abandon status. However, I accepted a solution to this question. I am confused as how to close these abandon questions. Could there be an administrative close?
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER