Home
>
Software
>
Microsoft Navision and Crystal Reports - An Overview

Microsoft Navision and Crystal Reports - An Overview

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?

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.

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.

limo prices to midway Crystal Lake west of Randal .. Lockport Chicago limo O’Hare

In The News:

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

The number of people affected by a UnitedHealth data breach in February 2024 was actually higher than previously reported and was the largest medical data breach in U.S. history.

A phishing campaign uses Google Calendar to schedule fake meeting invitations that appear legitimate, redirecting targets to phishing sites.

Toll road text scam: Fake messages claim unpaid fees, seek payment via fraudulent links. Kurt “CyberGuy" Knutsson says this scam is becoming increasingly sophisticated and widespread.

Kurt “CyberGuy" Knutsson says these steps ensure that your friends and family get to the exact moment you want them to see. Try it out and streamline your sharing experience.

Tech expert Kurt “CyberGuy" Knutsson offers tips on how to protect your identity: Be vigilant, monitor accounts, use smart security, know theft response.

Tech expert Kurt “CyberGuy" Knutsson says cybercriminals are exploiting iMessage phishing protection, tricking users to reactivate links.

It's hard to imagine life without in-flight Wi-Fi these days – but sky-high web surfing comes with its own set of privacy concerns. Here's how to protect yourself.

Over 400,000 cases of credit card fraud were reported in 2024 to the Federal Trade Commission. The CyberGuy explains how to protect against becoming another victim.

A nondescript metal box transforms into a fully functional electric motorcycle that blurs the line between vehicle and urban infrastructure.

Many apps unrelated to location still ask users for tracking permission, and Texas Attorney General Ken Paxton has filed a lawsuit seeking to end this alleged practice by Allstate.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Melody, the artificial intelligence-powered robot, is life-sized and represents a move toward creating robots that resemble people in appearance and interaction.

Here are five easy smartphone rules from the National Security Agency that you can follow to better protect your mobile device from hackers and scammers.

A U.S. robotics company has developed "Jennie," a robotic pet powered by artificial intelligence that's designed to comfort those facing mental health challenges.

Healthcare records for more than 184 million Americans were breached in 2024, but you can take steps to minimize that risk. Kurt the CyberGuy explains.

The Skyrider X1 from Rictor claims to be the "first amphibious flying passenger motorcycle," and it combines land and air travel in one sleek design.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Home inventory and restoration apps help itemize and track every item in your home in the event you have to make an insurance claim after a natural disaster.

The White House launched a new cybersecurity safety label, the U.S. Cyber Trust Mark, intended to help consumers make informed decisions on smart device safety.

Today's tech can help make life so much easier — if you know how to use it. Here are a few tips on the quickest and best ways to make your phone, laptop and other devices work for you.

Tech expert Kurt “CyberGuy" Knutsson offers Windows 11 restart fixes: Update drivers, run system scans and check hardware.

Sony and Honda's Afeela 1 EV launches with advanced tech and entertainment for $89,900. Tech expert Kurt “CyberGuy" Knutsson gives his takeaways.

With limited hard drive space, tech expert Kurt “CyberGuy" Knutsson offers these tips for storing large video files and photos.

Tech expert Kurt “CyberGuy" Knutsson says the $236,000 Yangwang U9 electric hypercar boasts 1,287 horsepower and can jump obstacles.