Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the report creation.

  • C/SIDE database - use C/ODBC to create the connection for your Crystal Report. You have to make all the links inside the report. The drawback of this approach - report becomes inflexible if you would like to change database mapping (re-link from work to historical tables for example) - it is probably easier to redo report from scratch. You can use something like Crystal Query - which is still very restricted in its functionality.
  • Microsoft SQL Server - you are better positioned to create Crystal Reports. You can deploy MS SQL Server views. View will allow you to unionize work and historical info, pull the data from several databases to name a few nice features. Also the option to use stored procedures (or stored procs) enables you to create temp tables for data manipulation before sending the final result set. You can also have parameters (name of the company/database, dates restrictions) - this gives you additional advantage versus SQL View
  • Reports on geterogeneus databases - imagine creation of Linked Server in your Microsoft SQL Server Enterprise Manager. If Navision sits in MS SQL - you create linked server to the third party database (Oracle, DB2, Unidata, Ingress, Sybase, Pervasive, Ctree, MS Access). If you are on C/SIDE DB - you create linked server to it via C/ODBC, then you create additional linked servers to your legacy DBs. Now you are ready to create geterogeneus SQL View to link all your databases and have the data shown in one Crystal Report. You should probably familiarize yourself with OPENROWSET statement in Transaction SQL

Good luck in reports design and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Robert Horowitz is Certified Navision Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies ? USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com).

You can contact Robert: welcome@albaspectrum.com

In The News:


pen paper and inkwell


cat break through


The Importance of Timely Timesheets

Whether you are a small consultancy firm, a medium sized... Read More

What You Must Know About Spyware Right Now

Spyware is like the new technological nuclear weapon on the... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Constructionalist Parsing - Deciphering Natural Language

The research in the field of Natural Language Processing usually... Read More

OEComplete ? A Personal Information Manager

OEComplete is a utility for managing the personal information of... Read More

How to Upgrade Dexterity Customization ? Tips for IT Manager

If you have Microsoft Great Plains and support it... Read More

S is for Spying, Surveillance -- and for Software as Well

Words we choose to describe things and phenomena often show... Read More

The Religion And Philosophy Of Small Internet Business

I have always had a tendency to focus on the... Read More

Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

3 Reasons Why Medical Billing Software is Leading the Way

Since technology changes so quickly, it is hard to begin... Read More

Navision Attain Database access via C/ODBC in ASP.NET Application

Navision Software was purchased by Microsoft and now it is... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

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

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Free Program Removes Spyware not Detected by Premium Security Scan

What is Spyware?Spyware monitors your surfing habits and sends the... Read More

A Case Study on Selecting Contract Management Software

Professional services firm cuts costs and improves productivity with integrated... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

Microsoft Business Solutions Great Plains is written in Great Plains... Read More

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Design a Web Album Using Adobe Photoshop- Part 2

So let's begin crunching down these 300 images using Adobe... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Getting Patched with Windows Service Pack

Are you one of those people that keeps track of... Read More

Simple Solution for Php Includes - IFrames

I have recently created my first Php program. I wanted... Read More

C++ Tutorials: 3, Program Flow (If, Else, While, For)

Program Flow is what you think it is. How the... Read More

Microsoft Great Plains Customization: Project Organization ? International Business Example

Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

HelpDesk & Asset Management Software - Choosing The Right One

If you are to buy a HelpDesk & Asset Management... Read More

Twelve Things You Should Know to Save on Computer Software

Do you want to get quality software at a reasonable... Read More

Microsoft Great Plains BR: Bank Reconciliation

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