| Microsoft Business Solutions - Navision is an | | | | redo the database mapping of that report or use a |
| integrated solution for small and midsize companies | | | | Crystal Report query. |
| looking to expand their business operations without | | | | Microsoft SQL Server |
| much interruption to its existing processes. Microsoft | | | | Using Microsoft SQL Server in Microsoft Navision will |
| Navision enables businesses to alter as much or as | | | | help a great deal since SQL has the ability to |
| little of its existing system, integrate add-ons and | | | | integrate Navision to third-party products. SQL Server |
| vertical segments of its development. It integrates | | | | has a virtual table that you can access to minimize |
| every aspect of your organization, from customers | | | | the complexity of looking at links in Crystal Reports |
| to suppliers, from accounting to supply chain, | | | | itself. By referencing the view name in a |
| increasing your productivity and competitive edge. | | | | Transact-SQL statement, a user can access this |
| Microsoft Navision has an open environment | | | | virtual table and retrieve the data for future selection |
| architecture making it fully customizable and easy to | | | | to be applied into Crystal Reports. You also have the |
| use and maintain. It can also be implemented rapidly | | | | option of creating Stored Procedures to execute a |
| so that there is only a minimal disruption to business | | | | number of Transact-SQL statements into a single |
| operations. | | | | command. Furthermore, SQL Query Analyzer can |
| Microsoft Navision was originally written by | | | | copy existing database objects and locate, view or |
| Denmark-based Navision Software in its own | | | | work with these objects within the database. |
| proprietary language C/SIDE (Client/Server | | | | Reports on Heterogeneous Database |
| Integrated Development Environment). Both | | | | If Microsoft Navision sits in an SQL Server, you have |
| European and North American markets have | | | | the ability to create a link from your database server |
| benefited from its use. Its launch in the global market | | | | to another third party database (Oracle, DB2, |
| will help organizations scale up their development and | | | | Unidata, Ingress, Sybase, Pervasive, Ctree, MS |
| add value to their business. | | | | Access) for report creation in Crystal Reports. For |
| One of the primary reporting tools used today is | | | | example, if you are on a C/SIDE Database, create a |
| Crystal Reports. With its ability to call up information | | | | link server to it with C/ODBC. You then create |
| from SQL commands, using Crystal Reports adds | | | | additional linked servers to your legacy database. |
| extensive functionality in your reporting procedure. | | | | These links will serve as your pool for creating one |
| The following is an overview of Crystal Reports as it | | | | Crystal Report using a number of databases. |
| relates to Microsoft Navision: | | | | Knowledge about OPENROWSET keyword in SQL |
| C/SIDE | | | | Server is useful for this kind of execution. |
| C/SIDE is Microsoft Navision's graphical integrated | | | | Microsoft Navision is a powerful analytical tool for |
| development environment that provides | | | | your business performance. Adding Crystal Reports |
| customization tools for developing customer specific | | | | to its functionalities will provide a more systematic |
| solutions to be applied to a business process. | | | | way of measuring your organization's competence. |
| Inside Crystal Reports, use C/ODBC to create a | | | | Need more information? |
| connection to the database needed for report | | | | Contact us: For customization work and advice, |
| generation. Links are done inside Crystal Reports. | | | | please contact Andrew Karasev, Alba Spectrum Chief |
| However, this connection technique tends to be | | | | Technology Officer. His works include development |
| inflexible if you want to modify your database | | | | of applications with the use of Dexterity, SQL, C# |
| mapping or links inside the report. You may want to | | | | .NET, Crystal Reports and Microsoft CRM SDK. |