Microsoft SQL Server is the leader for inexpensive and middle size SQL solutions. Plus it is now capable to serve large enterprise on Microsoft Windows platform. Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few.
Sometimes developers try to use Crystal directly to pull data from multiple database platforms - we understand the need to give you additional tips to increase Crystal report flexibility. Also common case when Crystal report should pull data from multiple database platforms. Assuming that you are creating Crystal Reports on Windows platform - we recommend you to use Microsoft SQL Server as a database access tool.
1. 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.
2. 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.
3. Use Distributed Queries ? in the case of SQL Server - research the possibilities with OPENQUERY, OPENROWSET clauses to connect to non-SQL Server linked servers.
4. Create Stored Procedures - when you need parameters to be transferred to the SQL statement - you need stored procedure. You need stored proc if temp tables are required to do intermediate job in your SQL query.
5. Report Flexibility ? when you have report based on the SQL view or stored proc - if you need to modify the data query - you don't have to change the report - you change your SQL view/ stored procedure.
6. Create SQL Query to probe the data ? again - we always recommend tuning your query and see that you are getting adequate results ? in any case ? Crystal Report is just a nice tool to show the results of your query.
Happy customizing, querying and designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
About The Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle, Canada, UK, Australia and having locations in multiple states and internationally (help@albaspectrum.com), he is Great Plains Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
shuttle from Midway Glen Ellyn ..Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
In the previous ISDN article, we looked at how and... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
The research in the field of Natural Language Processing usually... Read More
The vast majority of us will have, at some point,... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
What is Software?Software is a set of instruction written to... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
Although statistics often is blamed for various deadly sins --... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Not all of us have the luxury of working both... Read More
shuttle from O'Hare North Chicago ..Icons are used everywhere; right from software applications, to internet... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
The Windows registry is a huge database that ensures normal... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
As seeing large number of implementations ? in our case... Read More
Think of this, first we had the HAM Radio, then... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
You might think you don't need a firewall... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
When Great Plains Software was designing and developing Great Plains... Read More
Finding the best spyware removers to detect and remove spyware... Read More
The objective for Zandi Digital is to make available clever... Read More
This article illustrates the best practices to improve the performance... Read More
I have always regretted how Microsoft price gouges and rips... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
We all take the computer for granted. I mean, all... Read More
Not every software testing project can or should be automated.... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Software |