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)

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Copy link

Link copied!
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
Verified answer

WillWU 22,363 on at

Like (1)

Report
Copy link

Link copied!

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
atajjo 509 on at

Like (0)

Report
Copy link

Link copied!

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,363 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Thank you Will, I'll do just that.

Was this reply helpful? Yes No