Description: Report builder fails to switch from step #1 to #2 with certain aggregation queries. Steps to Reproduce: 1.Open the attached database with embedded Firebird. 2. Right-Click query icon "qAggregateV" or "Total_Months" and choose "Report wizard...". 3. In the first step of the wizard click >> to choose all columns and click "Next". Actual Results: The dialog fails to initialize the next step. It does not freeze. It simply stalls. Expected Results: Selected fields are drawn into the document and step #2 (grouping) is initialized. Reproducible: Always User Profile Reset: Yes Additional Info: I don't think, it's the same as #158905 which describes another symptom. I observe this since 24.2. Certain valid queries make the report builder fail. In the attached demo database, two queries "qAggregateV" and "Total_Months" are affected. I have a HSQL version of that database which I tested on Windows and Linux with the same results. "Direct SQL mode" makes no difference. I can manually create working reports from both queries.
Created attachment 194054 [details] Base document with embedded Firebird DB
Reproducible Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7a895ec4205659038aa95941b65715fed1a3e7be CPU threads: 16; OS: Windows 11 (10.0 build 22631); UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded and Version: 7.6.6.3 (X86_64) / LibreOffice Community Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded Last working for me Version: 7.5.9.2 (X86_64) / LibreOffice Community Build ID: cdeefe45c17511d326101eed8008ac4092f278a9 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
Hi, after pressing 5 times the Next button, next step appear Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: CL threaded
(In reply to mc from comment #3) > Hi, after pressing 5 times the Next button, next step appear > > > Version: 24.2.3.2 (X86_64) / LibreOffice Community > Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba > CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: > win > Locale: it-IT (it_IT); UI: it-IT > Calc: CL threaded For me, it jumps to the last step without filling any controls into the document.
This seems to have begun at the below commit in bibisect repository/OS linux-64-24.2. Adding Cc: to Henry Castro ; Could you possibly take a look at this one? Thanks 482ec9154b07af28171cc9fb83a6577d94b94e66 is the first bad commit commit 482ec9154b07af28171cc9fb83a6577d94b94e66 Author: Jenkins Build User <tdf@pollux.tdf> Date: Fri Sep 1 19:19:40 2023 +0200 source 50f36b75cee6591a00102c6e9fa71ba91df5bbd8 156422: connectivity: fix return column type "DataType::SQLNULL" | https://gerrit.libreoffice.org/c/core/+/156422
Thanks, I will check it