Eclipse Community Forums: BIRT » Problem with Legend in Graphs

Home » Archived » BIRT » Problem with Legend in Graphs(When all data is in one direction, bar and pie show only one legend item.)

Problem with Legend in Graphs [message #1779057]

Sun, 31 December 2017 07:32

Eclipse User

When all data is in one direction, bar and pie show only one legend item.
Should show both legend items (even if one is not present in the chart)
How can this be fixed?

This is how it looks OK:
index.php/fa/31702/0/

This is how it looks WRONG:
index.php/fa/31701/0/

Attached are project files (I tried to delete most of the irrelevant code).
creatirea is: <amad>
either:
<amad>1</amad>
ot:
<amad>0</amad>

Hope this is clear and someone has a solution for this.

Many thanks
Yosi

Attachment: bad-legend.jpg
(Size: 23.53KB, Downloaded 281 times)
Attachment: good-legend.jpg
(Size: 26.14KB, Downloaded 283 times)
Attachment: Areport-Sample.rptdesign
(Size: 229.56KB, Downloaded 282 times)
Attachment: Areport-Data.xml
(Size: 1.05KB, Downloaded 177 times)

Re: Problem with Legend in Graphs [message #1779671 is a reply to message #1779057]

Wed, 10 January 2018 22:06

Eclipse User

Hi there. You probably need to build your data so you always have the series present even if there is no data for it.

for example, create a reference table that contains the values 'Right' and 'Wrong', then in your main query do an outer join based on the reference table so you always end up with a row for each category regardless of whether there is any data.

FWIW - I am an BIRT n00b, but I know a bit about SQL. The problem you are describing is a classic in SQL (for example, how do I make a query return sales per week even when there are no sales in a particular week. The easiest answer - use a reference table of weeks).

Previous Topic:	BIRT datetime function
Next Topic:	Emitter in BIRT Runtime

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 17:51:32 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter