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.
![]() |
|
![]() |
|
![]() |
|
![]() |
Running Applications in Compatibility Mode With Windows XP, you can... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
The Windows registry is a huge database that ensures normal... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
If you have Microsoft Great Plains and support it for... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
In the early days of the personal computer, we're talking... Read More
Pirated software is on the increase and now accounts for... Read More
With many manufacturing shops heading over seas in favor of... Read More
We were recently faced with a decision: either to let... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
In order to implement VLANs in a network environment, you'll... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Whether you are an experienced web programmer or a complete... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
In this small article we will show you the possible... Read More
If you have been using the Internet for any amount... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
When you need a phone number, you do a quick... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
This article is the third of a series of articles... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
When you first think about multicurrency ? you probably have... Read More
Fleet Maintenance Management is a critical position in any company... Read More
Whether you are a small consultancy firm, a medium sized... Read More
I like my software simple. If it's too complex or... Read More
Anti-virus software is used to find, remove or fix files... Read More
Google Inc. has launched a new software package that allows... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
One of the things we can be as certain of... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
There is many things more frustrating than surfing a website... Read More
The software giants don't do everything and don't always produce... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
For a windows user like me, just can watch with... Read More
C++ Function templates are those functions which can handle different... Read More
Do you want to get quality software at a reasonable... Read More
If you feel intimidated when someone tries to teach you... Read More
Have you ever noticed that when you look at your... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
If you have Microsoft Great Plains and support it for... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
While Adobe is the most known maker of PDF tools,... Read More
Just when you thought you were Web savvy, one more... Read More
In this small article we will be looking at the... Read More
Itâ??s easy to understand why you might be drawn to... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
Software |