I use LO 3.6.1 with Report Builder 1.2.3. When I run the report, I receive error "Column not found: MONTH_ ...". In this report I group data by month with LO option "Sorting and grouping...". In LO 3.5.6 the report run without any problems, but the problem appeared in LO 3.6.x. and next. Other information: State SQL: S1000 Error: Column not found: MONTH_Data sprzedaży in statement... Exception type: com.sun.star.lang.WrappedTargetException
Could you add an attachment to this report? When you open the report for editing and set the report to "Analyze SQL Command: No" - does the problem exist? What is the original name of the column in the table/query? What is the shown name, when you open the table/query?
> When you open the report for editing and set the report to "Analyze SQL > Command: No" - does the problem exist? No, when I set to "No", I can run the report. > What is the original name of the column in the table/query? What is the > shown name, when you open the table/query? The original name of query is "sprzedaz_programow". It based on four columns: sprzedaz, program, edycja and kontrahent. Full error message: Column not found: MONTH_Data sprzedaży in statement [SELECT "sprzedaz"."data" AS "Data sprzedaży", "program"."nazwa" AS "Nazwa programu", "edycja"."edycja" AS "Edycja", "edycja"."wersja" AS "Wersja", "sprzedaz"."ilosc" AS "Ilość", "sprzedaz"."cena" AS "Cena", "ilosc" * "cena" AS "Razem", "kontrahent"."nazwa" AS "Klient" FROM "sprzedaz" AS "sprzedaz", "kontrahent" AS "kontrahent", "edycja" AS "edycja", "program" AS "program" WHERE "sprzedaz"."id_kontrahent" = "kontrahent"."id_kontrahent" AND "sprzedaz"."id_edycja" = "edycja"."id_edycja" AND "edycja"."id_program" = "program"."id_program" ORDER BY "MONTH_Data sprzedaży", "Klient"] I will prepare an attachment. Thank you for your attention and comment.
I am setting status NEEDINFO because I think it unlikely that there will be any progress toward a fix without the promised attachment with the failing report. If the database in question is not embedded in the attachment, we also need the definition of the queried tables. Basically, we need to reduce to a minimum the number of choices to make on the way to reproducing the failure message. Terry.
(In reply to comment #2) > > I will prepare an attachment. Thank you for your attention and comment. 4 months ago - where is the attachment. We couldn't help, when there is no reaction. Robert
Created attachment 74506 [details] Shows a report, which should be grouped by Month with Report-Builder The internal function of grouping a report by the month of a date doesn't work with the Report-Builder. You could only group a report by month, when you first create a query, which should select the months of a date. The same problem with "year".
Created attachment 74507 [details] Description where to choose the grouping by month for a date in Report-Builder
I have made a few tests. The report of https://bugs.freedesktop.org/attachment.cgi?id=74506 works with LO 3.3.4; first version it didn't work is 3.4.0. Seems this bug was introduced with LO 3.4. So I set the version to the first version of LO 3.4 - 3.4.0 Beta1.
I have just tested it again with newer versions. Same error-message in all versions up to LO 4.0.* (last tested version LO 4.0.5.2). Works since 4.1.* (first tested version 4.1.0.0 beta2). So you could group now the reports with the new version, but not with the version, where bug-fixes would still be made for (LO 4.0 ) Should we close this bug or hold it open for a fix in LO 4.0?
Cannot reproduce with 4.2.0.alpha; assuming fixed.