Date range Parameter on maximum date 1

[YANKRAY]

Using Crystal 9.0

I have grouped by EMP_NO and created a group selection formula.. {TQ_EMP_TRAINING.EXPIRY_DATE} = maximum ({TQ_EMP_TRAINING.EXPIRY_DATE},{TQ_EMP_TRAINING.EMP_NO})

The gives me the date an employee is due training for a particular type training.

I am trying to allow a date range to be selected so the user can select employees due training for a specific time period.

I have tried to create a date parameter and apply it to TQ_EMP_TRAINING.EXPIRY_DATE but the result contains dates that I eliminiated with the group selection. How do I create a user parameter that deals only with the maximum date?

 

[lbass]

Change your group selection formula to:

{TQ_EMP_TRAINING.EXPIRY_DATE} = maximum ({TQ_EMP_TRAINING.EXPIRY_DATE},{TQ_EMP_TRAINING.EMP_NO}) and
{TQ_EMP_TRAINING.EXPIRY_DATE} in {?daterange}

...where {?daterange} is your date range parameter.

-LB

 

[YANKRAY]

Perfect! Thanks LB