Reporting,for,Microsoft,Dynami computer Reporting for Microsoft Dynamics GP, SL, NAV, CRM notes
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
If your Microsoft Dynamics reporting requirements go beyondFinancial Statements and you cannot find out-of-the-box report, then you shouldthink about typical managerial reporting tool: Crystal Reports, Microsoft SQLServer Reporting Services, Microsoft Access Reporting, MS Excel or even MS SQLServer Query, saved to the text file and opened in Excel. Lets come through highlights:1. MicrosoftCRM. Especially for version 4.0, whichis current, you should consider creating reports in Report Wizard in SSRS orMicrosoft SQL Server Reporting Services. Wizard gives you pretty good start and then if you need additional logicto be introduced, and if you are Visual Studio .Net developer feel free toimport newly created reporting into MS VS reporting project and work on itsperfection. If you do not haveprogramming expertise in-house, you can consider creating SQL Stored Procedureor SQL View in specially created custom SQL Server DB (please do not createcustom objects in your MS CRM company database) and base Crystal Reports onthese procedures and views. Here, againyou need to know that SSRS is more flexible to be deployed on WWW versus CR (SSRSlicense is virtually free for existing MS SQL Server purchase) 2. GreatPlains Dynamics GP. Here, you shouldreview set of available ReportWriter reports (in Dynamics GP Reports section),then look at SSRS reports (here you will need to install them from GP CD #2 andwe recommend them if you are on Dynamics GP version 10.0). Then, if your goals are not achieved, pleaseconsider CR. Good tactic is to createMicrosoft SQL Server stored procedure or view and use them as the base for yourCrystal Reports 3. DynamicsSL or Solomon. Here you are in verysimilar to Great Plains situation. Ifyou are not happy with existing reports, feel free to create new custom reportsin Crystal 4. NavisionDynamics NAV. Navision is a bitdifferent, as its design is coming from C/Side shell. If you are still on native Navision C/Sidedatabase, you are likely working with C/ODBC module, if you moved to NAV onMicrosoft SQL Server 2000 or 2005, then you should know that Navision companiesare hosted in single MS SQL Server Database and each Navision table in thisdatabase has company ID prefix. Werecommend you to resolve Navision reporting in MS SQL Server View or StoredProcedure and then pull the results in Crystal or SSRS
Reporting,for,Microsoft,Dynami