Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 04, 2008 at 04:17 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded