And even this grizzled old Crystal guy has begun to like many of the aspects of the SSRS report designer tool. We are seeing much more interest and commitment to the SSRS reporting environment from many of our customers, across a variety of business applications. And that trend will continue to accelerate. Being a Microsoft solution, it is the direction that Microsoft is heading for all its business application needs, as they have already incorporated it into the Dynamics GP product. It comes with the Microsoft SQL Server database so you do not have to pay any extra (unless you need extra SQL licenses for your report development users). Having been an avid user of Crystal for many years (and a former Crystal Partner and Trainer), I feel it still represents the ultimate in reporting flexibility and power.īut Microsoft’s SQL Server Reporting Services has been gaining on Crystal Reports in many ways over the past few years. It offers the most powerful features of any report writer. And most existing standard reports and forms are created with GP’s Report Writer - which in all honesty is not an exceptionally easy to use or powerful tool.īut if you have some fairly advanced reporting needs including some complex grouping, sub-totaling, specific formatting and other "beyond-the-basics" needs, then you are really looking at two alternatives: Crystal Reports and SQL Reporting Services (SSRS).Ĭrystal Reports has been the king of the reporting hill for some time. Dynamics GP Smartlists provide easy access to data in list form that can quickly exported to Excel. For example, FRx is the reporting tool for generating traditional structured financial statements such as Profit and Loss Statements or Balance Sheets. Depending on your specific needs there is usually an appropriate tool. With Dynamics GP, you have a number of options when it comes to generating reports.
Architecture, Engineering and Construction (AEC).International Microsoft Dynamics Partners.National Microsoft Dynamics ERP Partners.Regional Microsoft Dynamics ERP Partners.