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.
All your software is stored on a hard-drive. But how... Read More
Fortunately one of the most common reasons cited for the... Read More
Are you a database professional? Do you work with a... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
When Great Plains Software was designing and developing Great Plains... Read More
It won't matter how effective your WinRunner Team is if... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
Do you want to get quality software at a reasonable... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
If there still are few unprotected computers left, I haven't... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
In the early days of the personal computer, we're talking... Read More
Sales are all about leverage, because there is only so... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
The vast majority of us will have, at some point,... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
With any good luck and a good amount of hard... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Anti-virus software is used to find, remove or fix files... Read More
We don't think about mainframe software pricing anymore, we just... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
The most important benefit of XML is its simplicity. Though... Read More
Not every software testing project can or should be automated.... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
1. What determines the software price? Is it Per Seat... Read More
One day, you suddenly realize that your computer started to... Read More
Research bears that less than 70 percent of development projects... Read More
I have yet to see a business that, sometimes in... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
If you've been using MySQL database to store your important... Read More
The title of "software engineer" has got to be among... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
Using professional icons in your application or website can bring... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
How do you run a program on a remote server... Read More
If you company is small or mid-size special products or... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
As seeing large number of implementations ? in our case... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
The adware and spyware definitions list is very long. But... Read More
There are certain pluses and minuses in both cases and... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
In part III of this ISDN primer, we learned that... Read More
Not all of us have the luxury of working both... Read More
If you copy something from a Web site or elsewhere...... Read More
We live in a post-industrial age where information is the... Read More
People often ask me: What image file formats will Photoshop... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Software |