Page 1 of 1

Unable to create any reports with SUN Report Builder Enabled

Posted: Sat Apr 25, 2009 2:35 am
by YarNivek
Using Ubuntu (have tried under both 8.10 and 9.04), OOo 3.0.

With SUN Report Builder enabled, I cannot generate a report regardless of whether I use the Wizard or Design view. I can edit existing reports, but when I attempt to create a new one under either command nothing happens.

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Tue Apr 28, 2009 8:30 am
by r4zoli
What version of SRB you use?

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Wed Apr 29, 2009 3:32 pm
by kai.berkau
YarNivek wrote:Using Ubuntu (have tried under both 8.10 and 9.04), OOo 3.0.
With ubuntu I recommend to install the report builder this way:
"sudo apt-get install openoffice.org-report-builder"
not that way:
http://extensions.services.openoffice.o ... portdesign

A lot of dependant packages are not installed by default in Ubuntu.

Does this solve your problem?

Best regards
Kai

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Wed May 06, 2009 8:37 am
by YarNivek
kai.berkau wrote:
YarNivek wrote:Using Ubuntu (have tried under both 8.10 and 9.04), OOo 3.0.
With ubuntu I recommend to install the report builder this way:
"sudo apt-get install openoffice.org-report-builder"
not that way:
http://extensions.services.openoffice.o ... portdesign

Best regards
Kai
That worked...thanks!

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Wed May 06, 2009 9:17 am
by YarNivek
Actually, every time I create a report with the Sun Report builder now, I get an error and lose any work that I did because OOo needs to shut down. I did still have the other version of SRB installed, so I removed that, and if it repeats again, I will uninstall and reinstall SRB to see if that works.

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Wed May 06, 2009 9:40 am
by Hagar Delest
If it still doesn't work, you can try the official (Sun) version: [Ubuntu] Installing OOo on Debian and Co. Note that 3.1 is now available.

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Wed May 06, 2009 4:27 pm
by YarNivek
YarNivek wrote:Actually, every time I create a report with the Sun Report builder now, I get an error and lose any work that I did because OOo needs to shut down. I did still have the other version of SRB installed, so I removed that, and if it repeats again, I will uninstall and reinstall SRB to see if that works.
Okay, so I did all that stuff I mentioned, and there's still a problem. Here's what happens...

I open the database, create a report in design view, make all the modifications, saving as I go. Then when I'm done I close the SRB window, which IMMEDIATELY gives me an "OpenOffice.Org BASE has encountered an error and needs to shut down. Your documents will be recovered."

Then when I recover the database and re-open it, either the report I created doesn't show up, or it's in the report list, BUT when I open it, it's a blank report.

Please advise.

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Wed May 06, 2009 5:19 pm
by r4zoli
It is known bug in linux versions of OOo 3.0.x (I had same problem on opensuse), which based on go-oo sources, use OOo from OOo site, or launchpad version of Ubuntu OOo, where this bug solved.

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Thu May 07, 2009 7:32 am
by YarNivek
So I tried installing the version from the website (Linux DEB 64, version 3.0.1) using the tar.gz and tutorial, however that caused WAY more problems than it solved...most notably not being able to use the JDBC driver to connect to the database, and crashing every time I tried to open the Extension Manager.

I've got it back to the normal Ubuntu install of OOo, but what do you mean by the "launchpad" version?

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Thu May 07, 2009 9:16 am
by r4zoli
It is a source for OOo development versions, for 8.10 use:

Code: Select all

http://ppa.launchpad.net/openoffice-pkgs/ubuntu/ interpid main
For other versions change interpid to your version.
Today install OOo 3.1.
 Edit: Base part not working :twisted:, can not create new odb file, crash :evil: , old odb files I can not edit, gives SDBC error with own built in HSQLDB files. 
 Edit: Second: launchpad 

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Thu May 07, 2009 5:06 pm
by YarNivek
r4zoli wrote:It is a source for OOo development versions, for 8.10 use:

Code: Select all

http://ppa.launcpad.net/openoffice-pkgs/ubuntu/ interpid main
For other versions change interpid to your version.
Today install OOo 3.1.
 Edit: Base part not working :twisted:, can not create new odb file, crash :evil: , old odb files I can not edit, gives SDBC error with own built in HSQLDB files. 
Your edit has me confused...should I try it or is that version not working?

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Thu May 07, 2009 5:27 pm
by Hagar Delest
Up to you but it seems that it doesn't work.

BTW, the right string is (I guess): http://ppa.launchpad.net/openoffice-pkgs/ubuntu/ intrepid main

When you have installed the Sun version, had you transferred your personal data during the welcome process? It's a frequent cause of problems.

Re: Unable to create any reports with SUN Report Builder Enabled

Posted: Thu May 07, 2009 5:33 pm
by r4zoli
I does'nt work and crash on new odb file.