Description: I'm using this version Libreoffice base 7.4.3.2(x64) on Windows 11 on a PC. I have setup a small base with the idea to create invoices with a customer table, invoice table and task table. I used the invoicing tamplate available in Base by using the wizard. I have set the auto value for the invoice numbers starting at 0. Then I have created a form to write the invoice and a report for print which involves queries, everything works fine untill I run a report where I use the field InvoiceID (autovalue) The field with autovalues doesn't appear in the report. The label is there but the Data Field shows as blank space. I can't find the solution and I'm totally new to DBases and have no clue about SQL. On top of that, the report builder keeps crashing LibreOffice and its window behaves weirdly. I have to hit windows+arrow up and down several times so the windows stabilize and let me edit. Sometimes it works other times it crashes. Steps to Reproduce: 1. Create tables with primary key as auto value, in my case, InvoiceID, CustomerID and TaskID 2. Add the primary keys to a query 3. Create a report that includes the auto values Actual Results: In the final document, I should be able to see a fat round zero besides the labels Invoice no., Customer no. and Task no....but nothing. The other values from the query show perfectly. I ran another report with CustomerID and TaskID auto value and its the same problem. it seems it's only autovalues that don't show. Besides, it looks like the autonumber is not counting. I entered data for two different invoices for the same customer, invoices no. 0 and no. 1, for $ 75 each, but instead of doing two different documents, it puts everything together in the same final document created on Write showing a total of $ 150. Expected Results: Just for it to work as a normal invoice data base. Reproducible: Always User Profile Reset: No Additional Info: You can see pictures in here https://ask.libreoffice.org/t/libreoffice-base-id-auto-increment-problem-printing-reports/52219/5
Created attachment 183928 [details] Pictures of the problem I really appreciate your help in fixing this. I'm not a developer nor a programmer, I just want to set up data bases to make my work easier. You, guys, do an incredible job with LibreOffice. I don't need to know all the steps you take to test and try, chances are I'm not going to understand a word. Just let me know if it was possible to fix the bug or when it's fixed.
Could you please add an example database here, which shows the problem? Shouldn't have critical data inside.
Seems you have a formatting problem there. '0' won't be shown by default in a field with numbers. Open the report for editing. Click on the field, which doesn't show '0'. Click on Properties → General → Formatting (button with 3 ponints) Set Format Code '0'. Now all '0' will be shown.
Created attachment 183936 [details] See report with PKs, which are '0' - formatting will solve problems with empty fields.
Does the problem still exist after setting format for the field? You could also write a private E-Mail to me to get it working. If will work well now we could close this bug.
Dear romtl, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear romtl, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp