GAHZLY

Microsoft Dynamics GP, or former ERP name is Great Plains Software Dynamics / eEnterprise gives you, programmer or software developer vide spectrum of report design tools : Crystal Reports, Microsoft SQL Server Reporting Services, GP ReportWriter, MS Access, MS Excel to name some of the popular. In this small technical paper we would like to introduce you into Crystal Reports design for Dynamics GP, assuming that you are new to GP and need some starting help. We also assume here, that you are on MS SQL Server Database: GP 10.0, 9.0 and 8.0, if you are on GP 7.5 and earlier: 7.0, 6.0, 5.5, 5.0 or 4.0 where Great Plains was available on Ctree or Pervasive SQL/Btrieve, please review database connection options, described in our earlier articles – you will need to install Ctree/Faircom or Pervasive ODBC drivers. Let’s come back to Crystal for GP on MS SQL Server: 1. Tables specifications. You can install Dynamics GP SDK from CD #2, however for quick and reasonably detail referen...

Microsoft SQL Server is the leader for inexpensive and middle size SQL solutions. Plus it is now capable to serve large enterprise on Microsoft Windows platform. Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. Sometimes developers try to use Crystal directly to pull data from multiple database platforms – we understand the need to give you additional tips to increase Crystal report flexibility. Also common case when Crystal report should pull data from multiple database platforms. Assuming that you are creating Crystal Reports on Windows platform – we recommend you to use Microsoft SQL Server as a database access tool. 1. Use Crystal when you have your query tuned – regardless how good Crystal Reports is – it is reporting tool – not querying environment. Tune your query first and be sure tha...

Writing a report can be one of the most difficult writing tasks we face, whether it’s for work or at school. In my various professional incarnations over the years, as bureaucrat, administrator and private consultant, I have been required to write literally (no pun intended) hundreds of reports of just about every description you can imagine. In fact, when I did my MBA in the mid-1990s it was like a total immersion course in report writing; they seemed to be never ending. So, to help people with their report writing I have put together a few tips that I have picked up over the years. People often cringe at the thought of writing a “business report”. Granted, these are somewhat more complicated than business letters, but if approached in the right way, writing a business report can be a straightforward and reasonably painless process. There are a number of different generic types of business reports including: general business report, business plan, business proposal, ...