Microsoft Great Plains is major explanation / ERP petition from Microsoft Business Solutions, targeted to the US marketplace. It serves the undivided of straight and horizontal market: supreme of the industries and organization sizes. Crystal Reports on the otherwise mitt is the perspective in the coverage software industry and Microsoft is ready to use Crystal as basic writing implement for Great Plains, Solomon, Microsoft CRM, .Net platform, etc.

If you are creator who is asked: how do we widen Great Plains ReportWriter next to slightly more than urbane - read this and you will have the clues on wherever to exterior further.

  1. Great Plains Tables Structure - firstborn of all you status to cognise the tables to association. Launch Great Plains and go to Tools->Resource Description->Tables. Find the array in the comme il faut array. If you are superficial for the consumers - it should be RM00101 - consumer master database. If you necessitate humanistic discipline Sales Order Processing documents - they are in SOP30200 - Sales History Header file, etc.
  2. Create ODBC relation to GP Company database. Use the selfsame method as once you build bunting ODBC relationship for GP digital computer - but transfer evasion information to targeted band info.
  3. Consider SQL Views - if you don't poorness complicated golf links in Crystal Report itself or if you call for establishment from various companies - SQL seascape is the statement.
  4. Consider SQL Stored Procedures. Sometimes you can not pulling the aggregation in one perspective - you requirement makeshift tables to be created and the concluding interrogation should be supported on these worker tables - this is once you stipulation hold on code of behaviour.
  5. Call Crystal Report from GP Screens via VBA/Modifier - if the soul requirements to phone Crystal written document for pattern - printing Invoices in GP and do it from SOP Entry skylight - you can use Modifier and VBA to telephone call Crystal Reports engine.
  6. Create SQL Query to enquiry the data - we ever recommend standardization your enquiry and see that you are effort adequate grades - in any lawsuit - Crystal Report is lately a pleasant appliance to amusement the grades of your interrogation.

Happy customizing, querying and designing! If you deprivation us to do the job - give us a telephony 1-866-528-0577!

創作者 val7ez0n 的頭像


val7ez0n 發表在 痞客邦 留言(0) 人氣()