O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Formatting expression

The format of the data is very important for the design and clarity of the report. All the values must be expressed in their proper format.

The date value in our current report is showing as M/D/YYYY 12:00:00AM. We may want to get rid of the time in our date; unless, of course, time is required in our report.

  1. Right-click on the [Date] cell and select Expression… to display the Expression Builder dialog box:
    Formatting expression
  2. The default expression for the Date is Fields!Date.Value. Change that to:
    =FormatDateTime(Fields!Date.Value,DateFormat.ShortDate)
    

    The FormatDateTime function, with its argument DateFormat.ShortDate, converts our date to short ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required