Software - Crystal Reports For Microsoft Great Plains ? Overview For Developer

Crystal Reports For Microsoft Great Plains ? Overview For Developer

Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market. It serves the whole of vertical and horizontal market: most of the industries and company sizes. Crystal Reports on the other hand is the leader in the reporting software industry and Microsoft is willing to use Crystal as main reporting tool for Great Plains, Solomon, Microsoft CRM, .Net platform, etc.

If you are developer who is asked: how do we extend Great Plains ReportWriter with somewhat more sophisticated ? read this and you will have the clues on where to look further.

Great Plains Tables Structure ? first of all you need to know the tables to link. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ? it should be RM00101 ? customer master file. If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc.

Create ODBC connection to GP Company database. Use the same technique as when you create standard ODBC connection for GP workstation ? but change default database to targeted company database.

Consider SQL Views ? if you don't want complex links in Crystal Report itself or if you need unionization from several companies ? SQL view is the answer.

Consider SQL Stored Procedures. Sometimes you can not pull the data in one view ? you need temporary tables to be created and the final query should be based on these temp tables ? this is when you need stored procedure.

Call Crystal Report from GP Screens via VBA/Modifier ? if the user wants to call Crystal report for example - printing Invoices in GP and do it from SOP Entry window ? you can use Modifier and VBA to call Crystal Reports engine.

Create SQL Query to probe the data ? we always recommend tuning your query and see that you are getting adequate results ? in any case ? Crystal Report is just a nice tool to show the results of your query.

Happy customizing, querying and designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

Computers Software | Computers Web Design | Computers Web Development | Computers Web Hosting

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |

Enterprise Resource Planning Overview
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief history of ERP, Why is it necessary, Market Leaders and the future of ERP.What is ERP?Enterprise Resource Planning or ERP is an industry term for integrated, multi-module application software packages that are designed to serve and support multiple business functions. An ERP system can include software for manu...(related: Software)

Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry Center ? Overview
Microsoft Business Solutions Great Plains has substantial market share and strong support by Microsoft on the US market. Currently we see the trend in the vertical markets when companies with custom-built accounting application, usually written on legacy platform are switching to standard and proven ERP solution and customize or tailor it to fit their vertical market requirements. We'll be publishing series of vertical articles: Logistics, Distribution Ce...(related: Software)

Microsoft Great Plains Upgrade ? Version 8.0 Overview For It Director/controller

If you have Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customizations, ctree/Pervasive migration to MS SQL/MSDE. As of right now it is reasonable to upgrade to Microsoft Great Plains 8.0

Is upgrade required? Not actually, but you have to consider the...(related: Software)

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights
Microsoft Great Plains serves the wide spectrum of horizontal markets. Great Plains could be considered as ERP platform, which you could expand with third party modules or advance with your own in-house custom functionality. The ...(related: Software)

How To Get The Best Accounting Software For Your Small Business
Buying accounting software is a major investment. It's an important decision and you need to be sure of all the facts before you buy.You certainly wouldn't want to get accounting software and then find a few months later that the software can't handle your growing business.You also don't want to be fooled into buying low priced software and then finding out that you have to make multiple upgrades to get it to the level you need to effectively run your business.And worst of all you don't want to get software with little or no support.Our research lead us to a website that has compared some of the most popular small business accountin...(related: Software)

Microsoft Great Plains Version 8.5: Upgrade, Customization, Vba, Crystal Reports - Highlights
Microsoft Great Plains is one of the Microsoft Business Solutions family ERP products: Great Plains, Navision, Axapta, Solomon, Small Business Manager. MBS also has Microsoft CRM - Client Relation Management software and Microsoft Retail Management System (Microsoft RMS)Microsoft Great Plains 8.5 is scheduled to be released in the second quarter of 2005. It is usual practice when you here announcements and then you are notified about software release delays. Expect first the version to be released for US market and then you can expec...(related: Software)

Os 101: Suggestions For Choosing An Operating System
An operating system (abbreviated OS) is essentially the path through which a computer accesses files, games, the Internet, and all vital stored information. The OS is the most important program on a computer because it runs all of the other programs. The major operating systems are Microsoft Windows, Mac OS X, Linux, and Unix. The operating system is essential to the computer, and so extreme ca...(related: Software)

Create A Flash Presentation For Free With Open Office
The intentions of this short tutorial are not to teach you how to use Open Office, but rather to show you a quick and dirty way to create presentations and tutorials that can be exported as a Macromedai Flash file.What is Open Office? It is a free, open source, c...(related: Software)