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.
Beecher limo rentals ..IntroductionSurprised, by the title? well, this is a tour of... Read More
This is intermediate level SQL scripting article for DB Administrator,... Read More
CD and DVD replication is a process that works by... Read More
While paper labeling CDs and DVDs may appear to be... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
When it comes to screenplay software each screenwriter needs to... Read More
Words we choose to describe things and phenomena often show... Read More
Do you want to get quality software at a reasonable... Read More
The software giants don't do everything and don't always produce... Read More
Stealing company information used to be the specialty of spies... Read More
Ok... Where to start?Well, I guess I will start at... Read More
What is installation in the language of technology? Installation... Read More
As seeing large number of implementations ? in our case... Read More
What is a Web Database?A web database is a database... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Did you ever want to erase everything on your computer?... Read More
Using professional icons in your application or website can bring... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Manufacturing in the USA is far away down from mid... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Bridgeview limo Chicago ..The term "document management" and "paperless office" is the subject... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
Are you one of those people that keeps track of... Read More
A wiki is an editable text-based website. But you don't... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
When Windows fails to boot it is normally caused by... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Just the thought of a duel-boot scares many people away,... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
To all web designers out there, this article is for... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
In linux, one of great commands for finding out information... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
Beginning with Domino version R4 it has integration with the... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Software |