Retail Resources

Date Sorting

Aug 05, 2014 — Ashia Coleman
date.png

Date_Sorting_1.png

Often, when displaying the Date Hierarchy in your Tablix, you will notice that it will order the dates incorrectly. To correct this, follow the following steps:

  1. Click inside table.
  2. Right-click on the date group (found at the bottom in either the row groups or column groups box -- see above photo).
  3. On the sorting tab, click the “fx” button (see below photo).
  4. Change the expression to this: =CInt(Fields!Day.Value)

Date_Sorting_2.png

If you have any questions about this feature or BI in general, please contact your Account Manager directly.

Click to edit your new post...

Topics: Business Intelligence

Recent News

Comments