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
Lincoln Stretch rentals Alsip ..Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
How to delete the user? This is the first problem... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
If your company has regional and worldwide operations, you might... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Now that spyware is the single most dangerous threat to... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
I love new technology. I am still ready to wait... Read More
If you have been using the Internet for any amount... Read More
We don't think about mainframe software pricing anymore, we just... Read More
In the new era of internet marketing the problem of... Read More
C++ Function templates are those functions which can handle different... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
There is many things more frustrating than surfing a website... Read More
Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
I've been active in the Cisco Certification track for four... Read More
IntroductionSurprised, by the title? well, this is a tour of... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
The term "document management" and "paperless office" is the subject... Read More
Western Springs shuttle limo ..Great Plains Inventory Management (IV) module gives your business a... Read More
If you look back to the history, you will see... Read More
The stakes are high when considering security, privacy, and savings,... Read More
The adware and spyware definitions list is very long. But... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Did you ever want to erase everything on your computer?... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
In a previous article, I wrote about OpenOffice... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
We don't think about mainframe software pricing anymore, we just... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
When you need a phone number, you do a quick... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
It???s easy to understand why you might be drawn to... Read More
As we could imagine, if you are reading this article... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
Software |