Stored Procedures

[obuspider]

Is there anyone who has been successful at running a stored procedure through ASP to bring up a Crystal Report? If so, could you provide me with a sample of the correct syntax. I'm wondering if that is my current problem.

 

[chelseatech]

The most likely cause of the problem is that the userid running the service on your web server doesn't have permsission to run the stored proc. Chekc your DB security for that stored proc.

Remember it is not you running the report any more. It is a service behind the scenes. What accounts are the Crystal services running under? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[obuspider]

chelseatech,

I think I understand you. I have actually been able to run the stored procedure and do a response.write on the page. It's when I have to put the recset in a session to run the Crystal Report that I have a problem. It seems to be failing at the following line:

session("oRpt&quot.ReadRecords