Crystal Reports - ODBC error: Invalid Parameter number

I am connecting to two backends. One backend is a ODBC data source and the second is a Access database on my local PC. When I run the report I get the error Invalid Parameter number. The only parameter fields I have are dates. In my odbc I am connecting to a date\time field and in the Access database the data shows as date only. I do not know if this is the cause or not?

I am using a Subreport (connects to Access database) and the ODBC connects on the Main report...

Any help is greatly appreciated!!!

Johnny

I copied your post to this new forum. You are the first post :)

and it will never be answered since noone will come here :(

Quote:

---

Originally posted by glyptar
and it will never be answered since noone will come here :(

---

You just proved yourself wrong, but that's no surprise.

What form is your ODBC data source? Is it a table or a query? If it's a query, perhaps it's expecting one or more parameters to be passed to it.

Just a thought. I don't think the date/time fields are causing the problem.

Try creating a new report using the ODBC data source only and see if you get the same errors. This may help narrow down the problem area.

Same here don't think the error is caused by the report.

Try to put the query in the query designer, bet you'll get the same error.

Are you just running the report through crystal or are you calling the report though another application ?

I am running the report from Crystal reports itself..

Have Tried running the main report wihtout the subreport ? Do that so if it works you can narrow it down to where the problem might be. Try and use the same field type parameter as to the field in your database. There could be lots of problems like your linking etc.

Sometimes Crystal doesn't allow to set up a parameter with a date type field in your selection expert. What you need to do then is the following

1. Create a parameter using the Date/Time type.
2. Select the parameter in your selection expert.
3. Now go back and edit the parameter and change the type to just Date.


Hope this helps.

here is the help for passing date parameter to crystal reports:

http://vb.net-informations.com/cryst...meter_date.htm

bonave.

You really started from the beginning !