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
family-safe home cleaners Lincolnshire ...Introduction: The creating of a computer program involves a number... Read More
What is a Web Database?A web database is a database... Read More
If there still are few unprotected computers left, I haven't... Read More
The purpose of one of our projects was MS Exchange... Read More
Just when you thought you were Web savvy, one more... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
Today's business world is fast-paced. No matter what it is... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
Are you one of those people that keeps track of... Read More
Fleet Maintenance Management is a critical position in any company... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
In our case ? we serve Microsoft Business Solutions ERP... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
We live in a post-industrial age where information is the... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Microsoft Business Solutions is now in process of creating so... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
If you are to buy a HelpDesk & Asset Management... Read More
We were recently faced with a decision: either to let... Read More
The vast majority of us will have, at some point,... Read More
If you have Microsoft Great Plains and support it... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
In a previous article, I wrote about OpenOffice... Read More
housekeepers near Morton Grove ...The Internet is reshaping every form of communications medium, and... Read More
Have you ever noticed that when you look at your... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
XML Server can be a Web Server that stores the... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
If you feel intimidated when someone tries to teach you... Read More
Find out why Spyware Removal from computers is important and... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
It is really interesting that a bug can create problem... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
This article illustrates the best practices to improve the performance... Read More
Using professional icons in your application or website can bring... Read More
When making a decision to buy any piece of software... Read More
Microsoft Business Solutions Great Plains has I'd say end user... Read More
Icons are used everywhere; right from software applications, to internet... Read More
How to delete the user? This is the first problem... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
(1) Avoid using the same variable again and again for... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Software |