CRYSTAL REPORTS and STORED PROCEDURES

[PatBradley]

Can a crystal report be run from a stored procedure?

 

[morriskc]

yes, you do need to make sure that you have stored procs selected under options database

 

[iwm]

How to run a Crystal Report from a stored procedure:
1) Select Database from the menu bar
2) Select Add Database to Report from the Database menu
3) Select the appropriate Data Source
4) Select the desired stored procedure from the Data Source (if stored procedures are available skip #s 5 - 8.)

5) If you don't see any stored procedures choose the options button.
6) Check the stored procedures box
7) Choose ok
8) If you don't see the changes - close and re-open the application.
9) Go back to # 4

10) Choose the Add button

I hope this helps.

IWM

 

[JudyL]

What happens if you change the name of the stored procedure?

 

[morriskc]

If you change the name of the stored proc, you will have to do a set location to point the report to the renamed proc.

Why is the stored proc name changing?