error 0x800a0bcd ??

[antiskeptic]

Don't know why I'm getting this error...very bizarre!

I'm using CR 9.0 and I have a very simple report that works just fine until I go to put the parameters into effect in the Record selection

My record selection statement looks like this:

{rsp_RMS_ReconciliationReport;1.entry_date} >= {?From Date}
and {rsp_RMS_ReconciliationReport;1.entry_date} <= {?To Date}

and when I run the report with that statement in the record selection, it gives me a "Failed to Open Rowset" and then this "0x800a0bcd" error.
But when I take it out, it runs no problem.

I even tried just running this in the Record Selection:

{rsp_RMS_ReconciliationReport;1.entry_date} >= {?From Date}

and then :

{rsp_RMS_ReconciliationReport;1.entry_date} >= date(2004,08,01)

but it still gives the same problem.

The field in question :({rsp_RMS_ReconciliationReport;1.entry_date})
is a datetime field, and the parameters are set up with a datetime field type. So I'm really baffled as to what could be wrong. Anybody got any ideas??

Thanks in advance for any help you can provide
~Antiskeptic

 

[synapsevampire]

Post the database type and connectivity the report uses.

When you receive a data related error, it's generally something to do with the database or driver.

I would try changing the connectivity, if possible. for example people often use the Oracle ODBC driver instead of the CR supplied Oracle ODBC driver (in fact the native driver is better still), which causes lots of errors.

Also right click the {rsp_RMS_ReconciliationReport;1.entry_date} field and select browse data to make sure that Crystal believes it to be a datetime.

You might also make sure that you have the latest service pack installed:

http://support.businessobjects.com/fix/hot/si75/default.asp

-k