Stored Procedure from Crystal Report

[lesleycampbell]

I know you can create a crystal report from a stored procedure but can you start with a crystal report and create a stored procedure from there?

 

[pmax9999]

No. An SP must be created within the database.

A Command may be an alternative.

Pete

 

[briangriffin]

I'm not sure if this is what you're looking for, but it's an interesting idea - create a report, the formatting won't matter, and then under the database menu select Show SQL Query.

This could be the bulk of the stored procedure - just paste it into a SQL editor and then add 'create procedure your_spName as' to the first line.

Grouping may or may not work depending on the report, etc., but for someone who isn't skilled at writing SQL this could be a good way to see how it comes together.

I don't see any real benefit to then base the report on the sp, but perhaps if you have multiple reports that use the same dataset. As Pete said, commands would probably work better - especially if you have to depend on a DBA to create the sp's.

Anyway, it's a thought.