Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using Stored Procedures

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?

Former Member
replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question