Symptom
Need to select the most recent record prior to a user-entered target date.
11/15/08
11/30/08
Select only the most recent record prior to a user-entered target date (e.g., 12/1/08)? So in this case, only the record dated 11/30/08 would be selected for the report.
Reproducing the Issue
Resolution
1.Create a report with Xtreme sample database and insert Order table .
2. Create a parameter on the date field(Order date).
3.In the record selection write a condition like,
{Date field}<={?Date Parameter}
4.And also in the group selection formula write a condition like,
{Date field}=maximum ({Date field})
5.Try to refresh the report, select the parameter value from the list , which returns the recent value nearer to the date entered in the prompt.
Keywords
, KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To