Bug 101016 - REPORT BUILDER: Charts aren't shown when using grouped data from same datasource the report uses
Summary: REPORT BUILDER: Charts aren't shown when using grouped data from same datasou...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 117162
Blocks: Database-Reports-Builder
  Show dependency treegraph
 
Reported: 2016-07-19 17:37 UTC by branestawm
Modified: 2022-04-01 09:21 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Test file to show missing charts bug with grouped data (14.73 KB, application/vnd.oasis.opendocument.database)
2016-07-19 17:37 UTC, branestawm
Details

Note You need to log in before you can comment on or make changes to this bug.
Description branestawm 2016-07-19 17:37:01 UTC
Created attachment 126307 [details]
Test file to show missing charts bug with grouped data

The attached odb file has a simple embedded HSQLDB database with two groups 'A' & 'B'. 'Line charts report' has Query1 as source, and a line chart in the group footer which uses the same Query1 as source with linked data fields to establish grouping for the charts. When executed, the report shows numeric/text data fields correctly and has space for the charts but no charts are shown.

If the linked data fields for the chart are removed/deleted, the charts are shown but with all the data points in each chart (ie not grouped). I understand that this is expected behaviour without linked data fields.

A workaround has been found (see bug 100569) whereby the report query is duplicated: one query is used as source for the report and the duplicate query as source for the chart. Then the charts are shown correctly. However, IMHO this is a bug when Report Builder cannot use the same query for text and chart for the same grouped data in the same report.

This issue also arises with XY charts.
Comment 1 Robert Großkopf 2016-07-19 18:36:27 UTC
Could confirm the buggy behavior. Data in a chart couldn't use the same datasource as the report if the charts should show the data of only one group. Linking field from report to data will hide the whole chart.

Example, how it must be: https://bugs.documentfoundation.org/attachment.cgi?id=126250
Here the data for the chart are the same, but the datasource is a second query with the same content.
Comment 2 QA Administrators 2018-06-25 02:40:54 UTC Comment hidden (obsolete)
Comment 3 branestawm 2018-06-25 09:19:26 UTC
(In reply to QA Administrators from comment #2)

AFAIK, charting in LO Base v6 is comprehensively broken, so I can't test this bug in LO v6.

I have tried most releases (from TDF website) since LO v5.3, and have found that charting in LO Base is broken in one way or another in all them. Running a chart report produces a blank space where the chart should be. Clicking on a chart in Report Builder (to edit it or check settings) likely crashes LO Base. So I am sticking with LO v5.3.6.1 in a separate install for Base reporting, which still works for me (well, works well enough).

Text reports in LO Base v6 and previous versions work well. Report Builder 
seems a lot more stable than it was. So the regression with charts is disappointing - and hard to understand as there seems to have been no changes in LO Base functionality (nothing in release notes).

I have experimented with scripts to recreate chart reports for each new LO release, because recreating the reports has resolved some issues in the past, but without success for charts. It seems to me that the issues are not in Report Builder itself but with the underlying API.

Just to confirm that I am running LO from TDF on OpenSuse 42.3 x64.
Comment 4 QA Administrators 2019-06-26 02:46:48 UTC Comment hidden (obsolete)
Comment 5 Robert Großkopf 2019-06-26 13:43:20 UTC
Bug couldn't be tested, because charts aren't shown since LO 5.4.0.3. See bug 117162
Comment 6 branestawm 2019-06-26 22:51:55 UTC
(In reply to Robert Großkopf from comment #5)
> Bug couldn't be tested, because charts aren't shown since LO 5.4.0.3. See
> bug 117162

Seconded. AFAIK, charting in LO Base v6 is comprehensively broken, so I can't test this bug in LO v6.
Comment 7 QA Administrators 2021-06-27 04:19:13 UTC Comment hidden (obsolete)
Comment 8 Robert Großkopf 2021-06-27 06:19:46 UTC
Bug couldn't be tested, because charts aren't shown since LO 5.4.0.3. See bug 117162
Comment 9 branestawm 2021-06-29 18:05:42 UTC
Seconded (I agree with previous comment).
Comment 10 Alex Thurgood 2022-04-01 09:21:54 UTC
Bug still reproducible in

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 040b3198fde3385e19e7380fdcabae84a0abac9d
CPU threads: 8; OS: Mac OS X 12.2.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded