Showing day name and month name in ssrs

reporting-services ssrs-2008-r2 ssrs-2012
Alias Varghese picture Alias Varghese · Apr 29, 2015 · Viewed 16.5k times · Source

I am having a date example 4/29/2015 . I need to change the format of date like "Wednesday,april 29,2015. How to achieve this using SSRS.?

Answer

Mahmoud Gamal picture Mahmoud Gamal · Apr 29, 2015

Assuming that your date field is of data type date or datetime (otherwise you will need a cast in your sql query), this is how you can do it:

  • Right click the textbox where your datetime is displayed and choose textbox properties:

enter image description here

  • From the left panel choose Number, then date and choose the desired format:

enter image description here

  • Then you should see the date displayed as:

enter image description here

Related questions

How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
Vertical merge in SSRS Tablix

Is there any chance to do vertical merge of fields in tablix? I am working few years on SSRS, but only saw horizontal merge of cells, vertical not.

Read More
Sub report could not be shown. Sub report works separately - Not with Main Report

I've one main report with 5 sub reports. Sub report contains more than 10 parameters. (With 10 Multi valued parameters - So I've used Join method to pass value from Main report to Sub Report) I've also tested Sub report separately and it …

Read More