group by YEAR MONTH

[newyork66]

I have a date field, it's format in DB like this 'mm/dd/yyyy'. How do I group by by YEAR -Month in Report Studio?

[rockytopmark]

You should create a calculation that is returning just the month and year, from your date item. 

Use the Extract(datePart, [dateItem]) function to get the pieces and then concatenate them together, in a format you desire.

Then Use that calculated Year-Month item in the report and group on it.

[newyork66]

Thank you! It works! :D