Category Archives: SSRS

Local DateTime CRM Online SSRS Report

Local DateTime in UK could get a bit tricky because of the summer time, where it is one hour less in UTC time.  This post will help you to find out the local Date.

There is a simple solution for this: Use the date only field from the dataset. When the CRM date attribute (e.g. “MyDate”) is declared in the Fetch XML query of your dataset, you get two SSRS fields in that dataset: MyDate and MyDateValue. The first one is a date only field in local time, so you can do something like Fields!MyDate.Value. The second one is a datetime field in UTC time. You are probably interested in the first one 😉

If you also want to force a UK time format, you can use the next expression:

=iif(IsNothing(Fields!MyDate.Value),

Nothing,

CDate(iif(IsNothing(Fields!MyDate.Value), 1, Mid(Fields!MyDate.Value, 4, 2)) &

“/” & iif(IsNothing(Fields!MyDate.Value), 1, Mid(Fields!MyDate.Value, 1, 2)) & “/” & iif(IsNothing(Fields!MyDate.Value), 1, Mid(Fields!MyDate.Value, 7, 4))))

Just to say thanks to my colleague Mario (@mtcantero // http://crmandcoffee.wordpress.com/) for his input in this article.

I have read “Microsoft Dynamics CRM 2011 Reporting”

Reporting is already a fundamental pillar for many companies and senior management. It brings the ability to understand key factors of the business such as the volume of opportunities, revenue and performance. The book Microsoft Dynamics CRM 2011 Reporting is a useful technical guide which delivers a simple and clear overview of the available reporting options within the platform Microsoft Dynamics CRM.

Microsoft Dynamics CRM is a flexible business solution based on SQL server that provides different and several reporting capabilities. Business users can create their own reports without real technical knowledge. At the same time, more complex designs can be implemented by developers or technical administrators using known Microsoft tools like Visual Studio or Report Builder. The author of the book, an experienced Microsoft MVP, have captured all this reporting functionality within the same.

The book follows an intuitive structure, explaining how to create simple reports using the Report Wizard of Dynamics CRM and covering basics technical aspects like SQL and Fetch XML. Gradually, it introduces more complex implementations using SQL Server Reporting Services, integration with web resources and generation of reports using other technologies such as ASP.NET or Silverlight. Finally, the book offers a couple of interesting chapters related to Failure Recovery, Best Practises and Mobile reporting, which are very important aspects for enterprise implementations.

Other basic reporting features like Charts and Dashboard are also mentioned in the book. However, a topic which is not included in the book is the Export to Excel feature. With Dynamics CRM, users have the ability to create custom views and queries that can be exported to Excel. This is a very useful functionality, especially considering that many users are already familiar with Excel and its report capabilities.

Personally I have enjoyed reading Microsoft Dynamics CRM 2011 Reporting. It is a helpful reference I would recommend for new Dynamics CRM users and developers. It contains many images and screenshots that make very easy to understand and follow Damian Sinay’s explanations.