Search code examples
devexpressexpressioncalculated-fieldxtrareport

How to get name month in calculated field xtrareport

I'm building a report using xtraReport but I have a problem. I want to get the name of the month using calculated field I did this but I can't get it.

FormatString('{0:MMMM}',GetMonth([MYDATE]))

The result is MMMM, I'll really apreciate your help, thanks in advance.

Solution

  • I think this is how you want to accomplish your task:

    enter image description here

    Just click on the glyph for your report control, assign the property to the Expression field and make the format string {0:MMM}.

    To give you some confidence that this works, here is when I ran it with today's date:

    enter image description here

    If you are a purist, here is the code behind:

    this.xrLabel2.TextFormatString = "{0:MMM}";