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.
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
- 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
You can contact Robert: welcome@albaspectrum.com
Microsoft Navision Resources
The Day My Laptop was Stolen Almost Killed My Business
One of the worst feelings I have ever had was the day my laptop was stolen. The laptop can be replaced. However the loss of critical DATA was the biggest risk my business has ever faced. When I recovered...
Safe and Secure Data Recovery
The government has a set of demands that strictly require procedures to have absolute security while data is being recovered from computer media that has become damaged and unreadable. Some facilities...
5 RAID Data Recovery Prevention Tips
If you have spent the time to increase your computer's performance by setting up a hardware RAID array, you owe it to yourself to invest a little extra time and effort in maintaining the hard disks in...
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...
Offsite Backups Provide Digital Peace of Mind
In today's fast paced data-centric world of personal computers and consumer/business electronics (such as PDAs and digital media players) we have, as a society, developed a reliance on digital data. We...
Protect Yourself Before Your Hard Drive Crashes
Almost everyone who has used a computer has experienced a hard drive problem at some point. Are you prepared to lose your data? If your hard drive crashes right now, do you have an action plan to follow?...
Additional Microsoft Navision Related Resources...
There's More Than One Way To Make Microsoft Software 'serviceable' (ZDNet)
Microsoft's Software+Services (S+S) strategy comes in many guises. At its Convergence 2008 conference in Orlando this week for its business-applications customers and partners, Microsoft highlighted yet another one of its S+S forms: Third-party service extensions to its on-premise software. Microsoft's business applications include four different ERP suites,...
Microsoft's Software+Services (S+S) strategy comes in many guises. At its Convergence 2008 conference in Orlando this week for its business-applications customers and partners, Microsoft highlighted yet another one of its S+S forms: Third-party service extensions to its on-premise software. Microsoft's business applications include four different ERP suites,...
Arabian Computer News English Edition (ITP.net)
ACN looks at some of the biggest hitters in the software market that will influence enterprises for the years to come.
ACN looks at some of the biggest hitters in the software market that will influence enterprises for the years to come.
Software Entrepreneur And Philanthropist Bruce A. Saville Joins Board Of Serenic Corporation (CNW Group Via Yahoo! Finance)
Serenic Corporation , , a leading publisher of financial management and business operations software for not-for-profit organizations, is pleased to announce that Bruce A. Saville and Randy Keith have joined the Board of Directors of the Corporation.
Serenic Corporation , , a leading publisher of financial management and business operations software for not-for-profit organizations, is pleased to announce that Bruce A. Saville and Randy Keith have joined the Board of Directors of the Corporation.
Features And Case Studies (ZDNet Australia)
Any manufacturer knows that a product recall can be an absolute nightmare of paperwork and logistics.
Any manufacturer knows that a product recall can be an absolute nightmare of paperwork and logistics.
Thereâ€Âs More Than One Way To Make Microsoft Software â€Âserviceable†(Addict 3D)
Microsoft’s Software+Services (S+S) strategy comes in many guises. At its Convergence 2008 conference in Orlando this week for its business-applications customers and partners, Microsoft highlighted yet another one of its S+S forms: Third-party service extensions to its on-premise software.
Microsoft’s Software+Services (S+S) strategy comes in many guises. At its Convergence 2008 conference in Orlando this week for its business-applications customers and partners, Microsoft highlighted yet another one of its S+S forms: Third-party service extensions to its on-premise software.
