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

---

Unwanted Files

A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More

Fleet Maintenance Software Reviews

Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

Examining the Substance of Studio MX

To all web designers out there, this article is for... Read More

Lotus Notes Domino and Microsoft CRM Integration

Well, even if the combination might look very unusual, we... Read More

Microsoft Great Plains eCommerce ? Stored Procedures Approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

Theres Gold in Your Websites Server Log

Many Webmasters have never bothered to view their website's server... Read More

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Why Java RDBMS?

It is a well known fact that Java as a... Read More

CRM and Customer Life Cycle

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

Hear It in Digits

Music downloads are off the charts! We're listening to digital... Read More

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Falling in Love With More Than One Screensaver: The Fun Part

Having from five to ten and more favorite screensavers is... Read More

Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

When Great Plains Software introduced the first graphical accounting application... Read More

Microsoft CRM Data Import FAQ

Microsoft CRM has built-in conversion tool, however you should probably... Read More

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

RFID: Strengthen the Position for SAP; United States

SAP Inc., a global leader in client/server enterprise application software... Read More

What is Preventive Maintenance Software?

Preventive Maintenance (PM) is defined as scheduled work done on... Read More

Review of TikiWiki Content Management System

TikiWiki is open source software - it is written in... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Do You Know These Facts About Spyware ?

Imagine something that follows you home and sets itself up... Read More

CRM 101: Customer Relationship Management for Beginners

Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

How To Avoid Getting Hooked By Pfishing

"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

10 Programming Tips

(1) Avoid using the same variable again and again for... Read More

Dashboard Widgets for Windows

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

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

How To Make Good Use of Spreadsheets

Most computer users use spreadsheets software such as Microsoft Excel... Read More

Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

Great Plains Dexterity Programming ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

The End of Spyware?

The US House of Representatives has recently passed the "Spy... Read More