Search code examples
sqlsql-serverreporting-servicesssrs-2008ssrs-2008-r2

How to format a number in SSRS Report for Matrix?


I am formatting a number which is Date and I want to display only day and month part (e.g. Jan 1, Jan 2, Jan 3, Jan 4…) of this but it is not formatting and displaying the complete date.

Whereas If I use the same wizard with tabular then it is working fine.

I am using wizard to format data enter image description here

Is there any other way to format data while working with matrix ?


Solution

  • Try right clicking on the field in your SSRS report and using an expression for it instead.

    enter image description here