Most recent date 1

[dkellam]

I am trying to filter my report with the most recent effective date. When I use the formula under select expert in CRXI, {SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE} = maximum {SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE}, I get an error message stating "The remaining text does not appear to be a part of the formula" The remaining text highlighted is the 2nd {SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE}. Am I approaching this correctly or should I be filtering somewhere else?

 

[synapsevampire]

You need parentheticals:

{SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE} = maximum( {SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE})

I notice that you had a comma, did you mean for each group? If so, use Report->Selection Formula-Group:

{SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE} = maximum( {SURCHARGE_FWA_RESULTS.EFFECTIVE_DATE}, {table.group})

-k

 

[dkellam]

I am fairly new to Crystal reports, table.group references what the report is currently group by?

 

[synapsevampire]

If in fact you want the max for each group, yes.

I asked if you needed it for each group and you ignored the question.

-k

 

[dkellam]

Thank you so much! I have been working on this off and on for a week! Your suggestion worked perfectly. Thanks again!