Bug 94534 - REPORTBUILDER won't save changes to reports in report design mode
Summary: REPORTBUILDER won't save changes to reports in report design mode
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.4.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-26 16:20 UTC by Pete C.
Modified: 2015-11-09 10:28 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Pete C. 2015-09-26 16:20:43 UTC
REPORTBUILDER won't open in Design View mode in LibreOffice Base 4
REPORTBUILDER does not save reports designed in Design View in LibreOffice Base 5.  Most of report design is lost upon closing the Design View editor regardless of multiple saves. The save button on the toolbar, along with some other buttons, never get enabled.
Comment 1 Alex Thurgood 2015-09-27 10:26:54 UTC
@Pete : please provide more information, as there is not really enough to go on from what you have provided so far.

Which Linux distribution ?

Which versions of LibreOffice are you using ? You mention LO4, then you mention LO5 - which one(s) specifically ?

Distrib provided or a version available from the LibreOffice project download server ?

Which version of the ReportBuilder ? Again, distrib provided (usually a separate install), or bundled in TDF version ?

Which JVM version are you using ?

Also please provide a sample ODB where the problem exists and instructions on how to systematically reproduce the problem.
Comment 2 Alex Thurgood 2015-09-27 11:07:00 UTC
No repro on LO :

Version: 5.0.2.2
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Locale : fr-FR (fr_FR.UTF-8)

I can create a report ab initio.
I can modify an existing report definition in the report builder.
I can save that modified report definition and then execute to produce the modified report document.
Comment 3 Alex Thurgood 2015-09-27 11:09:40 UTC
The only thing I can confirm as reproducible is the lack of activated "Save" button in the toolbar. Although a bug, this can be worked around via File >> Save.

