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.
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 (www.albaspectrum.com), he is Great Plains Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
1-866-528-0577! help@albaspectrum.com
If you have Microsoft Great Plains and support it for... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
When you think... Read More
We live in a post-industrial age where information is the... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
Need software to record your voice, streaming audio or musical... Read More
If you copy something from a Web site or elsewhere...... Read More
We'll give you non formal view, based on our consulting... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
One of the things we can be as certain of... Read More
You've finally created databases that you can actually use to... Read More
If you look back to the history, you will see... Read More
The Windows registry is a huge database that ensures normal... Read More
Are you a database professional? Do you work with a... Read More
Ok... Where to start?Well, I guess I will start at... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Remember old good days when your company probably had Great... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
Enabling Chinese input is quick and easy, there are only... Read More
When you first think about multicurrency ? you probably have... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Fortunately one of the most common reasons cited for the... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
How to delete the user? This is the first problem... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Microsoft Word is one of the most popular office applications... Read More
Homeland security, airport security, Internet security â?" these days weâ??re... Read More
Following tips help you to learn a software in lesser... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
This is the tutorial where we really get into programming.... Read More
You've finally created databases that you can actually use to... Read More
With many manufacturing shops heading over seas in favor of... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
If you have Microsoft Great Plains and support it... Read More
While I was preparing some personal background information for a... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
When you first think about multicurrency ? you probably have... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
Pirated software is on the increase and now accounts for... Read More
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
Scrapbooks are very popular these days. I think that almost... Read More
The adware and spyware definitions list is very long. But... Read More
Google Inc. has launched a new software package that allows... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Software development is a risky business.Many software developers are barely... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
This article is the fourth of a series of articles... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Looking at all the ads which promise to get rid... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
At the end of XX century, in the late 1990th... Read More
Itâ??s easy to understand why you might be drawn to... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Sales are all about leverage, because there is only so... Read More
Software |