Stored Procedures and Crystal Reports v9 Professional Edition

[kmarino]

I’ve been searching how to do stored procedures and I can’t find the information in the Help sections. Is it because I need a Developer’s Edition to create the stored procedures, which in turn can be then accessed by the Professional Edition?

 

[LV]

You create stored procedures in your database (not Crystal) and then use Crystal to report off it.

 

[kmarino]

I still don't understand something. If I can't create stored procedures with neither the Professional Edition nor the Developers Edition, then with what do I create the stored procedure with?

 

[LV]

You use a database tool to create a stored proc. For example, in SQL Server you can use either the Enterprise Manager or SQL Query Analyzer to create a procedure and then select it from Crystal as a data source for your report. Neither Developers, nor Professional version of Crystal Reports will allow you to create database stored procedures from within it.

 

[kmarino]

I got it. Thanks.