Crystal Reports Record Selection Formula Based on Two Date Fields

Hello Experts,

I am working on a report (Crystal Reports version 11), that uses a global date parameter to link multiple subreports.  When I run the report I enter a single date range and each subreport has the following in its record selection:
{MManpower.M_tTime} >= {?Pm-@Begin Range} and
{MManpower.M_tTime} <= {?Pm-@End Range}

My quandary is that I am trying to add a second date condition in the record selection using the following syntax:
(({MManpower.M_tTime} >= {?Pm-@Begin Range} and
{MManpower.M_tTime} <= {?Pm-@End Range})
or
({IIncident.I_tTimeTransmit} >= {?Pm-@Begin Range} and
{IIncident.I_tTimeTransmit} <= {?Pm-@End Range}))

But, I am not getting records back that are based on the second table.date field - I am only getting records back based on the first table.field.  Is this because the subreport link in the primary report is based on only the first table.field?  If so, is there a way to link the global date parameter in the subreport links to more than one table.field?  Or, is my syntax incorrect? Or do I need a different work-around?

Thank you for your help with this.
~Chopp
ChoppAsked:
Who is Participating?
 
kingjelyConnect With a Mentor Commented:
Do you need OR, or AND as the operator here?

Do both date conditions need to be met in the subreport(only) OR both ?

(({MManpower.M_tTime} >= {?Pm-@Begin Range} and
{MManpower.M_tTime} <= {?Pm-@End Range})
or
({IIncident.I_tTimeTransmit} >= {?Pm-@Begin Range} and
{IIncident.I_tTimeTransmit} <= {?Pm-@End Range}))
0
 
tickettConnect With a Mentor Commented:
Yes- be careful about grouping AND/OR statements.

Instead of {table.timeField} <= {?begin} and {table.timeField} >= {?end} you could do:

{table.timeField} in {?begin} to {?end}

Would neaten things up a little.

L
0
 
mlmccConnect With a Mentor Commented:
If this is in the subreport then just change the selection formula to reflect using both fields.

mlmcc
0
 
ChoppAuthor Commented:
Thank you, Experts.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.