Let us give you - developer some hints in the report creation.

• C/SIDE database - use C/ODBC to create the connection for your Crystal Report. You have to make all the links inside the report. The drawback of this approach - report becomes inflexible if you would like to change database mapping (re-link from work to historical tables for example) - it is probably easier to redo report from scratch. You can use something like Crystal Query - which is still very restricted in its functionality.
• Microsoft SQL Server - you are better positioned to create Crystal Reports. You can deploy MS SQL Server views. View will allow you to unionize work and historical info, pull the data from several databases to name a few nice features. Also the option to use stored procedures (or stored procs) enables you to create temp tables for data manipulation before sending the final result set. You can also have parameters (name of the company/database, dates restrictions) - this gives you additional advantage versus SQL View
• Reports on geterogeneus databases - imagine creation of Linked Server in your Microsoft SQL Server Enterprise Manager. If Navision sits in MS SQL - you create linked server to the third party database (Oracle, DB2, Unidata, Ingress, Sybase, Pervasive, Ctree, MS Access). If you are on C/SIDE DB - you create linked server to it via C/ODBC, then you create additional linked servers to your legacy DBs. Now you are ready to create geterogeneus SQL View to link all your databases and have the data shown in one Crystal Report. You should probably familiarize yourself with OPENROWSET statement in Transaction SQL

Good luck in reports design and if you have issues or concerns - we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Robert Horowitz is Certified Navision Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies - USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com).

You can contact Robert: welcome@albaspectrum.com

RELATED ARTICLES The Dirt on Screensavers Remember back in the days where screensavers were the coolest thing at the office? You could stare at your co-worker's "fish in the ocean" screensaver at the cubicle next door for hours and actually have a full afternoon of conversation about that one screensaver.Well, screensavers are still "in", but not as "in" as they used to be. Microsoft Great Plains Accounting/ERP Implementation - Finance Industry Customization Example Microsoft Business Solutions Great Plains is very generic accounting application out of the box and has multiple modules to address specific horizontal or vertical market requirements. At the same time Great Plains, now being moved on MS SQL Server platform allows you to deploy standard tools to customize and fit to these requirements, when you don't need rich custom functionality, just few touches. Protect Your Computer...and Your Business! We all take the computer for granted. I mean, all we have to do is switch it on and it's ready to go. OEComplete - A Personal Information Manager OEComplete is a utility for managing the personal information of the user. It is designed to be flexible and affordable even for the home user. HelpDesk & Asset Management Software - Choosing The Right One If you are to buy a HelpDesk & Asset Management software, see the following checklist before you decide on one.Comprehensive Help Desk FunctionalityA good Help Desk product can dramatically rise the productivity of the Help Desk Personnel (which in turn will rise the organisation's productivity as a whole). 25 Things Mapping Software Can Do For You 1. With mapping software you can create a report that tracks your retirement plan for you. Microsoft CRM for Large Corporation - Security Microsoft Business Solutions CRM proved to be reliable solution in the whole spectrum of industries and market niches: transportation & logistics, education, recruiting & placement, supply chain management, pharmaceutical, oil & gas, aerospace & defense, manufacturing, wholesale & retail. When corporation is looking into CRM application to choose from - one of the fist questions is security. Lotus Notes Domino and Web: Application Development - Tips for Programmers Beginning with Domino version R4 it has integration with the Web, and the server itself becomes a HTTP-server. The next releases of Domino Web-server add new functionality (for example servlet managers, supported JVM versions upgrade, etc). eConnect: eCommerce Development for Microsoft Great Plains Microsoft Business Solutions Great Plains has several options to enable web ordering. Traditionally Great Plains Dynamics/eEnterprise had eOrder - this is ASP pages based ordering application, enabling you to place or retrieve your Sales Order Processing (SOP) Sales Orders over the web. Microsoft Great Plains GL: General Ledger - Overview For Consultant Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features. Think Of This Think of this, first we had the HAM Radio, then the bbs and now the Internet. Linux and the various other x systems are the next evolutionary step toward enhancing Global 2-way communications. Microsoft Great Plains Customization: Project Organization - International Business Example Microsoft Business Solutions Great Plains fits to majority of horizontal niches and clientele in the USA, Canada, Mexico, Latin America, U.K. Microsoft Business Solutions VAR/Partner Selection - Overview for IT Director/Manager/Controller Microsoft Great Plains and Microsoft CRM become more and more popular, partly because of Microsoft muscles behind them. Now Great Plains is targeted to the whole spectrum of horizontal and vertical market clientele. Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing Microsoft Great Plains is now targeting large and midsize businesses and being matured ERP has advanced, but still very simple in use modules and features: Lockbox Processing for Accounts Receivables, Customer/Vendor Consolidation, Multicurrency etc. We'll try to cover these features in the series of small articles to help decision maker and end user understand the feature and how does it work to make a decision to purchase additional nice modules. History of Java The java programming language is becoming more and more popular each day. It is the language without which one cannot even hope to a land a job thesedays. Create A Flash Presentation For Free With Open Office The intentions of this short tutorial are not to teach you how to use Open Office, but rather to show you a quick and dirty way to create presentations and tutorials that can be exported as a Macromedai Flash file.What is Open Office? It is a free, open source, cross platform office suite that has a lot of the same features as popular commercial suites. Brief Notes About Mainframe Software Pricing We don't think about mainframe software pricing anymore, we just go out buy a server hardware/software "package" from Microsoft, but did you ever tink about how they got their ideas for the usage licence, it all started with IBM and the introduction of Cmos logic technology in 1994, simnce then mainframe software pricing has steadily became disproportion to the comparatively minute hardware costs, which has been stated to be "typically four to five times the hardware cost" in terms of the system budget.This trend has given rise to growing concerns over the direct results of current software pricing techniques which are leading to problems such as making smaller applications costly to operate on large systems. It's Back!! WordPerfect's Amazing Comeback Have you noticed WordPerfect is gearing up for a comeback in a big way? And fortunately, they are succeeding. If you're like me, an ole' diehard WordPerfect 5 user, this is music to my ears. Four Desktop Tools To Drastically Increase Your Productivity Sticky Noteshttp://www.deprice. Adware, What Is It? Adware is a type of Spyware program that displays some kind of banner advertising as you're surfing the Internet. Most of the time, you will pick these programs up if you download other programs such as freeware, shareware, and file-sharing programs.