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:
- Login to Crystal reports Designer.
- Open the report
- Create a Dynamic Parameter with Cascading Prompts
- 1st Prompt must be on the Alphabetic field newly created
- 2nd Prompt must be on the Name field
- Run the report
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports Server 2008 V1