Using Stored Procedures

[Former Member]

I need to use multiple data sources in one report, 3 different databases - one of the databases insist on me using a stored procedure instead of directly accessing the data. Is it possible to combine a stored procedure in the same way I would a table?

[alex_styles · Accepted solution]

Hello Lee,

It is possible to use stored procedure and tables in the same report as long as they are linked by common fields to ensure the data returned is relational. Linking a stored procedure to a table will be the same process as linking tables together.

The main drawback to using multiple data sources within Crystal Reports is that the data will be retrieved for each database separately and then the linking will be performed within Crystal Reports which will affect the performance of the report.