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.
1-866-528-0577! help@albaspectrum.com
|
|
|
Erp Consulting: Microsoft Great Plains Partner Future Directions
In the Clinton era the status quo was simple: you serve your local clients and if you want to expand your business ? open offices in other business metros. Great Plains Software was granting generous margins on the software sales and stimulated local leading VARs/Partners/Resellers with so-called orphan leads ? customers who lapsed in payment annual enhance...(related: Software)
How To Choose A Fire Wall Software Program
In the real world a "fire wall" is a fireproof wall that is built to stop thespread of fire from one part of a building to others. In the Internet world afirewall has a similar purpose in that it stops the spread of harmful virusesand attacks from entering your home or office network.Because of the ever-increasing threats that are appearing on the Internet youno longer have to be in business to need the protection of a fire wall. Infact, every computer that is connected to the internet should have onei...(related: Software)
Adware And Spyware Blockers
The most important things you can do for your computer right now is to install adware and spyware blockers. Everyone is aware of computer viruses and run an anti-virus program to guard your c...(related: Software)
Microsoft Navision Integration With Microsoft Rms - Overview For It Specialist
Microsoft Business Solutions Navision serves both European and American megamarkets. It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment). Currently Navision is supported on two platforms - Navision native (C/SIDE) database and on Microsoft SQL Server. In this small article we would like to give you the clue on Navision integration with Microsoft Retail Management System - Micro...(related: Software)
Microsoft Great Plains Implementation In Russia ? Overview For Consultant
Microsoft Business Solutions Great Plains is very popular ERP platform in the USA, Canada (including French speaking Quebec/Montreal), U.K., Australia, New Zealand, South Africa, Middle East: OAE, Egypt, Arabia, Latin America. Former versions ? Great Plains Dynamics/eEnterprise was also popular in Europe: France, Poland, Russia. When Microsoft acquired Navision Software ? and handed it out to its subdivision: Microsoft Business Solutions ? we saw some geo-strategy changes. Navision, the leader on the European mid-market and successfully overcoming such localization barriers as language translation, adaptation to country-specific taxes and payroll taxes ? was chosen as preferred or the only recommended solution for emerging markets. In Russia we saw dramatic situation, when ...(related: Software)
New Sql Delta Version 3.1
COMMAND LINE FUNCTIONA powerful command line script processor has been introduced to SQL Delta 3.1. The script processor provides the user with a mechanism for controlling SQL Delta by remote control, allowing databases to be compared and changes scripted without any user intervention. The script language is standard XML and provides a variety of commands for configuring and controlling SQL Delta. In addition to the standard comparison and script functions the user can export reports in various formats including HTML format and then have those repo...(related: Software)
Looking For An Alternative To Microsoft Office? You Should Be!
Now is the time to look at an alternative to Microsoft Office.Are you locked into using Microsoft Word, Excel, and PowerPoint? Are you spending extra because you need a database, and Access does not come with the basic Office package?Well, the time has come to look at alternatives, or at least the one I¡¦ll discuss here in a few moments. Whether you are a writer on a tight budget, but need to send your submittals in Word format or an employee wanting to do work at home without either paying hundreds of dollars for Office or installing an illegal copy at home, there are inexpensive options.(Just as an aside, do NOT ever install or use unlicensed software from Microsoft or anyone else. It is simply not worth the headaches, including huge fines and possible jail time. And if you take a copy home from the office, you ma...(related: Software)
You Can Write Microsoft Office Program In About 60 Minutes
Microsoft Office program is a programming tool called Visual Basic for Applications (VBA) that comes with Microsoft Excel, Word, Outlook, Power Point, and Publisher. VBA can make your repeating jobs automatic. It also can customize Excel, Word and other Office procedures for your own needs. From Office version 2000, all the Office programs are equipped with VBA.Hand-On experience is the key to be a good programmer. Programming tutorials are the easier way to learn any computer programs including VBA. For example, a tutorial can show people how to use VBA to automate (make automatic) an Excel routine like updating the fonts and sizes for a range of cells, or automatically pops up a calendar for selecting a date. VBA can also be used as a tool to auto...(related: Software)
Windows Screensavers Explained
In this article you will find some background information about screensavers and their history. You will also learn how Windows screensavers differ from other programs and how you can use it to your own advantage. Also there are some tips for users owning laptops, notebooks or CD-burning devices.Have you ever asked yourself a question like "What is a screensaver actually?" I did. And now I will gladly share the results of my investigation. As you can see easily, splitting the word "screensaver" into two words will give us the phrase "screen saver". This isn't a rocket science and it's clear that the phrase suggests our subject somehow saving...(related: Software)
Reporting For Microsoft Great Plains/dynamics/eenterprise: Rw ? Reportwriter ? Tips For Developer
Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexteri...(related: Software)
Ibm Lotus Domino Or Microsoft Exchange?
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for many years between two main leaders ...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software