| Microsoft SQL Server is the leader for inexpensive | | | | create linked servers to Oracle, Ctree, Btrieve, MS |
| and middle size SQL solutions. Plus it is now capable to | | | | Access, Unidata, DB2 and other platforms. |
| serve large enterprise on Microsoft Windows platform. | | | | 3. Use Distributed Queries - in the case of SQL Server |
| Crystal Reports is the most flexible tool on the market | | | | - research the possibilities with OPENQUERY, |
| and it has market recognition. Multiple software | | | | OPENROWSET clauses to connect to non-SQL |
| vendors offer Crystal Reports as the main reporting | | | | Server linked servers. |
| tool: Microsoft, Best Software, Oracle to name a few. | | | | 4. Create Stored Procedures - when you need |
| Sometimes developers try to use Crystal directly to | | | | parameters to be transferred to the SQL statement - |
| pull data from multiple database platforms - we | | | | you need stored procedure. You need stored proc if |
| understand the need to give you additional tips to | | | | temp tables are required to do intermediate job in your |
| increase Crystal report flexibility. Also common case | | | | SQL query. |
| when Crystal report should pull data from multiple | | | | 5. Report Flexibility - when you have report based on |
| database platforms. Assuming that you are creating | | | | the SQL view or stored proc - if you need to modify |
| Crystal Reports on Windows platform - we | | | | the data query - you don't have to change the report - |
| recommend you to use Microsoft SQL Server as a | | | | you change your SQL view/ stored procedure. |
| database access tool. | | | | 6. Create SQL Query to probe the data - again - we |
| 1. Use Crystal when you have your query tuned - | | | | always recommend tuning your query and see that |
| regardless how good Crystal Reports is - it is reporting | | | | you are getting adequate results - in any case - |
| tool - not querying environment. Tune your query first | | | | Crystal Report is just a nice tool to show the results of |
| and be sure that you are pulling the right data. | | | | your query. |
| 2. Use SQL Server Linked Servers. Use professional | | | | Happy customizing, querying and designing! if you want |
| tool, such as Microsoft SQL Server, where you can | | | | us to do the job - give us a call 1-866-528-0577! |