SAP Knowledge Base Article - Public

1688042 - How to show only numeric values in prompt window when the field contains alpha numeric values

Symptom

How to show only numeric values in prompt window when the field contains alpha numeric values

Environment

Crystal Reports 2008 (All Versions)

Resolution

  1. Open report in Designer select Database menu -> Database Expert
  2. Select the same Data Connection expand that connection
  3. Double click on Add Command it will open Query window
  4. Write the below formula in it
  5. SELECT  <Field_Name> FROM   <Table_Name> where (left(<Field_Name>,1) >= chr(48)) and (left<Field_Name> ,1) <= chr(57))
  6. Click on OK
  7. Remove the link between two tables in wizard
  8. Click on OK
  9. Now create a Parameter based on Add Command Field.

 

 

 

 

Keywords

Restrict LOV’s, Show numeric LOV, only numeric LOV, Crystal reports, alpha numeric values in LOV , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , How To

Product

Crystal Reports 2008 V1