Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft Navision and Crystal Reports - An Overview > NetSparsh - Viral Content you Love & Share

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 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

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 ( ), 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.

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at


It's time to regulate: The US must make software companies liable for breaches
The software industry has failed to sufficiently protect the public from data theft and misuse. It's time for the U.S. government to get serious about regulation. Last year, multiple U.S. government agencies established guidelines for improved ...


Pivotal Software files for IPO | TechCrunch
The enterprise cloud computing company is majority-owned by Dell, which came about after its merger with EMC in 2016. It was spun off from Dell, EMC and VMware in April 2013. Since then, it raised $1.7 billion in funding from Microsoft, Ford and ...
3 Takeaways From the New Pivotal Software Upcoming IPOFortune
Pivotal Software IPO S-1 prospectus filing - CNBC.comCNBC
Dell-Backed Software Firm Pivotal Files For IPOForbes
Wall Street Journal -MarketWatch -CRN
all 24 news articles »


Cloud Software Stocks Rise on M&A Hopes - Barron's
What emerged from the market swoon of February was a surprising surge in the shares of young software companies. These cloud-oriented companies are heading skyward on renewed mergers-and-acquisitions fervor. Since the Nasdaq's bottom on Feb. 8, at 6 ...

and more »

24/7 Wall St.

Pivotal Software Gears Up for IPO
24/7 Wall St.
Pivotal Software has filed an S-1 form with the U.S. Securities and Exchange Commission (SEC) regarding its initial public offering. No pricing details were given in the filing, although the offering is valued up to $100 million, but this is normally ...


Popular tax software may expose users to phishing attacks
A new report by security research firm Global Cyber Alliance finds that some of the most popular tax software providers may leave consumers at risk for identity theft.

and more »

The Register

UK Court of Appeal settles reseller's question: Is software a good ...
The Register
Software is not a good, the Court of Appeal in London, England, has ruled. More specifically, software is not a "good" as defined in the Commercial Agents EU Regulations, said the civil court in a ruling that overturns an earlier decision granting ...

and more »

Software helps NY college students track progress toward degree
Nassau Community College is boosting its efforts to increase student retention and on-time graduation through a new software program called DegreeWorks. The web-based auditing software allows students to see what courses they need, what order to take ...

The Register

UK Court of Appeal settles reseller's question: Is software a good?
The Register
Lady Justice Gloster of the Court of Appeal agreed with CA that "on a proper construction of the language in the regulations, the software did not constitute 'goods' within the meaning of Regulation 2(1)". The software itself was only ever supplied as ...


Refreshed iPad and software to be focus of education event, cheaper MacBook reportedly not ready
There's also a chance Apple will unveil a new version of its iBooks Author software to allow teachers to make their own teaching materials, as well as a renewed push to bring textbooks into the digital era. We may also see Apple announce the release ...
What to expect at Apple's education eventQuartz
Apple to launch low-cost iPad and educational software next week: BloombergBGR India
Apple is working on a 'foldable' iPhone for release in 2020, says Bank of AmericaCNBC
Bloomberg -Emojipedia Blog
all 507 news articles »

Milwaukee Journal Sentinel

Ex-soldiers enlist in 'boot camp' again —​​​​​​​ this time, to learn software coding
Milwaukee Journal Sentinel
Joel Corey helped clear roads of bombs in Afghanistan's Helmand Province, a job skill not easily translatable into the civilian workforce back home. But what made Corey a good soldier — hard work, tenacity, loyalty, problem solving — is helping him ...

Google News

Resume Software ? Advantages Revealed

The various resume software offered, particularly on the internet, can... Read More

New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink

Three highly respected names in Human Resources have joined forces... Read More

Adware and Spyware

What is 'adware'?Adware is basically software or scripts that are... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

Importance of Coding Standards

Programming Help for BeginnersWe write programs to instruct computers. When... Read More

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

This article illustrates the best practices to improve the performance... Read More

Microsoft Great Plains Integration Manager ? Advanced Techniques

Great Plains Integration Manager scripting and translation - overview for... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

CRM and Customer Life Cycle

Customer Relationship Management or CRM is a combination of enterprise... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

Defining OLAP Solutions and Data Warehouse design

This tutorial covers OLAP solutions used by Data warehouses and... Read More

How to Choose the BEST Charting Software

I suggest that you do not spend a lot of... Read More

Internet Faxing Service Review

The Internet is reshaping every form of communications medium, and... Read More

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

Microsoft Great Plains: Large Scale Implementation

Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

Professional Software Icons For Your Standalone Application

User interfaces and accessibility are some of the most important... Read More

Software Review: Xsitepro Total Site Management Software

It's not very often I get excited about a software... Read More

10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now

Is Photoshop CS2 worth the upgrade? You bet it is!... Read More

Making The Decision To Automate Your Software Testing

Not every software testing project can or should be automated.... Read More

Microsoft Great Plains Inventory Control ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Screenplay and Script Writing Software

When it comes to screenplay software each screenwriter needs to... Read More

What You Should Know About Installing Screensavers

Do you remember that frustrating feeling when you find an... Read More

Mapping Software: Putting Data Visualization on the Map

Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More

Adware, What Is It?

Adware is a type of Spyware program that displays some... Read More