Crystal Reports SQL Server Optimal Solution | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Crystal Reports SQL Server Optimal Solution

I’m looking for some information about the best way to connect a Crystal Report to a SQL Server 2000 db. I am being required to provide information on performance issues in order to decide on the process that will be implemented in an intranet environment. The 2 schools of thought are: 1. Use stored procedures that will take as parameters the values that the results will be filtered by. No dynamic SQL, temporary tables or cursors will be used. 2. Use Crystal’s built in filtering and connect directly to a view which will contain all of the fields that are required by the report. If anyone has any performance testing data or can provide links to information regarding this issue please post here. Thanks in advance.
Kindly do not duplicate posts, refer to thread.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.