Database Objects - which to use for Crystal reports?

[youngcougar]

Can anyone tell me the benefits of using a stored proc vs a table vs a view. What are the benefits of using one over the other and what are the drawbacks of using one over the other?

 

[synapsevampire]

Somewhat dependson the database, but here's some generic info:

SP Pros: Fastest, centralizes the code, allows for more advanced concepts

SP Cons: Requires datbase privileges, can only pass a single parameter value at a time

View pros: Centralizes code, allows for multiple parameter values, promotes reusablility

View cons: Requires database privileges

Table pros: Non SQL people can create robust data sources, allows for multiple parameters.

Table cons: If a table changes in the underlying report, the report must be opened and verified.

You didn't bother to post which version of crystal you intend to use.

There's another option in later versions, CR9 and up, called a Commadn Object, in which you can paste SQL in, it's listed as Add Command below your datasource.

-k