Apache OpenOffice (AOO) Bugzilla – Issue 44414
Database Report contains invalid data
Last modified: 2006-05-31 14:29:06 UTC
Steps to follow: 1. Create a new Database document 2. Create a table and save it with no data. 3. Create a report with the wizard, adding all fields, default layout, default sort, and save it, since there is no data in the table yet. 4. Add a few records to the table. 5. Open the report, and it will contain placeholder text and numbers for each field and record, but not the actual data. Displays latin text. 6. Edit the report, and there are no fields from the database in it, even with View->Field Names turned on.
confirming. For reports which are based on an empty result set, the report is empty, not even the column headers are show, which is not too much ...
Your comments do not reflect the issue I filed. I saw what you did, but that was not my concern. The problem is that after adding records to the table, the report did not show the data from the table, rather, it used the "latin" and random numbers to fill the fields, as it might in showing a sample layout in the wizard. There were no database fields in the report to be filled in with data. _This_ is the problem, not that the empty table produces an empty report. Can you please change the title of the issue back to reflect what I reported? Thanks, Matt
Returning to this issue, I see it works this time. However, only because I now have data in the table. I will try again later to reproduce same problem.
Sorry for the misunderstanding, I supposed you described the bug which I also saw. Changing things back. The status now, as far as I tried, is "cannot reproduce" :)
I seem to have this same problem (WinXP/SP2, Oo1.9.97). I created a database (using the builtin database facilities), and a table in that database, and 3 records in the table. I then created a report via the wizard, specifying the fields, grouping, sorting, etc. and saved it as dynamic, but I only see the Latin placeholder data and my column headings. I can't ever get the report to contain any of my actual data. Am I missing something simple/obvious?
Sorry; that should have been 1.9.79, not 1.9.97
I can confirm this behavior sometimes with OOo 1.9.93 on Windows 98 SE. I never had an empty table, though. I would only see the column headers and one row of dummy data whenever I opened my dynamic report, until just a minute ago. After probably five times of opening the report and revising it twice it finally generated the multiple rows of the current data. All I can say for a workaround is to either create a static report or to save changes to the dynamic report when asked and fiddle around with it.... The priority needs to be bumped up to 3 and the Summary should be changed to "Dynamic database report displays dummy data."
@ wbfarrell: The m79 is pretty old, can you please test it again in a m109 version. @ jjr16: So you *can't* confirm this everytime. So what to do to reproduce this everytime?
Hi, no more info since some weeks. I close this issue now as INVALID. Feel free to reopen the issue, if you can provide more information how to reproduce this issue. Bye Marc
close