CE9 and Stored Procedures

[Hypermommy]

I have a report that uses a stored procedure in a SQL Server database as it's data source. The report was developed in CR9.0. Our CE version is 9.something. I went into the CMC and added the report. I had some problems with logging on to the databse, but those went away when I duplicated the ODBC connection that was in my development environment... hey, at least some progress was made ;-) But now when I try to preview the report I get an error stating

"The table could not be found. File 57035d46a2e570.rpt."
Unable to retrieve Object.
"The table could not be found. File 57035d46a2e570.rpt."


Any ideas what's causing this? I've tried searching on Crystal's site but can't find anything that seems to help.

Thanks.

-= Hypermommy =-

 

[KingfisherINC]

Double check your table prefixes on the database tab in CMC - I assume you are pointing to a different database?
You may need to set custom table settings. (make sure you include the "." at the end of the table prefix).

If you can, load CR9 on to the same server that you run your CE Page / Job services and run the report from there to see CR error messages.

Kingfisher

 

[Hypermommy]

Thank you so much for your help! This was driving me crazy. Well, it turned out there was a problem with the permissions in the database. When I worked on my desktop everything worked fine because I am a trusted user of the database. However, when I moved over to ePortfolio and it was iisaspuser that was hitting the databse, he's not a trusted user. Turns out we went into the database and gave him execute permissions to all the stored procedures and life was grand.

Thanks again for the assist. It got me to thinking and got my problem figured out!

-= Hypermommy =-