Software Information |
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
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Great Plains Customization Upgrade- Overview For CIO/IT Director Around the same time Microsoft made its move with .Net introduction and tried to gain portion of cheaper databases market: Pervasive SQL/Btrieve, Ctree/Faircom - and launched free MSDE database program. Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC) It is possible that if one avoided all sources of spyware, ad-ware and virus infection that infection would be at minimal levels. Although I don't recommend using only this method as a form of fighting spyware, it can be a potentially effective mean. Adware and Spyware What is 'adware'?Adware is basically software or scripts that are hidden on your computer, that make advertising show up all over the place. It may be an extra menu in your web browser, icons appearing on your desktop, bookmarks or favourites appearing out of no where, and pop up ads that seem to come from no where!What is 'spyware'?Spyware is similar in nature to adware, however I feel its purpose is slightly more sinister. Best Practices In Choosing Network Monitoring Software Blue Cross and Blue Shield of Hawaii (HMSA) found itself with a rapidly expanding network and data center. Our network devices, servers, and software were all growing in complexity and we knew that we would have to leverage technology to gain better control of our IT systems and network. A Simple Computer Software Definition What is Software?Software is a set of instruction written to interface between man and machine.Who writes this instructions?Programmers writes this instructions. Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon Bad News - the Threat is Bigger than it SeemedHow recently it was - when even many journalists thought that spyware gathers mostly information to be used for targeted advertising. Definitions like "spyware, a. Microsoft Great Plains Integrations - Retail Management Sample Microsoft Business Solutions is emerging as very attractive vendor for mid-size companies. The strength of its products is in their cross integration potential. Microsoft Great Plains Data Conversion - Overview For Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Examining the Substance of Studio MX To all web designers out there, this article is for you! I guess you already heard about Studio MX (I think so!) - the ideal bundle for professional web designers, bringing together Dreamweaver MX for page design, Flash MX for animation and interactivity, and Fireworks MX for editing and optimizing graphics. With all these components, it certainly provides professional functionality for every aspect of web development. Microsoft CRM Lotus Notes Domino Connector FAQ Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being two groupware products from competing software development leaders, however could coexist within one organization computer network and even work together in collaboration. There maybe multiple reason why corporation would use both products: licensing, commitment to IBM Lotus Notes as legacy product, risk balancing - staking on both Microsoft and Java/EJB/J2EE platforms, deploying Lotus advanced workflow to automate document management, etc. Beware of Spyware One day, you suddenly realize that your computer started to worknoticeably slower than it used to. You decide to run de-fragmentation of your hard drive and add more virtual memory to the system. IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM Midsize business or non-profit organization should decide if one-vendor solution would be appropriate and the associated risk acceptable. In our opinion, balancing the risk of one-vendor-approach is not economically feasible and should be avoided. Great Plains Customization - Programming Auto-apply in Accounts Receivable Microsoft Great Plains is one of three Microsoft Business Solutions mid-market ERP products: Great Plains, Solomon, Navision. Considering that Great Plains is now very good candidate for integration with POS application, such as Microsoft Retail Management System or RMS and Client Relation Systems, such as Microsoft CRM - there is common need in Great Plains customizations and integrations, especially on the level of MS SQL Server transact SQL queries and stored procedures. Free Microsoft Word Online Training Tutorial Resources Microsoft Word is one of the most popular office applications that provide many features such as word processing, web publishing and database creation. Tapping into these Word resources, however, is not always easy and straightforward, leaving users stumped and puzzled. Backing Up And Restoring Your MySQL Database If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software 1. What determines the software price? Is it Per Seat or Per User or Per Processor?The cost of software is determined in many ways. Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW - ReportWriter - Tips for Developer Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexterity. Dexterity in turn was built with conception of graphical cross-platform transferability (in time - 1992 - mostly Mac and MS Windows). Microsoft Great Plains on Ctree or Pervasive SQL - What to Do - Tips for IT Manager As you probably know, when Microsoft purchased Great Plains Software - the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence - via it's C-written engine Dexterity, based on the believe that C programming language is platform independent. Microsoft CRM or Siebel Siebel is traditional CRM market leader, however and mostly due to recession 200-2003, Siebel lost sizable portion of CRM market to new tiger, such as Microsoft CRM. Microsoft CRM s recent (2001) CRM answer from Microsoft and attempt top get market share from traditional vendors: Siebel, Oracle, Onyx. IBM Lotus Domino or Microsoft Exchange? IBM Lotus Domino or Microsoft Exchange?The severe competition continues for many years between two main leaders in collaboration solutions - IBM and Microsoft. Whether the choice of a platform influences the ordinary user? The both of software giants put efforts to improve working conveniences for end Internet users. |
home | site map | contact us |