I have a table of sales data.
With a date field named “sales date”
In a simple report, I want to group by Month.
And in a month header, I want to print the full name of the Month using MONTH_TEXT()
I can’t get either of these to work.
1)
To Group: you have to enter a group condition.
My condition needs to be MONTH(sales.sales date).
It will allow the field itself, but not when I use the MONTH_TEXT function.
We obviously do not want to break on the actual sales date field because then it would group each day, and I only want one group for all the transactions in the month.
2) Month heading band
I wanted to subtitle each month of sales and I want the group in it’s heading band to say the name of the month.
Trying to use the function, also crapped out here.
It complains with an integrity error, but it will save it fine. It will show server output log errors at run time that Month and Monthname were unrecognized.
One solution would be to create an additional field and have a formula always set it to be the name of the month in text format.
But I don’t think I should have to do this unless this is a known limitation of using functions in the report writer.