Please open a separate report for the lack of activated Save button (vague memory tells me that this was already reported, but go ahead and file a report against it anyway, we'll check for duplicates later).
Comment 4 Robert Großkopf 2015-09-27 14:26:40 UTC
This isn't a valid bug-description:
One bug - one bugreport.
Version of LO and system you are using.
Title of the bug should give a hint which behavior of LO is defect.

Saving reports by the button 'Save' of the Report-Builder sometimes seems to be a problem. See here: https://bugs.documentfoundation.org/show_bug.cgi?id=88254
Comment 5 DiegoM 2015-09-27 20:55:41 UTC
Confirm Bug: reportBuilder does not open.
Conditions:
O.S.: Linux UbuntuGnome 14.04 32bit
LO: v.4.4.5.2 rc2
Java: Oracle 1.8 or OpenJDK 1.7 (tried with both, no difference)
Description: in LO/Base I defined a database HSQLDB Embedded structure with 5 simple tables and two table in master/detail relation.

Report wizard is functioning on simple tables.
Report wizard is functioning on complex tables only if report type "static" is declared; if "dynamic" is chosen, report is builded but when run no data are retrived, report is not filled with data.

"Create report in Design View" DOES NOTHING.
Going on a table, right-mouse/Report (should open Design View report on the table) DOES NOTHING.
Comment 6 DiegoM 2015-09-27 20:58:33 UTC
What more info may be needed?
Comment 7 Julien Nabet 2015-09-27 21:17:38 UTC
(In reply to DiegoM from comment #5)
> ...
> "Create report in Design View" DOES NOTHING.
> Going on a table, right-mouse/Report (should open Design View report on the
> table) DOES NOTHING.

I reproduce this with LO Debian package 5.0.1. I just installed "libreoffice-report-builder" and it was ok.
Since I usually use master sources that I build, I don't know if it's normal behavior or not.
Comment 8 Robert Großkopf 2015-09-28 14:13:33 UTC
One hint:
Ubuntu doesn't install the Report-Builder when choosing LibreOffice Base to install. There must be a special package for Report-Builder. So the reports would only be created by the wizard with the old legacy report-engine.

Do you get the packages from Ubuntu or from LibreOffice directly?
Comment 9 DiegoM 2015-09-29 10:06:14 UTC
- Ubuntu-gnome is 14.04, up-to-date
- LO 4.4.5.2 (last Fresh version) is not present in the main repository for Ubuntu, a backport ppa must be declared: http://ppa.launchpad.net/libreoffice/libreoffice-4-4/ubuntu trusty main
- installed packages are:
ii  libreoffice                                1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite (metapackage)
ii  libreoffice-avmedia-backend-gstreamer      1:4.4.5~rc2-0ubuntu1~trusty1                        i386         GStreamer backend for LibreOffice
ii  libreoffice-base                           1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- database
ii  libreoffice-base-core                      1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- shared library
ii  libreoffice-base-drivers                   1:4.4.5~rc2-0ubuntu1~trusty1                        i386         Database connectivity drivers for LibreOffice
ii  libreoffice-calc                           1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- spreadsheet
ii  libreoffice-common                         1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- arch-independent files
ii  libreoffice-core                           1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- arch-dependent files
ii  libreoffice-dev                            1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- SDK
ii  libreoffice-dev-doc                        1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- SDK documentation
ii  libreoffice-draw                           1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- drawing
ii  libreoffice-gnome                          1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- GNOME integration
ii  libreoffice-gtk                            1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- GTK+ integration
ii  libreoffice-help-de                        1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- German help
ii  libreoffice-help-en-gb                     1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- English_british help
ii  libreoffice-help-en-us                     1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- English_american help
ii  libreoffice-help-it                        1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- Italian help
ii  libreoffice-impress                        1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- presentation
ii  libreoffice-java-common                    1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- arch-independent Java support files
ii  libreoffice-l10n-de                        1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- German language package
ii  libreoffice-l10n-en-gb                     1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- English_british language package
ii  libreoffice-l10n-it                        1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- Italian language package
ii  libreoffice-math                           1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- equation editor
ii  libreoffice-ogltrans                       1:4.4.5~rc2-0ubuntu1~trusty1                        i386         LibreOffice Impress extension for slide transitions using OpenGL
ii  libreoffice-pdfimport                      1:4.4.5~rc2-0ubuntu1~trusty1                        i386         PDF Import component for LibreOffice
ii  libreoffice-presentation-minimizer         1:4.4.5~rc2-0ubuntu1~trusty1                        all          transitional package for the LibreOffice presentation minimizer
ii  libreoffice-report-builder                 1:4.4.5~rc2-0ubuntu1~trusty1                        all          LibreOffice component for building database reports
ii  libreoffice-report-builder-bin             1:4.4.5~rc2-0ubuntu1~trusty1                        i386         LibreOffice component for building database reports -- libraries
ii  libreoffice-script-provider-python         1:4.4.5~rc2-0ubuntu1~trusty1                        all          Python script support provider for LibreOffice scripting framework
ii  libreoffice-sdbc-firebird                  1:4.4.5~rc2-0ubuntu1~trusty1                        i386         Firebird SDBC driver for LibreOffice
ii  libreoffice-sdbc-hsqldb                    1:4.4.5~rc2-0ubuntu1~trusty1                        i386         HSQLDB SDBC driver for LibreOffice
ii  libreoffice-style-breeze                   1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- Breeze symbol style
ii  libreoffice-style-human                    1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- Human symbol style
ii  libreoffice-style-tango                    1:4.4.5~rc2-0ubuntu1~trusty1                        all          office productivity suite -- Tango symbol style
ii  libreoffice-writer                         1:4.4.5~rc2-0ubuntu1~trusty1                        i386         office productivity suite -- word processor
Comment 10 Robert Großkopf 2015-09-29 15:55:39 UTC
(In reply to DiegoM from comment #9)
> - Ubuntu-gnome is 14.04, up-to-date
> - LO 4.4.5.2 (last Fresh version) is not present in the main repository for
> Ubuntu, a backport ppa must be declared:
> http://ppa.launchpad.net/libreoffice/libreoffice-4-4/ubuntu trusty main
> - installed packages are:
> ii  libreoffice-report-builder                 1:4.4.5~rc2-0ubuntu1~trusty1 
> all          LibreOffice component for building database reports
> ii  libreoffice-report-builder-bin             1:4.4.5~rc2-0ubuntu1~trusty1 
> i386         LibreOffice component for building database reports -- libraries

This are the packages from Ubuntu. Could be you detected a special bug for this packages. Orginal packages from LO have only one package for the report-builder:
libobasis4.4-extension-report-builder_4.4.5.2-2_i386.deb

Please report to Ubuntu Report-Builder won't open in design-view.

Please install the original packages from LO. You could get this packages from here:
http://downloadarchive.documentfoundation.org/libreoffice/old/4.4.5.2/deb/x86/
You could install the whole LO as a user-install, so no super-user-rights are needed for it and no other installation will be affected.
Create a folder in your home-directory (for example: "lotest"). Create a folder inside this folder ("install"). Open the shell in this folder and start

for i in ../*.deb; do dpkg-deb -x $i . ; done

This will look to the upper folder and will install all the content in the subfolder "install". 
You could start the installed LO from ...install/opt/libreoffice4.4/program/soffice

Regards

Robert
Comment 11 DiegoM 2015-10-02 17:16:44 UTC
(In reply to robert from comment #10)
> (In reply to DiegoM from comment #9)
> > - Ubuntu-gnome is 14.04, up-to-date
> > - LO 4.4.5.2 (last Fresh version) is not present in the main repository for
> > Ubuntu, a backport ppa must be declared:
> > http://ppa.launchpad.net/libreoffice/libreoffice-4-4/ubuntu trusty main
> > - installed packages are:
> > ii  libreoffice-report-builder                 1:4.4.5~rc2-0ubuntu1~trusty1 
> > all          LibreOffice component for building database reports
> > ii  libreoffice-report-builder-bin             1:4.4.5~rc2-0ubuntu1~trusty1 
> > i386         LibreOffice component for building database reports -- libraries
> 
> This are the packages from Ubuntu. Could be you detected a special bug for
> this packages. Orginal packages from LO have only one package for the
> report-builder:
> libobasis4.4-extension-report-builder_4.4.5.2-2_i386.deb
> 
> Please report to Ubuntu Report-Builder won't open in design-view.
> 
> Please install the original packages from LO. You could get this packages
> from here:
> http://downloadarchive.documentfoundation.org/libreoffice/old/4.4.5.2/deb/
> x86/
> You could install the whole LO as a user-install, so no super-user-rights
> are needed for it and no other installation will be affected.
> Create a folder in your home-directory (for example: "lotest"). Create a
> folder inside this folder ("install"). Open the shell in this folder and
> start
> 
> for i in ../*.deb; do dpkg-deb -x $i . ; done
> 
> This will look to the upper folder and will install all the content in the
> subfolder "install". 
> You could start the installed LO from
> ...install/opt/libreoffice4.4/program/soffice
> 
> Regards
> 
> Robert

OK, Robert.
Will try a custom installation (allready done such before) and report about it.

You suggested "Please report to Ubuntu 'Report-Builder won't open in design-view'.". Where should I report such bug?

Thanks,
diego
Comment 12 Robert Großkopf 2015-10-02 18:36:26 UTC
> 
> You suggested "Please report to Ubuntu 'Report-Builder won't open in
> design-view'.". Where should I report such bug?
> 
Hi Diego,

I think this would be the entry:
https://help.ubuntu.com/community/ReportingBugs

I don't use Ubuntu. Have only tested a little bit with Ubuntu/Kubuntu a long time ago. Have only installed OpenSUSE 64bit rpm Linux.

Regards

Robert
Comment 13 Alex Thurgood 2015-10-06 06:36:46 UTC
@Pete : please provide the requested information.
Comment 14 Alex Thurgood 2015-10-06 06:39:47 UTC
(In reply to DiegoM from comment #11)

> 
> OK, Robert.
> Will try a custom installation (allready done such before) and report about
> it.
> 

@Diego : your problem is different to the one Pete initially reported - if it is not an Ubuntu PPA specific problem, please open a separate bug report in this bugzilla.

If your problem is an Ubuntu specific PPA problem, then open a bug report on Ubuntu's own bug reporting platform.
Comment 15 DiegoM 2015-10-07 20:13:34 UTC
(In reply to Alex Thurgood from comment #14)
> (In reply to DiegoM from comment #11)
> 
> > 
> > OK, Robert.
> > Will try a custom installation (allready done such before) and report about
> > it.
> > 
> 
> @Diego : your problem is different to the one Pete initially reported - if
> it is not an Ubuntu PPA specific problem, please open a separate bug report
> in this bugzilla.
> 
> If your problem is an Ubuntu specific PPA problem, then open a bug report on
> Ubuntu's own bug reporting platform.

---
Hallo Alex/Robert.

I did install LO 4.4.5.2 32bit downloaded from TDF/LO site; this was done without removing the ppa installation.

Forcing start from /opt/libreoffice4.4/program/soffice.
After opening the odb, Reportbuilder is starting normally. 
For me the item is solved, will try to report it to Ubuntu ppa bug platform.

tnks, diego
Comment 16 DiegoM 2015-11-09 10:27:40 UTC
(In reply to DiegoM from comment #15)
> (In reply to Alex Thurgood from comment #14)
> > (In reply to DiegoM from comment #11)
> > 
> > > 
> > > OK, Robert.
> > > Will try a custom installation (allready done such before) and report about
> > > it.
> > > 
> > 
> > @Diego : your problem is different to the one Pete initially reported - if
> > it is not an Ubuntu PPA specific problem, please open a separate bug report
> > in this bugzilla.
> > 
> > If your problem is an Ubuntu specific PPA problem, then open a bug report on
> > Ubuntu's own bug reporting platform.
> 
> ---
> Hallo Alex/Robert.
> 
> I did install LO 4.4.5.2 32bit downloaded from TDF/LO site; this was done
> without removing the ppa installation.
> 
> Forcing start from /opt/libreoffice4.4/program/soffice.
> After opening the odb, Reportbuilder is starting normally. 
> For me the item is solved, will try to report it to Ubuntu ppa bug platform.
> 
> tnks, diego

Item in Ubuntu PPA was solved with LO Version: 4.4.6.3 - Build ID: 40m0(Build:3). PPA distribution is still based on 2 packages ReportBuilder + ReportBuilder-bin, but now RBuilder does open and behave regulary.

diego
Comment 17 DiegoM 2015-11-09 10:28:22 UTC
(In reply to DiegoM from comment #5)
> Confirm Bug: reportBuilder does not open.
> Conditions:
> O.S.: Linux UbuntuGnome 14.04 32bit
> LO: v.4.4.5.2 rc2
> Java: Oracle 1.8 or OpenJDK 1.7 (tried with both, no difference)
> Description: in LO/Base I defined a database HSQLDB Embedded structure with
> 5 simple tables and two table in master/detail relation.
> 
> Report wizard is functioning on simple tables.
> Report wizard is functioning on complex tables only if report type "static"
> is declared; if "dynamic" is chosen, report is builded but when run no data
> are retrived, report is not filled with data.
> 
> "Create report in Design View" DOES NOTHING.
> Going on a table, right-mouse/Report (should open Design View report on the
> table) DOES NOTHING.

Item in Ubuntu PPA was solved with LO Version: 4.4.6.3 - Build ID: 40m0(Build:3).
diego