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.)

Show: Today's Messages :: Show Polls :: Message Navigator

Problem with Legend in Graphs [message #1779057]

Sun, 31 December 2017 12:32

×™×•×¡×™ ×•×™×’×ž×Ÿ

Messages: 2
Registered: September 2016

Junior Member

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 232 times)
Attachment: good-legend.jpg
(Size: 26.14KB, Downloaded 231 times)
Attachment: Areport-Sample.rptdesign
(Size: 229.56KB, Downloaded 260 times)
Attachment: Areport-Data.xml
(Size: 1.05KB, Downloaded 138 times)

Report message to a moderator

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

Thu, 11 January 2018 03:06

Jo Pitts

Messages: 3
Registered: January 2018

Junior Member

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).

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:12:14 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter