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
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
would equally apply to LO today, things
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
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
Dan,
Wow! That worked fine. Thanks.
However, I had to copy and paste the database data from the Data Source
window into the Calc spreadsheet. Is there a way to dynamically get the
current data to the spreadsheet so I don't have to cut and paste every
time I have new data?
If so, it would be a lot
Am 26.05.2012 12:40, Andreas Säger wrote:
The linked data range resizes dynamically with every refresh.
Any formula cells directly adjacent to the import range will expand and
shrink with the resized data range. So the clearly defined row sets of a
database enable dynamically resizing formula
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 baseline, it takes about
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
Am 26.05.2012 13:32, drew jensen wrote:
On Sat, 2012-05-26 at 12:53 +0200, Andreas Säger wrote:
You are running the combination of Linux, Base plus JDBC?
Ah I missed that last bit - yup, those JDBC connections can suck - has
the OP tried ODBC?
//drew
I was thinking of this problem
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
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 -
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
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
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
:)
--- 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
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
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.
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 1.6.0_30
All test okay, of
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
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
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
: [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
/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
:)
--- 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
Am 25.05.2012 09:35, Tom Davies wrote:
Hi :)
I think there is another way to build reports? I think Andreas uses a
different way inside Base. Other people seem to start with the report builder
and then hack it around. It might be worth search the archives to find how
Andreas does reports!
Am 25.05.2012 10:04, Tom Davies wrote:
Sadly most of the people that know a lot about the ins-and-outs of Base are
unwilling to help write the Base guide so it's down to 1 person who is
desperately busy with a lot of other projects.
How would you write a guide for hammer, chisel, plow, saw
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
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
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
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
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
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
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 by this Java problem again?
Yes.
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
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
Am 24.05.2012 21:01, Girvin R. Herr wrote:
I will certainly take your experience to heart and your recommendation
to update my Java.
Thanks again.
Girvin
If you are running Java 1.7 downgrading to some recent 1.6 version may
be even more helpful. Until now I could not test RB with Java 1.7
Am 24.05.2012 21:33, Andreas Säger wrote:
Am 24.05.2012 21:01, Girvin R. Herr wrote:
I will certainly take your experience to heart and your recommendation
to update my Java.
Thanks again.
Girvin
If you are running Java 1.7 downgrading to some recent 1.6 version may
be even more helpful.
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 should do all calculations,
38 matches
Mail list logo