I can't use the Oracle as a back-end. I have to use Access 2000.
What is interesting: for the test sake I've created in the Access 97 database same table and same stored procedure I have in Access 2000 database and created new ODBC connection to this "Test" database for the Crystal Report with same set of fields and everything works OK on the WEB. Unfortunately I have to use Access 2000 database. Like I mentioned before I've created about 20 similar and more complicated reports with ODBC connection to Access 97 database and all of them work perfect on the WEB. I do not know if is some difference to display reports on the WEB for Access 97 and Access 2000?
I've found the description of my error("Error Occurred Reading Records: Not supported. Details: Cannot obtain error message from server.") on Crystal Decisions web site(http://support.crystaldecisions.com/...s/c2012700.asp
) but it does not applies to my case, because my report getting correct parameter value (I can see this value on the WEB if I live just one field in the report, containing this parameter value). But if I try to add any additional fields, I am getting the error again.
I am completely frustrated????!!!!