How to display date instead of dateTime when printing a report?

(1) Share

Report

Posted on by atajjo

509

Good day everyone,

I'm developing a report that uses an RDP with two date parameters.

when the date parameters are displayed in the report using auto design, they are formatted as dateTime instead of date, which can mislead the user and confuse them.

Is there a way to remove the time portion of the date?

I have the same question (0)

All responses (5)

Answers (3)

atajjo 509 on at

Like (0)

Report

RE: How to display date instead of dateTime when printing a report?

Thank you Will, I'll do just that.

Was this reply helpful? Yes No
Verified answer

WillWU 22,359 on at

Like (1)

Report

RE: How to display date instead of dateTime when printing a report?

Hi Abdullah T

Yes, an auto design works well for that quick report solution when you need to mainly get some data out fast and the users aren't too picky on how it looks.

In your case , you need to use precision design.

Was this reply helpful? Yes No
atajjo 509 on at

Like (0)

Report

RE: How to display date instead of dateTime when printing a report?

I'm using an auto design though, and if I understand correctly, I have to create a precision design to add this formatting, right?

Was this reply helpful? Yes No
Verified answer

WillWU 22,359 on at

Like (1)

Report

RE: How to display date instead of dateTime when printing a report?

Hi Abdullah T,

Please use following expression in the textbox of the date field.

=format(Parameters!Dataset1_AsPerDate.Value,"dd/MM/yyyy")

Refer to:

daxture.blogspot.com/.../format-date-in-ssrs-report.html

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report
RE: How to display date instead of dateTime when printing a report?

Hi Abdullah,

Have you tried to format the values using this?

=format(Parameters!Dataset1_FromDate.Value,"dd/MM/yyyy")

Was this reply helpful? Yes No