How do you run a stored procedure in Crystal Reports

[rydexdba]

I'm trying to run a MSSQL7 stored procedure just before a report is opened. Can anybody offer a solution on how this can be accomplished? Ideally, the user would open the report, the stored procedure would run and the data would then be reported. Can Crystal Reports do this out-of-the box? Any help will be greatly appreciated. Thanks.

 

[Jerrycurl]

You can base a report off a stored procedure. Just select the sproc where you would normally select a table. You might have to set an option somewhere if it only lists tables by default.

 

[paulosinuk]

The option for including stored procedures within your report is included under the file menu, in options on the database tab.

Just click to include store procedures and then you will be able to add procedures as JerryCurl suggests.

 

[krist]

Hi,
This is just additional information to above two replies.
Make sure your stored procedure ends with :
Select [field list] From ...
Then you should work with your SP as if you did with tables/views.

Krist