SAP Knowledge Base Article - Public

1303970 - Most recent record prior to a user-entered target date.

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

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2