Microsoft Great Plains is foremost account / ERP candidature from Microsoft Business Solutions, targeted to the US activity. It serves the full of vertical and horizontal market: supreme of the industries and institution sizes. Crystal Reports on the otherwise mitt is the soul in the coverage software system industry and Microsoft is ready to use Crystal as chief television journalism utensil for Great Plains, Solomon, Microsoft CRM, .Net platform, etc.
If you are creator who is asked: how do we broaden Great Plains ReportWriter near to some extent more developed - publication this and you will have the clues on wherever to exterior further.
- Great Plains Tables Structure - premiere of all you requirement to cognise the tables to cooperation. Launch Great Plains and go to Tools->Resource Description->Tables. Find the tabular array in the seemly cycle. If you are looking for the trade - it should be RM00101 - patron creative person directory. If you want humanistic discipline Sales Order Processing documents - they are in SOP30200 - Sales History Header file, etc.
- Create ODBC relation to GP Company database. Use the self method as once you generate stock ODBC connection for GP workstation - but transfer non-attendance information to targeted people information.
- Consider SQL Views - if you don't privation thorny golf course in Crystal Report itself or if you involve establishment from individual companies - SQL belief is the response.
- Consider SQL Stored Procedures. Sometimes you can not actuation the facts in one view - you want improvised tables to be created and the critical question should be supported on these worker tables - this is once you inevitability hold on course.
- Call Crystal Report from GP Screens via VBA/Modifier - if the individual wishes to name Crystal word for archetype - printing Invoices in GP and do it from SOP Entry window - you can use Modifier and VBA to call Crystal Reports motor.
- Create SQL Query to investigation the data - we always suggest calibration your inquiry and see that you are feat equal to results - in any suitcase - Crystal Report is fair a nice bradawl to spectacular the grades of your query.
Happy customizing, querying and designing! If you privation us to do the job - tender us a telephone call 1-866-528-0577!