Sorting date fields in SSRS reports in CRM Online

Key Technologies: SQL Server Reporting Services

Note: This article assumes experience on SQL Server Reporting Services for developing reports

For creating SSRS reports with CRM Online please refer the following article

http://www.cloudfronts.com/how-to-create-a-custom-report-in-microsoft-dynamics-crm-online-2/

 1. Create a new report in SSRS. Configure data source and credentials.

 Click to Enlarge

2. Add dataset and design a new table with required columns.

 Click to Enlarge

3. Right click on “startdatetime” textbox and select Textbox properties. Select Interactive sort and select “Startdatetime” from dropdown

 Click to Enlarge

Values are sorted alphabetically, all digits with 1 then 2,3,4,5…

Click to Enlarge

As seen above, after applying interactive sort , dates are ordered incorrectly.

For instance, from bottom up after 1st June,  10th – 19th June is displayed and then 3rd to 7 th june.
4. Now change the sort field expression to
DateDiff(“d”,DateValue(Fields!startdate.Value),Today())

Click to Enlarge

Dates are sorted in correct order from 1st to 19th .
By default dates are sorted in descending order, most recent first.
Apply the same expression on all date fields

To get more information about dynamics crm consulting visit – http://www.cloudfronts.com/microsoft-dynamics-crm-consulting.html

Corporate Office Address:
CloudFronts Technologies LLP
T-5 Satyam Business Centre, A Wing.
M.G.Road, Ghatkopar E.
Mumbai 400077, INDIA
Phone: +91 92 2358 3878

USA Partner:
Deven Tech Corporation
50 Glenn Oaks Ct
Old Bridge , NJ 08857