Microsoft Service Solutions – Excellent Plains is created to satisfy and also expand the demands of small and also mid-size organizations for its company success. Its detailed audit as well as service monitoring applications also offer businesses with abilities to personalize numerous modules of the Great Plains software application to fit to their certain requirements. Because of these capacities, Great Plains has actually been targeted to the entire range of both straight and upright clients.
A number of industry-specific applications integrate well with Fantastic Levels. This enables more adaptability and also unequaled access to info that help in decision-making as well as analysis of efficiency.
Crystal Reports is a report-writing software program that can incorporate itself to Great Plains’ data source. It exceeds the report production process of Great Plains’ own Record Writer. As a developer, Crystal Reports will help your customer accessibility decision-driving details to aid in handling their companies better. So, just how do we make use of Crystal Reports to expand Great Plains Report Writer?
Great Plains Table Structure
When a service entity is processed, the info is composed onto the Great Plains data source tables. This can be found by introducing Great Levels, after that: Tools > Source Summary > Tables. Find the appropriate Table:
RM00101 – Client Master Data
SOP30200 – Sales Background Header Data
Create ODBC Connection
Open Database Connection (ODBC) is an integration device to attach a customer application to an ODBC-compliant data source. It permits trading details among data sources and also conveniently incorporates with a wide variety of existing systems. Great Plains makes use of the ODBC drivers mounted by Microsoft SQL Web Server.
To create an ODBC link to an Excellent Levels company database, one typical way is with the use of the Information Resource dialog box. It triggers you to attach to the proper information resource. Select the company data source that you are targeting which contains the data required for your Crystal News report generation.
Microsoft SQL Server has an online table that you can access to reduce the intricacy of taking a look at links in Crystal News itself. By referencing the sight name in a Transact-SQL statement, an individual can access this online table and get the information for future choice to be used right into Crystal Information.
SQL Stored Procedures
There are instances in which you will not have the ability to draw all your needed data into one sight. In this circumstance, you would certainly need an SQL stored-procedure – defined en masse of Transact-SQL statements compiled into a single execution plan. With the help of a stored procedure, you do not need to access private tables to make use of in Crystal Information.
Calling Crystal Information through VBA/Modifier
It is feasible to call the Crystal Reports engine from one Great Plains application to do a process with the use of Modifier as well as VBA. For example, you want to print a Crystal News billing in Great Plains from the Sales Order Processing home window, utilize Modifier and also VBA to call the Crystal News engine.
Utilizing SQL Query Analyzer can assist in seeing to it you are getting sufficient lead to your report generation. In addition, it debugs stored procedures and also question efficiency issues. It can additionally copy existing data source objects and also situate, see or collaborate with these objects within the database.