Download it now!
Bug 68619 - REPORTBUILDER: Functions in fields were changed to user-defined-functions in properties of the field, if fieldnames have special characters
Summary: REPORTBUILDER: Functions in fields were changed to user-defined-functions in ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Database-Reports-Builder
  Show dependency treegraph
 
Reported: 2013-08-27 17:30 UTC by franco.violi
Modified: 2019-06-26 14:02 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
The data source (11.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-08-30 07:20 UTC, franco.violi
Details
The odb file (7.22 KB, application/vnd.oasis.opendocument.database)
2013-08-30 07:21 UTC, franco.violi
Details
attachment-21116-0.html (2.33 KB, text/html)
2013-09-01 09:26 UTC, franco.violi
Details
attachment-21116-1.dat (1 bytes, multipart/alternative)
2013-09-01 09:26 UTC, franco.violi
Details
Schermata da 2013-09-01 11:19:25.png (117.13 KB, image/png)
2013-09-01 09:26 UTC, franco.violi
Details
Schermata da 2013-09-01 11:20:30.png (122.78 KB, image/png)
2013-09-01 09:26 UTC, franco.violi
Details
Functions in the report - Accumulation with some fields only user-defined (9.63 KB, application/vnd.sun.xml.base)
2014-10-23 14:56 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description franco.violi 2013-08-27 17:30:10 UTC
Problem description: 

Steps to reproduce:
1. Connect to a postgresql database
2. Define a simple report with a group section
3. Try do define a counter or a accumulation inside the group before and after section

In some cases, also the group detail is not working anymore.

Opening a report created by previous release it works, including details, count and accumulators.

Current behavior:

Expected behavior:

              
Operating System: Fedora
Version: 4.1.1.2 rc
Comment 1 Robert Großkopf 2013-08-27 20:25:14 UTC
Is this only a problem with Postgresql? If not it could be tested by everybody.

Is it the grouping, that didn't work in your system any more, or are the functions "counter" and "accumulation" destroyed?
Comment 2 franco.violi 2013-08-28 14:14:40 UTC
No. I think the problem is on the managing of the dialog boxes involved
into the definition of the grouping field. That's why a odb created with a
previous version (4.1.0) just work (if you have not to modify it).


2013/8/27 <bugzilla-daemon@freedesktop.org>

> robert@familiegrosskopf.de changed bug 68619<https://bugs.freedesktop.org/show_bug.cgi?id=68619>
>  What Removed Added  CC   robert@familiegrosskopf.de
>
>  *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=68619#c1> on bug
> 68619 <https://bugs.freedesktop.org/show_bug.cgi?id=68619> from
> robert@familiegrosskopf.de *
>
> Is this only a problem with Postgresql? If not it could be tested by everybody.
>
> Is it the grouping, that didn't work in your system any more, or are the
> functions "counter" and "accumulation" destroyed?
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 3 Robert Großkopf 2013-08-28 16:00:19 UTC
I have tested it with the internal HSQLDB. Created a report, grouped it, set a counter in the Detail-section. Multiplicated two fields in the detail-section. 
In the group-footer:
Get the sum of the multiplicated fields by a user-defined function. Get the accumulation of one field.
Everything works well with LO 4.1.1.2 an OpenSUSE 12.3 64bit rpm.

You have written:
> "That's why a odb created with a
> previous version (4.1.0) just work (if you have not to modify it)."
Could it be you created something with label-fields, which doesn't match the functionality. This had been broken since 4.1.0.0 beta2 and works right with 4.1.1.2
https://bugs.freedesktop.org/show_bug.cgi?id=67109
Comment 4 franco.violi 2013-08-28 18:41:34 UTC
I have never tried with the internal hsqldb, but only with postgresql. I
will try to rebuild the bug with a very simple table and I will post the
results.

Thanks.


2013/8/28 <bugzilla-daemon@freedesktop.org>

>   *Comment # 3 <https://bugs.freedesktop.org/show_bug.cgi?id=68619#c3> on bug
> 68619 <https://bugs.freedesktop.org/show_bug.cgi?id=68619> from
> robert@familiegrosskopf.de *
>
> I have tested it with the internal HSQLDB. Created a report, grouped it, set a
> counter in the Detail-section. Multiplicated two fields in the detail-section.
> In the group-footer:
> Get the sum of the multiplicated fields by a user-defined function. Get the
> accumulation of one field.
> Everything works well with LO 4.1.1.2 an OpenSUSE 12.3 64bit rpm.
>
> You have written:
> > "That's why a odb created with a
> > previous version (4.1.0) just work (if you have not to modify it)."
>
> Could it be you created something with label-fields, which doesn't match the
> functionality. This had been broken since 4.1.0.0 beta2 and works right with
> 4.1.1.2https://bugs.freedesktop.org/show_bug.cgi?id=67109
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 5 franco.violi 2013-08-29 08:32:40 UTC
It seems that building a report from scratch the system is working, but I
can confirm the problem on my database, coming from an older version of
openoffice.

I'm trying to duplicate the problem changing the datasource. In this way I
can put the odb file as an attachment of the bug. Stand by until I will be
able to upload the file.

Bye.


2013/8/28 <bugzilla-daemon@freedesktop.org>

>   *Comment # 3 <https://bugs.freedesktop.org/show_bug.cgi?id=68619#c3> on bug
> 68619 <https://bugs.freedesktop.org/show_bug.cgi?id=68619> from
> robert@familiegrosskopf.de *
>
> I have tested it with the internal HSQLDB. Created a report, grouped it, set a
> counter in the Detail-section. Multiplicated two fields in the detail-section.
> In the group-footer:
> Get the sum of the multiplicated fields by a user-defined function. Get the
> accumulation of one field.
> Everything works well with LO 4.1.1.2 an OpenSUSE 12.3 64bit rpm.
>
> You have written:
> > "That's why a odb created with a
> > previous version (4.1.0) just work (if you have not to modify it)."
>
> Could it be you created something with label-fields, which doesn't match the
> functionality. This had been broken since 4.1.0.0 beta2 and works right with
> 4.1.1.2https://bugs.freedesktop.org/show_bug.cgi?id=67109
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 6 franco.violi 2013-08-30 07:20:50 UTC
Created attachment 84896 [details]
The data source
Comment 7 franco.violi 2013-08-30 07:21:58 UTC
Created attachment 84897 [details]
The odb file
Comment 8 franco.violi 2013-08-30 07:23:06 UTC
I have reproduced the problem, working on my original odb file. Now it get data from a Spreadsheet.

- open the db Ammin.odb
- change the source to AmminSrc.ods correct path
- try to modify Rapporto1 adding a function sum in the footer of the group wap_azienda1 (which is already defined with a working counter), using the add text field option
- On this field, try do sum esp-anno or something else numeric
- After the choice SUM the dialog boxes are reset and swith to user functions

BY the way, this is what my openoffice does.

I have tried to change from italian to english the interface, but i have the same behaviour.
Comment 9 Robert Großkopf 2013-08-30 10:09:24 UTC
(In reply to comment #8)

> - On this field, try do sum esp-anno or something else numeric
> - After the choice SUM the dialog boxes are reset and swith to user functions
> 
What should be wrong with this behavior? LO creates a user-function, which builds a sum. I could see the same behavior in LO 3.3.4 and in LO 4.1.1.2.
Comment 10 franco.violi 2013-09-01 09:26:35 UTC
Created attachment 84997 [details]
attachment-21116-0.html

In a new database, selecting the sum field I see in the data property
Function, Table field, Sum, and context group. In the example I uploaded, I
just see a User Function and it's name. In effect it works, but when
opening a report for maintenance, the end user does not understand clearly
what is running on the field. Finally, if you play with the dialog, you see
that the functions are nested and the end-user is not able to manage the
definition.

In the first example, a report showing the data section correctly.

In the second, a nested data section.

In my opinion the exact behaviour odb has to use is the first.

Franco.


2013/8/30 <bugzilla-daemon@freedesktop.org>

>   *Comment # 9 <https://bugs.freedesktop.org/show_bug.cgi?id=68619#c9> on bug
> 68619 <https://bugs.freedesktop.org/show_bug.cgi?id=68619> from
> robert@familiegrosskopf.de *
>
> (In reply to comment #8 <https://bugs.freedesktop.org/show_bug.cgi?id=68619#c8>)
> > - On this field, try do sum esp-anno or something else numeric
> > - After the choice SUM the dialog boxes are reset and swith to user functions
> >
> What should be wrong with this behavior? LO creates a user-function, which
> builds a sum. I could see the same behavior in LO 3.3.4 and in LO 4.1.1.2.
>
>  ------------------------------
> You are receiving this mail because:
>
>    - You reported the bug.
>
>
Comment 11 franco.violi 2013-09-01 09:26:36 UTC
Created attachment 84998 [details]
attachment-21116-1.dat
Comment 12 franco.violi 2013-09-01 09:26:36 UTC
Created attachment 84999 [details]
Schermata da 2013-09-01 11:19:25.png
Comment 13 franco.violi 2013-09-01 09:26:36 UTC
Created attachment 85000 [details]
Schermata da 2013-09-01 11:20:30.png
Comment 14 Robert Großkopf 2013-09-01 10:46:48 UTC
I must test a little bit. I can reproduce this behavior with the attached example, but I can't reproduce it with a *.odb-file I created by myself. There it looks always like https://bugs.freedesktop.org/attachment.cgi?id=84999.
Comment 15 Alex Thurgood 2014-10-20 14:26:14 UTC
@Franco : have you tested with a recent 4322 production release to whether the problem is still present for you ?
Comment 16 Robert Großkopf 2014-10-20 14:56:00 UTC
Have tested it now with LO 4.3.3.1, OpenSUSE 64bit rpm Linux. If you use a function like "Sum" and in the datafield the created function is shown - not the data, which is used. Also isn't shown the function and the group, where the function is made for.

The function itself doesn't work. You couldn't find the created function in the report-navigator. Seems there is something else broken.

Will have a look where this appears the first time.
Comment 17 Robert Großkopf 2014-10-20 15:18:14 UTC
I have now tried it with many versions here. The functions defined as Data-field-type function doesn't work in any version of LO with an old database. There isn't created a function. There isn't shown the field for the function and the group, where it is defined for.

Tested with every main-version down to LO 3.3.4 - doesn't work. Will try  a little bit more later.
Comment 18 Robert Großkopf 2014-10-20 19:43:15 UTC
Now I tried with a new created database. Took different fields with Integer, SmallInteger and someone else. Put some content in the table and started the Report-Builder. With this database all will work with the same LO- and system-environment.Will try to remove all content of the not-working-database and then try it again.
Comment 19 Robert Großkopf 2014-10-22 19:48:00 UTC
Have now tried it with different files. Sometimes I could reproduce there isn't created any function. In one file I first couldn't create any function, then I deleted all Macros (deleted the Basic-Folder in the *.odb-file), renamed the database and then I could create the functions. But I could only define a accumulation shown in the right way as created by the report-builder, not user-defined with an accumulation of a Integer-value. In the same report a decimal-value will be accumulated, but a user-defined function will be created.

Seems to be a little bit tricky to find the relation between the different parts of the database and the handling of functions in the report-builder.
Comment 20 Robert Großkopf 2014-10-23 14:56:52 UTC
Created attachment 108302 [details]
Functions in the report - Accumulation with some fields only user-defined

Open the report for editing.
Have a look at the different functions in the group-footer.
All functions had been created by the Report-Builder.
The functions of the fields on the right side look like user-defined functions.
Only the fieldname differs from the other functions.
If the fieldname has characters like "_" or "-" the function is created as user-defined function. Could be it is the same with many other special characters. I haven't tested more than this.
Comment 21 Robert Großkopf 2014-10-23 15:03:16 UTC
Changed the version to "Inherited From OOo", because the bug could be reproduced with LO 3.3.0beta1 also.
Comment 22 Alex Thurgood 2015-01-03 17:40:07 UTC Comment hidden (no-value)
Comment 23 QA Administrators 2016-01-17 20:02:12 UTC Comment hidden (obsolete)
Comment 24 Robert Großkopf 2016-01-18 20:31:45 UTC
Bug still exists in LO 5.1.0.2, OpenSUSE Leap 42.1 64bit rpm Linux.

Bug only appears while filednames have special characters like "_" or "-". Have changed the title a little bit for this.
Comment 25 QA Administrators 2017-03-06 13:50:28 UTC Comment hidden (obsolete)
Comment 26 Robert Großkopf 2017-03-06 15:54:37 UTC
Bug still exists in LO 5.3.1.1, OpenSUSE Leap 42.1 64bit rpm Linux.
Comment 27 QA Administrators 2018-06-25 02:41:02 UTC Comment hidden (obsolete)
Comment 28 Robert Großkopf 2018-06-25 15:05:05 UTC
Bug still exists with LO 6.0.5.2, OpenSUSE 42.3 Leap, 64bit rpm Linux.
Comment 29 QA Administrators 2019-06-26 02:46:37 UTC Comment hidden (obsolete)
Comment 30 Robert Großkopf 2019-06-26 14:02:06 UTC
Bug still exists with LO 6.2.4.2 on OpenSUSE 15 64bit rpm Linux