Microsoft Business Solutions ? Great Plains is designed to meet and extend the needs of small and mid-size organizations for its business success. Its comprehensive accounting and business management applications also provide businesses with capabilities to customize various modules of the Great Plains software to fit to their specific needs. Because of these potentials, Great Plains has been targeted to the whole spectrum of both horizontal and vertical clientele.
A number of industry-specific applications integrate well with Great Plains. This allows for more flexibility and unparalleled access to information that aids in decision-making and analysis of performance.
Crystal Reports is a report-writing software that can integrate itself to Great Plains' database. It goes beyond the report creation process of Great Plains' own Report Writer. As a developer, Crystal Reports will help your client access decision-driving information to aid in managing their businesses more effectively. So, how do we use Crystal Reports to extend Great Plains Report Writer?
Great Plains Table Structure
When a business entity is processed, the information is written onto the Great Plains database tables. This can be found by launching Great Plains, then: Tools > Resource Description > Tables. Find the appropriate Table:
RM00101 ? Customer Master File
SOP30200 ? Sales History Header File
Create ODBC Connection
Open Database Connectivity (ODBC) is an integration tool to connect a client application to an ODBC-compliant database. It allows exchanging information among databases and easily integrates with a wide range of present systems. Great Plains uses the ODBC drivers installed by Microsoft SQL Server.
To create an ODBC connection to a Great Plains company database, one common way is with the use of the Data Source dialog box. It prompts you to connect to the appropriate data source. Choose the company database that you are targeting that contains the data needed for your Crystal Reports report generation.
SQL Views
Microsoft SQL Server has a virtual table that you can access to minimize the complexity of looking at links in Crystal Reports itself. By referencing the view name in a Transact-SQL statement, a user can access this virtual table and retrieve the data for future selection to be applied into Crystal Reports.
SQL Stored Procedures
There are instances wherein you will not be able to pull all your needed data into one view. In this situation, you would need an SQL stored-procedure ? defined as a group of Transact-SQL statements compiled into a single execution plan. With the help of a stored procedure, you do not need to access individual tables to use in Crystal Reports.
Calling Crystal Reports via VBA/Modifier
It is possible to call the Crystal Reports engine from one Great Plains application to do a process with the use of Modifier and VBA. For example, you want to print a Crystal Reports invoice in Great Plains from the Sales Order Processing window, use Modifier and VBA to call up the Crystal Reports engine.
SQL Query
Using SQL Query Analyzer can help in making sure you are getting adequate results in your report generation. In addition, it debugs stored procedures and query performance problems. It can also copy existing database objects and locate, view or work with these objects within the database.
Need more information?
Contact us: 1-866-528-0577 or help@albaspectrum.com
For customization work and advice, please contact Andrew Karasev, Alba Spectrum Chief Technology Officer. His works include development of applications with the use of Dexterity, SQL, C# .NET, Crystal Reports and Microsoft CRM SDK.
Divine Rigor is the Technical Writer for Alba Spectrum Technologies USA ( http://www.albaspectrum.com ), a Great Plains, Microsoft CRM customization company. We are based in Chicago with locations in California, Arizona, Texas, Florida, Georgia, New York and contacts in international markets.
? Jan 2005 Alba Spectrum Technologies USA
Beecher limo rentals ..When you double-click a layer in the Layer Palette, you... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Buying accounting software is a major investment. It's an important... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
With thousands of web pages added to the Net every... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
In the real world a "fire wall" is a fireproof... Read More
TikiWiki is open source software - it is written in... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
It would be easy to think, like most people apparently... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
CD and DVD replication is a process that works by... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
So, why should you use any O/R mapping tool? I... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
Once upon a time not so long ago, there was... Read More
Bridgeview limo Chicago ..I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Sales are all about leverage, because there is only so... Read More
If you have Microsoft Great Plains and support it for... Read More
Since technology changes so quickly, it is hard to begin... Read More
When you visit department stores and see that majority of... Read More
And kill the best layout software in the process of... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
The term "document management" and "paperless office" is the subject... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Microsoft Great Plains might be considered as ERP platform to... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
What is installation in the language of technology? Installation... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Are you one of those people that keeps track of... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Spyware and malware are large problems for Internet users today... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
In our small article we'll consider Microsoft Business Solutions Great... Read More
Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Enabling Chinese input is quick and easy, there are only... Read More
Software |