Connecting to stored procedure

[D1000]

Does anyone have an example of how to use RDC to call a Crystal report that uses a stored procedure?

I am using SetLogonInfo (server), (database), (user), (password)

but cannot get anything back.

How do we specify the stored procedure name in this string? I tried different variations of the stored procedure name in the "database" field but nothing worked.

 

[dgillz]

I do not know how to express this using the RDC, but crystal out of the box does not see stored procedures. You must change the file options to report against an SP.

In version 8.5, click on file, options, database and make sure the stored procedures check box is checked.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[ShankarJ]

I use the API (CRPE32) to connect and use the following methods to connect/set location of the stored procedure/disconnect from a server:

PELogOnServer
PESetNthTableLocation
PELogOffServer

HTH