Unable to create any reports with SUN Report Builder Enabled

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
YarNivek
Posts: 8
Joined: Wed Apr 22, 2009 8:21 am

Unable to create any reports with SUN Report Builder Enabled

Post 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.
OOo 3.0.X on Ubuntu 8.x
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

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

Post by r4zoli »

What version of SRB you use?
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
kai.berkau
Posts: 2
Joined: Wed Apr 29, 2009 11:56 am

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

Post 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
OOo 2.4.X on Ubuntu 8.x
YarNivek
Posts: 8
Joined: Wed Apr 22, 2009 8:21 am

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

Post 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!
OOo 3.0.X on Ubuntu 8.x
YarNivek
Posts: 8
Joined: Wed Apr 22, 2009 8:21 am

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

Post 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.
OOo 3.0.X on Ubuntu 8.x
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

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

Post 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.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
YarNivek
Posts: 8
Joined: Wed Apr 22, 2009 8:21 am

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

Post 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.
OOo 3.0.X on Ubuntu 8.x
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

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

Post 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.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
YarNivek
Posts: 8
Joined: Wed Apr 22, 2009 8:21 am

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

Post 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?
OOo 3.0.X on Ubuntu 8.x
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

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

Post 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 
Last edited by r4zoli on Thu May 07, 2009 5:30 pm, edited 1 time in total.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
YarNivek
Posts: 8
Joined: Wed Apr 22, 2009 8:21 am

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

Post 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?
OOo 3.0.X on Ubuntu 8.x
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

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

Post 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.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

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

Post by r4zoli »

I does'nt work and crash on new odb file.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Post Reply