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

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

Crystal Reports 2008 (All Versions)

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.

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