value is not valid error

[Gruung]

i have got a report which is based on a query, when you run the query it asks you to input the class value whihc is 12 or 13. If you jsut run the query it works fine, no problems at all. If you run the report and you enter 12 it says that the value is not valid. What I dont get is that when you enter 12 when you jsut run the query you dont get an error. If you enter 13 when running the report, it works fine and the report is displayed. I have spent ages trying everything i can think of, creating new reports and everything but it happens every time. Any ideas?

thanks and happy new year

 

[GumbyD]

Are you using the Class Value field in any expressions on the report itself? Do you have the parameter defined in the query with a specific datatype?

GumbyD

 

[Gruung]

I am only using it in a dcount expression, while messing around more i have found that if you load it via the switchboard it works fine, but if you load it on hte main reports page it gives the error which is strange.