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
|
|
|
What Is Preventive Maintenance Software?
Preventive Maintenance (PM) is defined as scheduled work done on a system to identify and fix any occurring issues before they become problems. The concept of preventive maintenance applies to many different industries. PM is often done on buildings, various types of machines, computers, institutions, as well as personal assets, including finances and property.A common example of preventive maintenance is a car getting its oil changed. Usually, this is done when the car is in good working order to prevent any future problems resulting from the car running on old oil.In the past, preventive maintenance ...(related: Software)
10 Things You Can Do With Photoshop Cs2 That You Couldnt Do Before Now
Is Photoshop CS2 worth the upgrade? You bet it is! Here are just 10 things you can do with this fantastic new version of Photoshop that were impossible (or difficult) to do with previous versions:1. Manipulate objects in the Adobe BridgeThis new generation of file browser enables you to look at photographs and artwork in detail before you open the file, process multiple Camera Raw images, flip t...(related: Software)
Vlans
In order to implement VLANs in a network environment, you'll need a Layer 2 switch that supports them. Almost all switches sold today that are described as "managed" switches provide the ability to make ports members of different VLANs. However, switches ...(related: Software)
Helpdesk & Asset Management Software - Choosing The Right One
If you are to buy a HelpDesk & Asset Management software, see the following checklist before you decide on one.Comprehensive Help Desk FunctionalityA good Help Desk product can dramatically rise the productivity of the Help Desk Personnel (which in turn will rise the organisation's productivity as a whole). Computer users can be made to submit their requests by mail, phone or through the web interface provided by the product. These requests gathered centrally will be attended to by technicians (who already are automatically notified about the request). Adding memos/notes to the requests & viewing the history of Requests can help too.Buildable Knowledge Base (KB)<...(related: Software)
Google Brings The Earth To Your Desktop
Google Inc. has launched a new software package that allows you to see satellite images on your desktop.Google Earth lets you search for locations anywhere on earth and display 3D aerial images ...(related: Software)
Econnect: Ecommerce Development For Microsoft Great Plains
Microsoft Business Solutions Great Plains has several options to enable web ordering. Traditionally Great Plains Dynamics/eEnterprise had eOrder ? this is ASP pages based ordering application, enabling you to place or retrieve your Sales Order Processing (SOP) Sales Orders over the web. There were several drawbacks however with eOrder. You should be the customer in Great Plains company database to be able placing the orders. Also if you were planning to customize eOrder ? you could only do cosmetic style changes only ? if you wanted to alter scripts on the ASP pages ? then you would have very serious eOrder upgrade issues. Upgrade simply wipes out your custom scripts and you had to reapply your customization to new version enriched ASP pages...(related: Software)
Device Driver Basics
Most people understand that the "hardware" part of their computer is the real physical parts, like the keyboard, mouse, modem, hard drive and so on. They understand that the "software" is computer bits stored on the hard drive, CD-ROM, or other storage media. But most people are a little hazy about exactly what a "driver" is.In this article, I'm going to reveal in plain English what a driver is, why we need drivers, and exactly where the drivers are hiding. To give you a basic understanding, I'm going to go back, way back, to the early days of computers.The Early DaysThe year is 1981 and the world is in the midst of a severe resession. IBM's main frame business has slowed and the company is losing money. Up until now they had been laughing at the array of microcomputer...(related: Software)
Groupware: What Works The Way Businesses Do?
GroupwareThe internet is full of 1.5 million to 7 million indexed pages of groupware packages available on the market today. Every business needs groupware to control, manage, or track documents.Groupware is similar to other systems that enable document management, often using a centralized system to work through business collaboration processes to create budgets, market reports, presentations, contracts, and countless other documents necessary to run a business.Ad Hoc Collaboration<...(related: Software)
Microsoft Crm And No-frills Cadillacs
In today's business world it's all but impossible to escape Microsoft. Either you're using MS applications, developing you...(related: Software)
Database Guru James F. Koopmann Reviews Dbxtra Reporting And Query Tool
DBxtra is a powerful query and reporting tool that hides many of the complexity and technical expertise required for creating connections to disperse data sources, building queries, designing reports, and delivery information throughout an enterprise or to your customer base.With the ability to connect to multiple databases or data sources at the same time, DBxtra allows for cross platform data aggregation and the ability to answer questions that would typically take IT time to migrate data into a single reporting database. Through powerful query and filtering mechanisms users have the ability to browse and achieve fine grained retr...(related: Software)
Constructionalist Parsing - Deciphering Natural Language
The research in the field of Natural Language Processing usually assumes the existence of a syntactic "Generative Engine" that combines words and word-like elements into syntactic structures, and then sometimes displaces them by "syntactic movement". A Linguistic Parser must "undo" all the effects of syntactic movement, which results in a structure where the relations between the words are represented more directly.In recent years, a new theoretical framework was introduced, i...(related: Software)
These Items Are A Must Before Making The Decision To Purchase Any Off-the-shelf Software
1. What determines the software price? Is it Per Seat or Per User or Per Processor?The cost of software is determined in many ways. The two most popular ways are Per Seat or Per Concurrent User. Per Seat is determined by how many seats in your business will be using the softw...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software