Monday, May 18, 2015

Format a date in SSRS report

After adding a Date parameter in contract class of SSRS report it starts showing in report's parameters node with Data type DateTime.























There is no option to make it either short date or format a date at parameter level. You can use following expression in report design where this parameter has been used in design, mostly in textbox.

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


Happy Daxur!ng

No comments:

Post a Comment

I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...