Bug 99985 - UDF does not work in Report Builder
Summary: UDF does not work in Report Builder
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.1.2.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Reports-Builder
  Show dependency treegraph
 
Reported: 2016-05-21 20:33 UTC by c18florentino
Modified: 2018-06-25 11:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
UDF definition (86.45 KB, image/png)
2016-05-26 16:32 UTC, c18florentino
Details
RESULT: just 1st. row computed (67.68 KB, image/png)
2016-05-26 16:33 UTC, c18florentino
Details
example file (9.12 KB, application/vnd.oasis.opendocument.database)
2016-05-27 17:51 UTC, c18florentino
Details

Note You need to log in before you can comment on or make changes to this bug.
Description c18florentino 2016-05-21 20:33:37 UTC
User Defined Function in Report Builder does not work.
I have DETAIL
field_1 field_2

Want GrandTotal on Report Header (or footer - the same)
UDF: "Totalizador"
Formula: [Totalizador] + [field_1] + [field_2] (or + SUM([field_1];[field_2])
Initial Value: [field_1] + [field_2] 

Just shows initial value [field_1] + [field_2] corresponding to the first row of the recordset.
Does not add up the detail rows to calculate the grand total.
Comment 1 Buovjaga 2016-05-26 12:19:35 UTC
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided an example document.
Comment 2 c18florentino 2016-05-26 16:32:35 UTC
Created attachment 125299 [details]
UDF definition

I don't know how to add second view showing result, i.e., the sum just over first recordset row.
Comment 3 c18florentino 2016-05-26 16:33:24 UTC
Created attachment 125300 [details]
RESULT: just 1st. row computed
Comment 4 Buovjaga 2016-05-27 07:33:02 UTC
Please add an example document, not images.
Comment 5 c18florentino 2016-05-27 10:55:30 UTC
Don't know what you mean.
Added the UDF definition + generated (proto-)report.
Do you want a pdf of the report?
Comment 6 Buovjaga 2016-05-27 11:01:59 UTC
(In reply to c18florentino from comment #5)
> Don't know what you mean.
> Added the UDF definition + generated (proto-)report.
> Do you want a pdf of the report?

I want an example odb file.
Comment 7 c18florentino 2016-05-27 17:51:56 UTC
Created attachment 125331 [details]
example file
Comment 8 Buovjaga 2016-05-28 16:03:34 UTC
Confirmed.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.0.0.alpha0+
Build ID: ab0189433c1593c3c3ccf6a947aa7ba84e806d91
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on May 28th 2016
Comment 9 QA Administrators 2018-06-25 02:41:56 UTC Comment hidden (obsolete)
Comment 10 c18florentino 2018-06-25 11:50:52 UTC
Yes, the bug was fixed from the version it was predicted (I couldn't locate the message above now...).
Thanks for you attention!

Best Regards.

Versão: 6.0.4.2
ID de compilação: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
Threads da CPU:4; SO:Windows 10.0; Realizador da interface: padrão; 
Local: pt-BR (pt_BR); Calc: group