Problem with query and parameters

Goodmorning
I want to ask something. I want to create a crystal report witch will run with a database in sql express 2005.
so i create to parameter fields for the user to put values, like this:
131;Id@EDT@_Reception Code (number) 131 is my table
131;Id@EDT@_Έως Κωδικό Κίνησης (number) 131 is my table

So i write a simple query like this on selection group.


{Emp131.Id} >= {?131;Id@EDT@_Reception Code} and
{Emp131.Id} <= {?131;Id@EDT@_Until Reception Code}

So my problem is that my field on database Id is a number, so when i put this code i dont get a box to insert value. If i change the value in parameters and put it string i can insert text but it brings me an error on query because it says need number. I used " or ' but its wrong and doesnt work. how i can solve that

Say Crystal Reports version

If the field you want to filter is numeric data type then the parameters should be numeric also.

Check your parameters definition, they should be prompted

goodmorning.
Yes i got this but how i will write the syntax with numberic. I mean the styntax with query. Also my crystal reports is version 11

Quote:

---

So my problem is that my field on database Id is a number, so when i put this code i dont get a box to insert value. If i change the value in parameters and put it string i can insert text but it brings me an error on query because it says need number. I used " or ' but its wrong and doesnt work. how i can solve that

---

Your problem, as I understand is in the parameter definition and not in the filter

Post or attach a screenshot from your parameters definition

Oh ok how i can post pictures to show you exactly. My field in database (id) is integer, my parameter is integer too but when i run it the user cant put a value there is no box

To get a screenshot there must be a key in your keyboard
The picture goes to the clipboard, From there you can copy everywhere (Ctrl-V)
Also there's a button in the toolbar in the reply section taht says "InsertImage"