Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 12:32 Go to next message
יוסי ויגמן is currently offline ×™×•×¡×™ ויגמןFriend
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:

This is how it looks WRONG:

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

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

Many thanks

Re: Problem with Legend in Graphs [message #1779671 is a reply to message #1779057] Thu, 11 January 2018 03:06 Go to previous message
Jo Pitts is currently offline Jo PittsFriend
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).

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

Current Time: Tue Jul 14 23:51:21 GMT 2020

Powered by FUDForum. Page generated in 0.02164 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top