https://bugs.documentfoundation.org/show_bug.cgi?id=152331
Bug ID: 152331
Summary: LibreOffice Base - Autovalues not showing in report
Product: LibreOffice
Version: 7.4.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ro...@outlook.com
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
--
You are receiving this mail because:
You are the assignee for the bug.
