Report from stored SQL procedure

[dBjason]

I have an existing report which needs to be modified. Currently it's getting it's data from a stored procedure which takes about 8 minutes to execute.

I made a copy of the report, then a modified copy of the stored procedure (the proc is fairly complicated and needs to filter out additional information).

So now it's time to open the copied report and point it to get data from the new stored procedure. Problem is this: I'm getting an "unkown field" error (normal), but I have no data fields to pull out of the field explorer or formula workshop to drag onto the report! I can open "database fields" and see my stored procedure, but it won't expand when I click on the '+' next to it. Anyone have any ideas?

Please help!

 

[synapsevampire]

Try posting technical information:

Crystal version
Database/connectivity used

Try repointing the report to the new SP by select Database->Set database location and select your new SP.

The syntax may vary in your version of Crystal, thgus omitting the basics will often result in more posts.

-k

 

[dBjason]

Sorry about that...

Crystal Reports Professional - Version 9.2.2.634

Connectivity: OLE DB (ADO)
Db: SQL Server 8.00.194

I'll try your idea; hopefully it'll be more promising!

Thanks!