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.
Lincoln Stretch rentals Alsip ..Looks like Microsoft Great Plains becomes more... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
TikiWiki is open source software - it is written in... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
Beginning with Domino version R4 it has integration with the... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
I have always regretted how Microsoft price gouges and rips... Read More
In today's business world it's all but impossible to escape... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
All of us know that Microsoft bought former Great Plains... Read More
Usually, the easiest way to tell you have spyware is... Read More
Should one use Windows Update?This topic has good and valid... Read More
Are you lost in the mess of documents that get... Read More
Microsoft CRM is new player on the CRM software... Read More
This article will not attempt to advocate the use of... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
We'll give you non formal view, based on our consulting... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
It could just be me, but my experiences with document... Read More
Western Springs shuttle limo ..There are two major WYSIWYG(What You See Is What You... Read More
Is Photoshop CS2 worth the upgrade? You bet it is!... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
Before being able to choose a secure Internet communication system,... Read More
This article is the fourth of a series of articles... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
It is possible that if one avoided all sources of... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
When you need a phone number, you do a quick... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
Fortunately one of the most common reasons cited for the... Read More
So, why should you use any O/R mapping tool? I... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
If you feel intimidated when someone tries to teach you... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
Software |