Crystal Reports for Microsoft Great Plains

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 ...
In The News:

A single data broker opt-out may not be enough. Spokeo, Whitepages and BeenVerified can still expose your address and family details to scammers.
Apple Photos now embeds an invisible SynthID watermark in images edited with Apple Intelligence tools like Clean Up, Extend and Reframe in iOS 27.2.
Fortra researchers say fake vacation rental sites use live customer support chats to trick travelers into handing over credit card details this holiday.
Ecolab CEO Christophe Beck says AI data centers could drink as much water as Americans by 2030 unless direct chip cooling and water recycling catch on.
Ring's Drone Cam flies room to room with AI navigation, 2K video and a $249.99 price, but it still awaits FCC authorization before it can ship in the U.S.
Virginia's GPS speed limiter program is already active for reckless driving offenders, but early users report glitches that apply wrong speed limits.
VPN split tunneling lets your banking app skip the encrypted tunnel while other apps stay protected, and the Allow LAN setting can fix printer issues.
A fake E-ZPass email cites a real federal regulation to demand toll payments, but the law it references has nothing to do with collecting tolls.
A credit freeze, fraud alert and identity monitoring each protect different parts of your financial life after a data breach. Here's how to choose.
OpenAI's new classifier flags 48% fewer images for review while detecting similar levels of CSAM, and ChatGPT now suspends users for 24 hours.
USF researchers built an AI mosquito trap with over 98% accuracy as Florida battles its largest dengue outbreak in decades with 524 local cases.
Fake OpenAI event pages promise free ChatGPT Pro subscriptions, then trick employees into handing over Microsoft and Google account credentials.
Ford's new privacy promise pledges not to sell driving data to insurers or brokers, but disabling connected car data sharing could cost you key features.
Google says Videostrong deliberately installed backdoor malware in over 1.3 million Android TV boxes, turning them into a botnet for criminals.
Foundation Future Robotics co-founder Mike LeBlanc says the MK 2 humanoid is ready to engage enemies with machine guns in Ukraine's combat zone.
EAIGLE says its AI camera technology cuts truck check-ins from 10 minutes to under 30 seconds, potentially reducing fuel waste across supply chains.
The Fox News AI Newsletter covers the latest artificial intelligence technology advancements, including the challenges and opportunities AI presents.
After the military, some veterans are left wondering what's next? Nonprofit organization Vets to Drones is helping them take on a new path by becoming certified drone pilots.
Natasha Lopez says a Flock camera system helped a Georgia deputy track her family, and after she spoke out, a fake Facebook page targeted her children.
Data broker opt-outs may not keep your personal information private for long. Five common myths leave retirees especially vulnerable to scams.
What's Nvidia's future after the resignation of CEO Jensen Huang amid scandals? Weigh in here!
Meta's AI age-estimation technology now scans Instagram accounts worldwide, placing millions of teens into stricter safety settings automatically.
The FTC sent warning letters to 25 companies over misleading health insurance ads as open enrollment brings a surge of deceptive offers online.
Michigan's new prison scoring system claims 30% better violence prediction, but Recidiviz says it doesn't actually use AI to classify inmates.
University of Texas at Arlington researchers reveal how AI analyzes public Instagram posts to craft spear phishing emails that feel personal.

Programming Environments And The Software Production Process

Introduction: The creating of a computer program involves a number... Read More

Daffodil DB: Web Database

What is a Web Database?A web database is a database... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Removing Incoming Email in MS Exchange, C# Example

The purpose of one of our projects was MS Exchange... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

Software Upgrades Arent Always the Best Move

When my daughter was getting into AOL instant messaging (AIM)... Read More

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

MCP Market News: Microsoft SQL Server & SQL Reporting Services

Are you ready? SQL Server 2005, the next-generation data management... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

Getting Patched with Windows Service Pack

Are you one of those people that keeps track of... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

Call Alert Notifications - Free Answering Machine Software for PCs

If you're online using a dialup Internet connection, you'll probably... Read More

ERP Software Financing: the Future? ? Overview for Company Owner

In our case ? we serve Microsoft Business Solutions ERP... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

Microsoft Business Solutions Great Plains has substantial market share and... Read More

Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

Microsoft Business Solutions is now in process of creating so... Read More

.NET :Solving the Multiple Inheritance Issue Under .NET Platform

.NET platform does not support multiple inheritance. Do not confuse... Read More

HelpDesk & Asset Management Software - Choosing The Right One

If you are to buy a HelpDesk & Asset Management... Read More

Open Source Concepts: Dual Licensing Explained

We were recently faced with a decision: either to let... Read More

The True Meaning of Freeware

The vast majority of us will have, at some point,... Read More

How to Upgrade Dexterity Customization ? Tips for IT Manager

If you have Microsoft Great Plains and support it... Read More

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

Free PDF Publishing Software

In a previous article, I wrote about OpenOffice... Read More

housekeepers near Morton Grove ...