report can not locate the stored procedure

[sharmtow1]

I have a report which uses ole db connection for sql
log in to the server with userid and password stored procedure is there and i can run it.
log into the report and connect to the same server.
go to verify database, cant locate the sp
go to map to the sp and cant locate the sp.

i tried with integrated security as well and i have the same issue.

 

[hilfy]

In Crystal, before you open the report or try to create a new report, go to the File menu and select Options. On the Database tab, make sure that Stored Procedures is checked.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[sharmtow1]

yes that is checked off.