SAP Knowledge Base Article - Public

1385013 - How to sort a Dynamic Parameter List of Values (LOV) in original order, in Crystal Reports?

Symptom

  • List of Values (LOV) is sorted in original order.
  • In Crystal Reports, how to change a Dynamic Parameter List of Values (LOV), to sort order to original order?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports, open an existing report or create a new report.
         
  2. Create a dynamic parameter
    • In Crystal Reports, in the Field Explorer window, right click on Parameter Fields, and select New…
    • In the Create New Parameter window, select Dynamic in the List of Values drop-down list
    • Under Value, select a database field you will like to create a List of Value for
           
  3. Select the parameter List of Values sort
    • Under Value Options, for the Sort Order option, we have the following  choice:
      • Ascending by Value
      • Descending by Value
      • Ascending by Description
      • Descending by Description

Notice there is no option to set the order to: Original order

Cause

  • By design, a Dynamic Parameter List of Values (LOV) can be sorted in ascending and descending order by the value or the description.

Resolution

  • An enhancement has been created to request the addition of sorting a Crystal Reports Dynamic Parameter List of Values (LOV) in original order.
        
  • Note: An enhancement request doesn’t guarantee the requested feature will be added in a future product version, but it is an acknowledgment it has been added in the Enhancement Request list for the specific product.

Keywords

Crystal Reports, CR, List of Values, LOV, sort, original order , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Product Enhancement

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020