Crystal is a reporting tool
Use Crystal when you have your query tuned, regardless how good crystal reports is, it is reporting tool not querying environment. Tune your query first and be sure that you are pulling the right data. Use SQL Server Linked Servers. Use professional tool, such as Microsoft SQL Server, where you can create linked servers to Oracle, Ctree, Btrieve, MS Access, Unidata, DB2 and other platforms. Use Distributed Queries. Create Stored Procedures when you need parameters to be transferred to the SQL statement as you need stored procedure. You need stored proc if temp tables are required to do intermediate job in your SQL query.
Comments are closed.