https://bugs.freedesktop.org/show_bug.cgi?id=47473
--- Comment #5 from Ian~G <grayl...@orange.net> 2012-06-02 03:58:38 PDT --- Created attachment 62417 --> https://bugs.freedesktop.org/attachment.cgi?id=62417 test odb file showing legacy and new report failures and workarounds I couldn't give you a copy of our actual database (sensitive data) but I found an old test file lurking in the depths of my hard drive and modded it to suit. This is just a simple hsql db (no MySQL involved) version which illustrates the problems clearly. File was produced on OO 3.2.1 and opened in LO 3.5.4 then modified. Four reports: 1Query_Students_Legacy_3.2.1 This doesn't run in LO 3.5 as there is no hidden control field 'Sorting' in the report. 2Query_Students_add_hidden_control_Sorting This is a copy of the above report with the hidden control 'Sorting' added. It now runs, as do all my legacy reports once this control has been added. 3Query_Students-New_Report_3.5.4 This is a report based on the same original Query and created in LO 3.5.4 It does not run because the hidden control 'Command' is empty and thus there is no command to run the report. 4Query_students-New_report_3.5.4_add_command This is a copy of the above item 3 with the sql command from the original query pasted in to the hidden 'Command' control. It now runs properly. Also note in the new reports that the templates are still a bit messy. For example the second page defaults to letter size despite this being an en-GB version. The original legacy reports don't show this problem because I bodged the templates to get them to work the way I wanted on my old system. Thanks for your help. One day very soon there will be a useable version of LO. It's nice to see it happening. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs