I'm not sure but have you tried putting this in quotes when you enter the parameter?
>I am having trouble with a search using a parameter off a remote view.
>I created a table on the server and set my field as a char 12.Created a remote view to search by a field for shift Time on my report.
>the problem is when i run the report and my parameter box pops up i enter (exp: 6am to 2pm) i get a error converting varchar to 6am to 2pm to a column of data type int. i have checked the table nd have checked both views and they are all set up as char 12.I dont understand what is the problem. any help is appreciated.
>
>Thanks Linda
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe