Easy Data Recovery

Data Recovery Software, Tools, Methods, Reviews, Advice & More!

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

Article By: Robert Horowitz

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

Choose A Customized Data Recovery Solution From DiskDoctors:

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

Microsoft Navision Resources

Data Recovery Floppy Disk Help and Advice

There is data recovery software out there that recovers corrupt or lost data that is on your floppy disks. When the data recovery floppy disk is recovered with recovery software, the software should be...

Apple Mac Data Recovery Solutions

For people using Apple computers, knowing about Mac data recovery can be a valuable piece of information. Mac data recovery is the process that takes place when data is lost, for whatever reason, on an...

Understanding RAID data recovery

RAID data recovery is, of course, the act of recovering data from a RAID system. For those of you in the dark about what a RAID system is, I hope to shed a bit of light on the subject in this brief outline....

How Can a Data Recovery Expert Help?

A data recovery expert is a computer technician or at least someone well-versed in the trade that handles the operation of recovering lost or accidentally deleted data. Many people turn to a data recovery...

Your Data is Your Life!

It is hard to imagine the world without computers. I often find myself wondering about how we survived in the pre-computer era. Just a few short years ago the general population used computers for much...

Data Recovery The Easy Way

If you aren't prepared in advance, you will most likely have to use a data recovery service or data recovery software solution to help get back as much as you can of what was lost. This can be a very good...