[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
https://bugs.freedesktop.org/show_bug.cgi?id=47473 --- Comment #6 from Lionel Elie Mamane lio...@mamane.lu 2012-06-05 09:26:58 PDT --- Cannot reproduce with LibreOffice 3.5.2.2 Build ID: 281b639-6baa1d3-ef66a77-d866f25-f36d45f TDF binaries running on Debian GNU/Linux amd64. Double-click use wizard to create report click to add all fields next next next sort by: choose one next dynamic report create report now also tried dynamic report modify report now -- 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
[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
https://bugs.freedesktop.org/show_bug.cgi?id=47473 Tyler tyler8...@gmail.com changed: What|Removed |Added OS/Version|Linux (All) |Windows (All) --- Comment #7 from Tyler tyler8...@gmail.com 2012-06-05 09:43:58 PDT --- Lionel Elie Mamane, Thank you for looking into this problem. While this is my first comment, I need you to clarify. Did you try to make a report about a table or a query? I too have this problem, but only queries fail to load properly as Ian~G has described. Even in his post with the report examples, they were all reports based on queries according to his naming convention. Thank you again for looking into this for us. -Tyler -- 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
[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
https://bugs.freedesktop.org/show_bug.cgi?id=47473 Tyler tyler8...@gmail.com changed: What|Removed |Added OS/Version|Windows (All) |Linux (All) -- 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
[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
https://bugs.freedesktop.org/show_bug.cgi?id=47473 Lionel Elie Mamane lio...@mamane.lu changed: What|Removed |Added Platform|x86-64 (AMD64) |All OS/Version|Linux (All) |All Status|UNCONFIRMED |NEW Ever Confirmed|0 |1 --- Comment #8 from Lionel Elie Mamane lio...@mamane.lu 2012-06-05 09:51:25 PDT --- OK, confirmed / reproduced using a query (and not a table) as source for the report. -- 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
[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
https://bugs.freedesktop.org/show_bug.cgi?id=47473 Lionel Elie Mamane lio...@mamane.lu changed: What|Removed |Added Status|NEW |ASSIGNED AssignedTo|libreoffice-b...@lists.free |lio...@mamane.lu |desktop.org | --- Comment #11 from Lionel Elie Mamane lio...@mamane.lu 2012-06-05 13:16:05 PDT --- Blank command means (in LibO 3.5 and later) no hardcoded SQL, use the SQL from the query. This comes from the fix of i#98163. But the latter fix was done buggily, and the whole load data operation aborted with an (undisplayed...) error / exception. My patch fixes that load data operation aborted with an (undisplayed...) error / exception problem, and leaves the Command blank. -- 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
[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
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
[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
https://bugs.freedesktop.org/show_bug.cgi?id=47473 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #4 from Julien Nabet serval2...@yahoo.fr 2012-06-01 15:33:46 PDT --- Could you attach an example which fails then the same file which works because you copy pasted the command field ? -- 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
[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
https://bugs.freedesktop.org/show_bug.cgi?id=47473 Ian~G grayl...@orange.net changed: What|Removed |Added CC||grayl...@orange.net --- Comment #2 from Ian~G grayl...@orange.net 2012-05-11 02:55:50 PDT --- Still the same on version 3.5.3 Just to clarify this is not a problem with the ubuntu version per se, as I have also tested versions downloaded direct (non-repository). Also, just in case it is pertinent, I use MySQL databases via the direct MySQL Connector, which works a treat. -- 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
[Libreoffice-bugs] [Bug 47473] EDITING: Report Wizard blanks report command field
https://bugs.freedesktop.org/show_bug.cgi?id=47473 Ian~G grayl...@orange.net changed: What|Removed |Added Platform|Other |x86-64 (AMD64) OS/Version|All |Linux (All) Version|LibO 3.5.1 Release |LibO 3.5.2 Release --- Comment #1 from Ian~G grayl...@orange.net 2012-04-18 08:22:38 PDT --- I've got a workaround for this until it gets fixed. I'm using libreoffice version 3.5.2 and ubuntu 12.04 now, but I reckon this'll work on earlier versions too. use the wizard to create a report based on a query. run the report (don't try to edit it directly. there is a bug!). save and close it. now go to the query on which you based the report. edit in sql view and highlight and copy the entire command line (or modify it to taste) reopen the report in edit mode. go to the form navigator and select the command and choose properties. paste your command into the empty command field and save the report. bingo. it all works. better yet, it also runs in earlier versions of openoffice, like 3.2.1 or 3.3 -- 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