Created attachment 79792 [details] Attached is a screenshot showing the 'dummy' data. Problem description: I am having an issue with the report builder. This issue is not isolated to a particular database file, and it can be reproduced quickly by creating a small test database. When I make a report based on a table with sort conditions, the data is never populated in the final result. Please note, if you follow these steps but do not add any fields to be sorted, the report will display as expected. To my knowledge, it is only when a sort condition is added to a report based on a table that this bug occurs. Steps to reproduce: 1. Start LibreOffice Base 2. Ensure that 'Create a new database' is selected in the 'What do you want to do?' section. 3. Click Next. 4. Select 'No, do not register the database'. 5. Click Finish. 6. Click 'Create Table in Design View' in the Tasks area. 7. Enter 'Name' in the 'Field Name' field. 8. Click Save. 9. Click OK. 10. Click Yes. 11. Close the Table Design window. 12. Double click 'Table 1' to open the table. 13. Enter some data so the report will have something to display. I entered 0, Tyler; 1, Greg; 2, Emily 14. Click Reports on the left side of the screen. 15. Click 'Use Wizard to Create Report'. 16. Click the '>>' button to move both fields of the table into the report. 17. Click Next. 18. Click Next. 19. Click Next. 20. Under the 'Sort By' section, select 'Name'. 21. Click Next. 22. Click Next. 23. Click Finish. Current behavior: The report opens with 'dummy' data. Expected behavior: The report opens and displays the data entered into the table in step 13 ordered by Name. Operating System: Ubuntu Version: 4.0.2.2 release
The screenshot doesn't show the Report-Builder. It's the old report-engine. You could only use this engine, when the Report-Builder isn't installed. See https://bugs.freedesktop.org/show_bug.cgi?id=58911 .
You're absolutely right. I did not even know there was a difference between the two. I just installed LibreOffice using the Software Center, and that was the default functionality when a report is created in Base. There was another package in the software center that contained the actual report builder, and it works as intended. I just did not know to go out and look for and install that package as well. As information, this was a fresh install of the latest version of Ubuntu, 13.04. It comes with most of the LibreOffice suite installed, but not Base. I opened up the Software Center, and I installed Base. Those were the steps I took to get a version of Base running on my machine using the older report engine.
I have just tested with OpenSUSE 12.3 32bit rpm and LO 4.0.3.3. Have uninstalled the Report-Builder and started the old wizard. Sorting an grouping doesn't work. I only get data in the report, when I won't sort or group the data. Otherwise there appears only the default text. Would be the same bug as https://bugs.freedesktop.org/show_bug.cgi?id=65047 .
*** Bug 65047 has been marked as a duplicate of this bug. ***
This bug first appears in LO 4.0.* - could be in a version before the release-version. I will test.
I have downloaded the first LO 4.0-version I could get. The same error as described appears in LO 4.0.0.0 beta 1. The report is created in the right way in LO 3.6.6.2. See https://bugs.freedesktop.org/attachment.cgi?id=81695 for a testfile.
Is this the same bug as #47325? (presumably fixed over a year ago?)
This seems to happen only with reports based on a table, not based on a query. Work-around: create a query that just selects all field from the table (or just the necessary field), and base the report on that. It is not the same bug as bug 47325, although the symptoms are about the same :)
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=97d279b4c54951547b8c8f4bd29376bd6e111593 fdo#64985 try harder to populate m_sCommandName::m_sCommandName The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fix for libreffice-4-1 (to appear in 4.0.5) submitted for review on https://gerrit.libreoffice.org/4633
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b625356d1d36bd42dff24960066f63ab45bbb30b&h=libreoffice-4-1 fdo#64985 try harder to populate m_sCommandName::m_sCommandName It will be available in LibreOffice 4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I have tested it on Libreoffice 4.1, no problem whatsoever. Thanks a lot.