page1
Report-Builder: Groups don't work, when a date should be grouped by Mont or Year
Here is a report created with the content of a table. On the left you see the fields of the table in the “Add field”-window.
The report should be grouped by “Date”. The special grouping is, that it should be grouped by the “Month” of “Date”.
When executing the report a popup appears: An error occurred while creating the report.
The details of this error show the wrong SQL-code the Report-Builder had created: [SELECT * FROM “Bill” ORDER BY “MONTH_Date”]
The right code should be:
[SELECT * FROM “Bill” ORDER BY MONTH(“Date”)]