Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for small and midsize companies looking to expand their business operations without much interruption to its existing processes. Microsoft Navision enables businesses to alter as much or as little of its existing system, integrate add-ons and vertical segments of its development. It integrates every aspect of your organization, from customers to suppliers, from accounting to supply chain, increasing your productivity and competitive edge. Microsoft Navision has an open environment architecture making it fully customizable and easy to use and maintain. It can also be implemented rapidly so that there is only a minimal disruption to business operations.

Microsoft Navision was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment). Both European and North American markets have benefited from its use. Its launch in the global market will help organizations scale up their development and add value to their business.

One of the primary reporting tools used today is Crystal Reports. With its ability to call up information from SQL commands, using Crystal Reports adds extensive functionality in your reporting procedure. The following is an overview of Crystal Reports as it relates to Microsoft Navision:

C/SIDE

C/SIDE is Microsoft Navision's graphical integrated development environment that provides customization tools for developing customer specific solutions to be applied to a business process.

Inside Crystal Reports, use C/ODBC to create a connection to the database needed for report generation. Links are done inside Crystal Reports. However, this connection technique tends to be inflexible if you want to modify your database mapping or links inside the report. You may want to redo the database mapping of that report or use a Crystal Report query.

Microsoft SQL Server

Using Microsoft SQL Server in Microsoft Navision will help a great deal since SQL has the ability to integrate Navision to third-party products. SQL Server has a virtual table that you can access to minimize the complexity of looking at links in Crystal Reports itself. By referencing the view name in a Transact-SQL statement, a user can access this virtual table and retrieve the data for future selection to be applied into Crystal Reports. You also have the option of creating Stored Procedures to execute a number of Transact-SQL statements into a single command. Furthermore, SQL Query Analyzer can copy existing database objects and locate, view or work with these objects within the database.

Reports on Heterogeneous Database

If Microsoft Navision sits in an SQL Server, you have the ability to create a link from your database server to another third party database (Oracle, DB2, Unidata, Ingress, Sybase, Pervasive, Ctree, MS Access) for report creation in Crystal Reports. For example, if you are on a C/SIDE Database, create a link server to it with C/ODBC. You then create additional linked servers to your legacy database. These links will serve as your pool for creating one Crystal Report using a number of databases. Knowledge about OPENROWSET keyword in SQL Server is useful for this kind of execution.

Microsoft Navision is a powerful analytical tool for your business performance. Adding Crystal Reports to its functionalities will provide a more systematic way of measuring your organization's competence.

Need more information?

Contact us: 1-866-528-0577 help@albaspectrum.com

For customization work and advice, please contact Andrew Karasev, Alba Spectrum Chief Technology Officer. His works include development of applications with the use of Dexterity, SQL, C# .NET, Crystal Reports and Microsoft CRM SDK.

© Feb 2005 Alba Spectrum Technologies USA. All rights reserved.

Divine Rigor is the Technical Writer for Alba Spectrum Technologies USA ( http://www.albaspectrum.com ), a Great Plains, Microsoft CRM customization company. We are based in Chicago with locations in California, Arizona, Texas, Florida, Georgia, New York and contacts in international markets.

---

International Support - Microsoft Great Plains VAR/Partner Selection ? Overview for V.P. IT

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

ERP System of the Future: Database, Business Logic and Interface

We will base our prognosis on our Microsoft Business Solutions... Read More

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often,... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

Microsoft Business Solutions Great Plains has I'd say end user... Read More

Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant

Microsoft Great Plains has substantial mid-market share in the USA... Read More

Lotus Notes Domino and Web: Application Development ? Tips for Programmers

Beginning with Domino version R4 it has integration with the... Read More

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More

Know Linux

Linux essentials:It's free for download but you have to pay... Read More

Free Software - Powerful Alternatives to Budget-Busting Software

When you buy a computer, it most likely comes with... Read More

Why Java RDBMS?

It is a well known fact that Java as a... Read More

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Microsoft Great Plains BR: Bank Reconciliation

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Document Templates Give You The Perfect Framework For Your Documents

When it comes to running an office, the SOHO entrepreneur... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Groove Network. Are you in it?

If you are in a business that passes documents around... Read More

ERP Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses

Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More

Software: What Suits Me?

Almost all new and major brand of PCs come with... Read More

Healthcare Preventive Maintenance Software

Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More

Vlans

In order to implement VLANs in a network environment, you'll... Read More

ERP Software Financing: the Future? ? Overview for Company Owner

In our case ? we serve Microsoft Business Solutions ERP... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

The Dreaded Paper Label - Should it be Used?

While paper labeling CDs and DVDs may appear to be... Read More

Imagine if Everyone Working In Your Office Was In Synch?

Microsoft-Outlook is a pretty amazing program. So much more than... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More