When you create a client report definition (RDLC) layout for a report, you must modify date values so that they are formatted correctly. Use the following procedure to verify or change the format of a date.

Before you begin this procedure, you must create a layout suggestion for the report. For more information, see How to: Create a Layout Suggestion.

To format date values

  1. In the Classic client, on the Tools menu, click Object Designer.

  2. In Object Designer, click Report, select a report that you want to modify, and then click Design.

  3. On the View menu, click Sections.

  4. Right-click the text box that displays a date, and then click Properties.

  5. In the Properties window, in the SourceExpr field, change the date value to FORMAT(<date value>).

  6. In the Properties window, in the Caption field, enter the value for the caption of the variable.

  7. On the File menu, click Save.

  8. In the Save window, select the Compiled check box, and then click OK.

See Also