SAP Knowledge Base Article - Public

1592615 - How to search Dynamic LOV

Symptom

How to search Dynamic LOV

Environment

Crystal Reports 2008

Resolution

It's only possible if we create a field in the Database table to store Alphabet of the First name of Name,

OR

Else we can create a view which is a combination of Table and additional column.

Follow the below steps:

 

  1. Login to Crystal reports Designer.
  2. Open the report
  3. Create a Dynamic Parameter with Cascading Prompts
  4. 1st Prompt must be on the Alphabetic field newly created
  5. 2nd Prompt must be on the Name field
  6. Run the report

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports Server 2008 V1