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
![]() |
|
![]() |
|
![]() |
|
![]() |
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
In order to implement VLANs in a network environment, you'll... Read More
Whether you are an experienced web programmer or a complete... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
We'll give you non formal view, based on our consulting... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
MS CRM is very close to document workflow automation, including... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
When you think... Read More
Need software to record your voice, streaming audio or musical... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Finally, you have some time to personalize your desktop with... Read More
There are plenty of articles out there about how to... Read More
Crystal Reports is the most flexible tool on the market... Read More
XML parser is a software module to read documents and... Read More
It is really interesting that a bug can create problem... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
If you feel intimidated when someone tries to teach you... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
If you have been running Windows XP for a couple... Read More
Program Flow is what you think it is. How the... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
New post-recession era has new features, which didn't exist in... Read More
Sometimes your PC will start acting strange for no apparent... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
The Internet is reshaping every form of communications medium, and... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
People often ask me: What image file formats will Photoshop... Read More
Microsoft Outlook is one of the most widely used software... Read More
Best Software Act! is very popular CRM for small and... Read More
Are you a whiz at calculating financial information? Not the... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
Learning how to program software seems like a daunting task... Read More
This is a short article, written in question/answer/FAQ style to... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
It's no secret that software companies operate in a very... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
Before September of 1995, Microsoft ignored the Internet because their... Read More
I completed an experiment recently. I wanted to find out... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
When it comes to screenplay software each screenwriter needs to... Read More
Hey Guys! Don't raise your eyebrows or fear by hearing... Read More
I have always had a tendency to focus on the... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
In the real world a "fire wall" is a fireproof... Read More
It is now common thing when large corporation selects mid-market... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Microsoft Business Solutions Great Plains is very generic accounting application... Read More
We live in a post-industrial age where information is the... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Viruses and spyware usually show up on your computer one... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
Software |