After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 638971 - Multicolumn report does not show more than one graph
Multicolumn report does not show more than one graph
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Reports
2.4.x
Other All
: Normal normal
: ---
Assigned To: Andreas Köhler
Andreas Köhler
: 600487 635636 641627 675455 682652 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2011-01-08 08:23 UTC by jdldec
Modified: 2018-06-29 22:51 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Screenshot from an error in custom multi-column report (115.09 KB, image/jpeg)
2011-01-14 17:29 UTC, Maple Aikon
Details
Multicolumn report setup example (60.81 KB, image/jpeg)
2011-01-29 15:20 UTC, Trig
Details
Screenshot GnuCash 2.5.0 (Ubuntu 12.04) (104.99 KB, image/png)
2013-04-29 10:28 UTC, Carsten Rinke
Details
Screenshot GnuCash 2.5.3 (Ubuntu 12.04) (152.00 KB, image/png)
2013-07-09 19:38 UTC, Carsten Rinke
Details

Description jdldec 2011-01-08 08:23:07 UTC
While updating my gnucash 2.3.0 to 2.4.0 I noticed that my reports with more than one graph was only able to pull one graph in the report
I.e. in a income and expense chart, I would only see the expense pie chart.

Currently, to solve this, I need to make severel reports instead of a multicolumn report.

Any one encountered this too? And is there a solution to it?
Comment 1 Maple Aikon 2011-01-14 17:29:26 UTC
Created attachment 178336 [details]
Screenshot from an error in custom multi-column report

When using GnuCash 2.4.0, using custom Multicolumn report will not display the charts except the first one. Got 'Unable to display pie chart' or 'Unable to push bar chart' error message. Please fix this bug quickly cause it's very important to me. Thanks in advance
Comment 2 Trig 2011-01-29 15:20:06 UTC
Created attachment 179592 [details]
Multicolumn report setup example
Comment 3 Trig 2011-01-29 15:24:14 UTC
Can confirm this issue also. Have just upgraded from 2.2.9 to 2.4.0 (on Windows Vista Ultimate 64bit).
Had an existing 2 x 2 multicolumn report that worked great in 2.2.9. Now only the top left report shows the graph, all the others state "Unable to push bar chart". Clicking on the "Single Report" link will open the report and chart correctly.
Tried creating a new multicolumn report (see example above) with nothing more than two reports ("Expense Barchart" and "Net Worth Barchart" with default setup) - and get this issue.
Comment 4 Evan Scott 2011-02-04 02:41:15 UTC
I can confirm this issue also (Mac OS X 10.6.5, GNUCash 2.4.0). Seems the system can only handle one chart; the rest do not get displayed. 

These are the last lines in Console.log related to Mac OS X

2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetFont: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetFontSize: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetTextMatrix: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextClearRect: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetRGBFillColor: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextShowGlyphsAtPoint: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetFont: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetFontSize: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetTextMatrix: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextClearRect: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetRGBFillColor: invalid context 0x0
2/3/11 3:59:53 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 15:59:53 EvansMini.local Gnucash-bin[410] <Error>: CGContextShowGlyphsAtPoint: invalid context 0x0
2/3/11 4:00:21 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 16:00:21 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetFont: invalid context 0x0
2/3/11 4:00:21 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 16:00:21 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetFontSize: invalid context 0x0
2/3/11 4:00:21 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 16:00:21 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetTextMatrix: invalid context 0x0
2/3/11 4:00:21 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 16:00:21 EvansMini.local Gnucash-bin[410] <Error>: CGContextClearRect: invalid context 0x0
2/3/11 4:00:21 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 16:00:21 EvansMini.local Gnucash-bin[410] <Error>: CGContextSetRGBFillColor: invalid context 0x0
2/3/11 4:00:21 PM	[0x0-0x23023].org.gnucash.Gnucash[410]	Thu Feb  3 16:00:21 EvansMini.local Gnucash-bin[410] <Error>: CGContextShowGlyphsAtPoint: invalid context 0x0

Seems like maybe GNUCash isn't actually calling the chart backend after the first one is placed in the report? 

I'm not a programmer :(
Comment 5 Trig 2011-02-05 11:50:20 UTC
Just ran the debug log myself - this time doing nothing more than create a custom report, and adding expense barchart twice (that's all), and then click ok.
Think this is the relevant section of the log (don't know how to do a trace in windows :-( );

<repeats the same pattern (<gnc.scm> list...) of below DEBUG messages a few more times before section below>
*  DEBUG <gnc.scm> list(#f)
*  DEBUG <gnc.scm> list()
*  DEBUG <gnc.scm> list(#f #f #f #f #f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f #f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f)
*  DEBUG <gnc.scm> list(#f #f)
*  DEBUG <gnc.scm> list(#f)
*  DEBUG <gnc.scm> list()
*  DEBUG <gnc.scm> list(#f #f #f #f #f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f #f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f #f)
*  DEBUG <gnc.scm> list(#f #f #f)
*  DEBUG <gnc.scm> list(#f #f)
*  DEBUG <gnc.scm> list(#f)
*  DEBUG <gnc.scm> list()
*  DEBUG <gnc.scm> list(#t #t #f #f #f #f #f #f #f #f #f #f)
*   INFO <gnc.gui> [gnc_plugin_page_report_destroy_widget] destroy widget
*   INFO <gnc.gui> [gnc_plugin_page_report_destroy_widget] destroy widget
*   INFO <gnc.gui> [gnc_plugin_page_report_destroy_widget] destroy widget
*   CRIT <gnc.import.aqbanking> gnc_plugin_ab_account_selected: assertion `GNC_IS_PLUGIN_PAGE(plugin_page)' failed
Comment 6 Trig 2011-03-06 20:33:03 UTC
Just upgraded to 2.4.3 - problem still exists :-(
Noticed these duplicate bugs - all appear to report same problem;
Bug 600487
Bug 641627
Bug 635636
Comment 7 Dohko 2011-03-20 15:34:58 UTC
Problem persists with 2.4.4
Comment 8 Geert Janssens 2011-04-29 15:39:58 UTC
*** Bug 600487 has been marked as a duplicate of this bug. ***
Comment 9 Geert Janssens 2011-04-29 15:40:27 UTC
*** Bug 635636 has been marked as a duplicate of this bug. ***
Comment 10 Geert Janssens 2011-04-29 15:50:02 UTC
*** Bug 641627 has been marked as a duplicate of this bug. ***
Comment 11 Dohko 2011-06-02 01:00:01 UTC
Same problem with 2.4.5, 2.4.6
Comment 12 Steve Yrjänä 2011-08-07 11:21:35 UTC
Same problem with 2.4.7, tried both Fedora 15s RPM and self-compiled from SVN: http://svn.gnucash.org/repo/gnucash/branches/2.4 revision 21116
Used --with-html-engine=webkit for configure, because gtkhtml 3.x was not available.

Also reported in here:
https://bugzilla.redhat.com/show_bug.cgi?id=728734

It worked with Fedora 14 and gtkhtml 3.14, I remember having same problems with the official Fedora RPM version, and self-compiling from SVN helped back then.

Did a check on that with my old Fedora 14 installation, and could confirm the following cases:
* Fedora 14 RPM does not work
* self-compiled from SVN works
* self-compiled from SVN with webkit engine does not work
Checked how the Fedora RPMs are compiled, and they use webkit. So the problem seems to be webkit related.
Comment 13 Gabor Nagy 2011-11-12 22:57:23 UTC
I have the same problem with version 2.4.7 running on Windows 7

Why is this unconfirmed still? Many people complaining, and very easy to verify.
Comment 14 Geert Janssens 2011-11-14 16:52:17 UTC
(In reply to comment #13)
> I have the same problem with version 2.4.7 running on Windows 7
> 
> Why is this unconfirmed still? Many people complaining, and very easy to
> verify.

Good point. I have changed the status.
Comment 15 Evan Scott 2012-02-13 19:49:31 UTC
Issue Persists with GnuCash 2.4.10 on Mac OS X 10.7.
Comment 16 Dohko 2012-08-04 16:05:31 UTC
Problem persists with 2.4.11 on Windows 7 64
Comment 17 Mike Evans 2012-08-26 12:37:29 UTC
*** Bug 675455 has been marked as a duplicate of this bug. ***
Comment 18 Mihail Lukin 2012-08-26 15:37:48 UTC
*** Bug 682652 has been marked as a duplicate of this bug. ***
Comment 19 Christoph 2012-10-06 19:03:56 UTC
Same issue here, has been around since 2.4.1.

Currently using 2.4.11, built from svn r22268 on 2012-07-15. Running on Win 7 Enterprise 64-bit.
Comment 20 Geert Janssens 2012-11-12 22:13:03 UTC
I finally managed to trace this issue to its root cause. I have committed a fix in trunk (r22542) and 2.4 (r22543). It will be available in the next GnuCash release.
Comment 21 Carsten Rinke 2013-04-29 10:28:06 UTC
Created attachment 242789 [details]
Screenshot GnuCash 2.5.0 (Ubuntu 12.04)

Unfortunately I cannot confirm the fix. See the attached screen shot.
GnuCash 2.5.0 on Ubuntu 12.04
built from git rev f6de8e1+

The former error message is gone but all graphs overlap in one table cell.
This bug should be re-opened.
Comment 22 Geert Janssens 2013-04-29 19:34:16 UTC
Thank you for verifying. I can indeed confirm the report got broken again since I applied the fixes. I wonder if the jqplot code is interfering.
Comment 23 Geert Janssens 2013-05-02 14:44:10 UTC
The issue was indeed jqplot related: jqplot uses a div with a predefined id to render its charts. This works fine when there's only one chart on the report. It breaks once multiple charts are added to one report (as is the case in the multi column report).

I have fixed this by generating a unique id for each chart to render (r22935 in svn). The fix will appear in the next development snapshot.

The stable branch shouldn't be affected, because that one is not using jqlot based charts.

Thanks again for testing and reporting the issue.
Comment 24 Carsten Rinke 2013-07-09 19:38:13 UTC
Created attachment 248772 [details]
Screenshot GnuCash 2.5.3 (Ubuntu 12.04)

Looks much better then before, now all charts are displayed.

Nevertheless, there is still an issue about it:
When you have a mix of chart types (bar charts and pie charts) then the pie charts do not work if the last chart is a bar chart.

Example: Run the Welcome Sample Report from the Sample & Custom menu.
The Expense and Income charts will be displayed as bar charts even though they have been added as pie charts (see attachment). Effect: There is no data in the charts.

I tried the following:
Create a new custom multicolumn report and add an expense pie chart and an expense bar chart.

Order A:
1. Expense Pie Chart
2. Expense Bar Chart
-> same effect has above.

Order B:
1. Expense Bar Chart
2. Expense Pie Chart
-> works as expected

Let me know if this effect should be handled in a separate bug - I can copy this comment over into a new bug, no problem. I was looking for an existing one but I did not find it.
Comment 25 Geert Janssens 2013-07-14 16:52:29 UTC
Carsten,

Thank you for the additional QA testing. I suspect the problem you experience is still an issue with the new jqplot code.

Since the orignal bug was about a broken multicolumn report before jqplot was introduced, perhaps it's better to create a new bug report for the jqplot issues. Jqplot doesn't affect the 2.4 series (for which this bug report was initially created). So starting a new bug report will make it easier to track. Thanks!
Comment 26 Carsten Rinke 2013-07-19 07:47:05 UTC
Done.

Comment 24 has been moved to:
Bug 704525 - When you have a mix of chart types (bar charts and pie charts) then the pie charts do not work if the last chart is a bar chart
Comment 27 John Ralls 2018-06-29 22:51:15 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=638971. Please update any external references or bookmarks.