Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

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.

akarasev@albaspectrum.com

1-866-528-0577! help@albaspectrum.com

In The News:


pen paper and inkwell


cat break through


Microsoft Great Plains Upgrade ? Things to Consider and FAQ

If you have Microsoft Great Plains and support it for... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT

Microsoft Business Solutions Great Plains was historically designed to serve... Read More

Free Program Removes Spyware not Detected by Premium Security Scan

What is Spyware?Spyware monitors your surfing habits and sends the... Read More

Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup ? overview

Microsoft Great Plains may be recommended for international freight forwarding... Read More

Is Your Family Protected?

When you think... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

Microsoft Great Plains Integrations ? Retail Management Sample

Microsoft Business Solutions is emerging as very attractive vendor for... Read More

Off The Record - Tips For Picking Recording Software

Need software to record your voice, streaming audio or musical... Read More

Behave, Word, Behave!

If you copy something from a Web site or elsewhere...... Read More

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More

Corporate ERP Selection: Microsoft Great Plains

In our opinion, traditional approach when you select ERP/MRP system... Read More

Keeping Track

One of the things we can be as certain of... Read More

Databases ? How We Love to Hate Them!

You've finally created databases that you can actually use to... Read More

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

Helping Newbies Understand Professional Software

The Windows registry is a huge database that ensures normal... Read More

Perfectly New Database Query Tool - Foxy SQL Pro Released

Are you a database professional? Do you work with a... Read More

SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

Ok... Where to start?Well, I guess I will start at... Read More

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

Microsoft CRM USA Nationwide Remote Support

Remember old good days when your company probably had Great... Read More

Groupware: Answers the 5 Questions of Document Collaboration

Every organization which creates collaborative documents, whether they are budgets,... Read More

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

When you first think about multicurrency ? you probably have... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... Read More

How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software

Fortunately one of the most common reasons cited for the... Read More

Oracle Development: JDeveloper 10G ? Java, J2EE, EJB, MVC, XML - Overview For Programmer

In 2004 Oracle, Inc. made its new step toward J2EE... Read More

Microsoft Great Plains - Typical Problems And Fixes ? Overview For IT Administrators

How to delete the user? This is the first problem... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

10 Things You Could be Using Photoshop For, But Probably Arent

Most people don't use Photoshop to its fullest capabilities. Here... Read More

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Free Microsoft Word Online Training Tutorial Resources

Microsoft Word is one of the most popular office applications... Read More

Protect Your Most Vital Business Asset with Security Software

Homeland security, airport security, Internet security â?" these days weâ??re... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More