background: All of the reports we have that work are not using stored procedures. There are about 3 that are using stored procedures...this is something I was given to dive into and seeing the system for the first time (using ASP with Crystal) is new to me. I have experience with Crystal but not on the VB/ASP side of things.
So why the person used sp for these reports I don't know but all I know is that we have an ASP page for each report. IN that page, it allows the users to select parameters via an HTML form. Onsubmit they are then redirected to ReportEngine.asp which takes the parameters and then I guess fires up the report using the ActiveX control. All other reports use their own asp page...and the ones that are not using stored procedures run fine.
The error I get after I click submit on the asp page for the specific report shows this error with blank results in the report after I click ok on the 1 error prompts that come up.
Error prompt 1: CRAXDRT error occured on server -2147192179 : Error detected by database dll
I have no clue where to start....this part of Crystal is foreign to me. I tested the stored procedure and it does bring back field results.