[Fwd: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder]

2012-05-28 Thread Girvin R. Herr
Alexander Thurgood wrote: Le 26/05/12 22:30, Girvin R. Herr a écrit : Hi Girvin, If you have links to LO/OOo configuration documentation for ODBC connection to MySQL, I would be willing to try it. Thanks. I wrote a tutorial for this very purpose many years ago for OOo, but it

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-27 Thread Girvin R. Herr
Andreas Säger wrote: Am 26.05.2012 22:13, Girvin R. Herr wrote: Andreas, Yes! Plus the com.mysql.jdbc.Driver class and the MySQL (JDBC) connection type option. And I am using the MySQL-connector-java-5.0.7-bin.jar in the class path and the MySQL 5.0.67 server. Sun (Oracle) Java version

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Fernand Vanrie
Girvin , You must know that ORB , when openning a report, first execute the SQL commands saved with the report, this can surrly takes some time, then you can give a new 'actual)set off SQL commands. Therefore we never safe the reports with real SQL commands, we just make a dummy command and

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread drew jensen
On Sat, 2012-05-26 at 12:53 +0200, Andreas Säger wrote: Am 26.05.2012 00:47, Girvin R. Herr wrote: As an update to my problem with Report Builder, my 1500+ record database takes 94 pages of a Report Builder / Writer document. I put on my patience hat and timed how long it takes to format

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Tom Davies
drewjensen.in...@gmail.com Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder To: users@global.libreoffice.org Date: Saturday, 26 May, 2012, 4:50 On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote: drew jensen wrote: 8... Hi Tom Really - you seem to know a lot, are you

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
drew jensen wrote: On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote: drew jensen wrote: 8... Hi Tom Really - you seem to know a lot, are you writing a manual? @Girvin - there is no place that I've seen the report builder be that slow and not have an installation problem -

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
Fernand, I am assuming you are talking about the Data tab for the report where there are Content Type and Content option lists. I tried it both ways with the same results. Originally, I was using the SQL command(s) the wizard created when I first created the report. Those SQL commands

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
Andreas Säger wrote: 8... -- When you drag the query icon from the left pane of the data source window onto a Calc cell you will get a semi-automatic link. Call menu:DataRefresh to refresh the link. -- When you drag selected row selectors you get a copy of selected rows. The top-left

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
Andreas Säger wrote: Am 26.05.2012 00:47, Girvin R. Herr wrote: As an update to my problem with Report Builder, my 1500+ record database takes 94 pages of a Report Builder / Writer document. I put on my patience hat and timed how long it takes to format the report, ready for printing. As a

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Tom Davies
:) --- On Sat, 26/5/12, Girvin R. Herr girvin.h...@sbcglobal.net wrote: From: Girvin R. Herr girvin.h...@sbcglobal.net Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder To: users@global.libreoffice.org Date: Saturday, 26 May, 2012, 20:43 drew jensen wrote: On Fri, 2012-05-25

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
drew jensen wrote: 8... Ah I missed that last bit - yup, those JDBC connections can suck - has the OP tried ODBC? //drew Drew, I am the OP. No, I have not tried ODBC. The only configuration documentation I have been able to get for MySQL and Base, used JDBC. At the time, that

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
Andreas Säger wrote: 8... I was thinking of this problem which affects Linux+Java-DB+LibO before 3.5: http://www.oooforum.org/forum/viewtopic.phtml?t=125253highlight=java+linux The problem has gone with LibreOffice 3.5 and it did not exist under operating systems other than Linux.

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder To: users@global.libreoffice.org Date: Saturday, 26 May, 2012, 20:43 drew jensen wrote: On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote: drew jensen wrote: 8... Hi Tom Really - you seem

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
Andreas Säger wrote: Am 26.05.2012 22:13, Girvin R. Herr wrote: Andreas, Yes! Plus the com.mysql.jdbc.Driver class and the MySQL (JDBC) connection type option. And I am using the MySQL-connector-java-5.0.7-bin.jar in the class path and the MySQL 5.0.67 server. Sun (Oracle) Java version

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Tom Davies
girvin.h...@sbcglobal.net wrote: From: Girvin R. Herr girvin.h...@sbcglobal.net Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder To: users@global.libreoffice.org Date: Saturday, 26 May, 2012, 22:34 Andreas Säger wrote: Am 26.05.2012 22:13, Girvin R. Herr wrote: Andreas

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread Girvin R. Herr
: [libreoffice-users] Re: Extremely Slow Base Report Builder To: users@global.libreoffice.org Date: Saturday, 26 May, 2012, 22:34 Andreas Säger wrote: Am 26.05.2012 22:13, Girvin R. Herr wrote: Andreas, Yes! Plus the com.mysql.jdbc.Driver class and the MySQL (JDBC) connection type option

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Tom Davies
/12, Girvin R. Herr girvin.h...@sbcglobal.net wrote: From: Girvin R. Herr girvin.h...@sbcglobal.net Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder To: users@global.libreoffice.org Date: Thursday, 24 May, 2012, 20:01 Andreas Säger wrote: With LibO 3.5 under Linux I can

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Tom Davies
:) --- On Thu, 24/5/12, Girvin R. Herr girvin.h...@sbcglobal.net wrote: From: Girvin R. Herr girvin.h...@sbcglobal.net Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder To: users@global.libreoffice.org Date: Thursday, 24 May, 2012, 20:01 Andreas Säger wrote: With LibO 3.5 under Linux

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr
Tom Davies wrote: Hi :) I have just done a bit of digging around. Looking back through Andreas' answers http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80 I found this but i'm not sure it's much help for you

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Dan Lewis
On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote: Tom Davies wrote: Hi :) I have just done a bit of digging around. Looking back through Andreas' answers http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80 I found this but i'm not

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread drew jensen
On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote: Tom Davies wrote: Hi :) I have just done a bit of digging around. Looking back through Andreas' answers http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80 I found this but i'm not

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr
Dan Lewis wrote: Yes, you can link to a Base query with Calc. With Cal open, use the F4 key to open the Data Source window. (You will have to register the database before it will appear in this window.) The left side is the name of the registered databases. Click the arrow in front of

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread Girvin R. Herr
drew jensen wrote: 8... Hi Tom Really - you seem to know a lot, are you writing a manual? @Girvin - there is no place that I've seen the report builder be that slow and not have an installation problem - not saying it is impossible but sounds really odd. 1500 records in a tabular report, 49

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread drew jensen
On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote: drew jensen wrote: 8... Hi Tom Really - you seem to know a lot, are you writing a manual? @Girvin - there is no place that I've seen the report builder be that slow and not have an installation problem - not saying it is

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-24 Thread Girvin R. Herr
Andreas Säger wrote: With LibO 3.5 under Linux I can use any recent Java version without any issues. I tested 1.6.22, 1.6.31 and 1.7. Any of these simply work with my Java databases. I avoid the report builder like illness. If you feel the need to dance with this software diva then you

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-24 Thread Girvin R. Herr
Alexander Thurgood wrote: Le 24/05/12 00:01, Girvin R. Herr a écrit : Hi Girvin, MySQL 5.0.67 MySQL-connector-java-5.0.7-bin.jar Sun Java 1.6.0u11 Oooh, very old and potentially highly exploitable version of Java there. Is my current Report Builder problem caused