I am trying to create a formula which would allow to pull the records from fields in two different tables and print the date in the report.
1.) I have a report with beginning and ending date parameters.
2.) I also have two formulas {@MinDate}
and {@MaxDate}
which print the minimum and maximum dates:
minimum{?Event date}
maximum{?Event date}
I think I’m good at this point.
3.) I am trying to create a formula which would allow to pull the records from fields in two different tables and print the date in the report.
The closest I have come is:
({EVENT.DATE}>= {@MinDate}
and{EVENT.DATE}<= {@MaxDate})OR
({CALENDAR.DATE}>= {@MinDate}
and{CALENDAR.DATE}<= {@MaxDate})
This formula is giving me a Boolean response, and I think I understand why it is giving me a Boolean response, but I don’t know what to do instead. I am looking for the report to show dates within the original parameters.
I’m am a beginner at Crystal Reports; sorry if this is a novice question.
Best Answer
What you have looks mostly fine, you just need to apply the comparison logic in the record selection formula instead of in a regular formula. I might also suggest that you create two separate date parameters instead of just using one that has multi-select or ranges.
To get to the record selection formula, Click "Report" in the toolbar → "Selection Formulas" → "Record". From there enter your logic:
Alternatively, if you go with two separate parameters, you can do away with the Min/Max formulas: