nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Legend Entries - Urgent help please

Chris605

Hi @all,
i need urgent help on this topic. I've already searched for a topic like this, but didn't find an answer.

I've generated a chart with a dataset which is an SQL-Statement. I receive the rows "name", "tscreate" and "startdate". The x-axis is specified with the row tscreate, the y1 series is specified with startdate. As optional y-series grouping I've to use the row name. Until now, no problem. But I need a second y-series which should show a standard line. This I've realized with the help of a computed column, which gets data from row tscreate and sets the day of the tscreate entry to the first (eg. recieved date 2010-03-14 --> 2010-03-01).

Now I want to display the legend only for the first y-series, but I only can choose show legend or don't show legend. It doesn't matter whether I choose it from the "Edit Chart" Dialogue Box or if I script it with the help of the "before Generation" function.

I also tried to script the whole legend (with the help of beforeDrawLegendItem()), but found no solution. I just want to display the legend once not twice for every series, or script the legend entries with the help of the row name...

Does anyone has an idea about how to solve this?

Kind regards, Chris

Find more posts tagged with

Comments

mwilliams

Hi Chris,

Are you wanting to have that border around the legend? So, just hiding the second set of values won't work?

Chris605

Hi Michael,

no the border around the legend should only show my problem. It was added to the screenshot. And yes, I've no idea how to hide the second set of values...

Chris

mwilliams

Chris,

This sample report might help you in figuring out how to hide the second set of values. Let me know if you have questions.

This report was designed in 2.5.2.

Chris605

Hello Michael,

first, thanks for your support. Unforutnately can't I use the script which you sent within your report. The reason could be a) that I've to use until now the older version of BIRT or

that I've to group the y-series. Please see the attached files, that you could have an idea, what I'm meaning:

Kind Regards

Chris

mwilliams

Chris,

So, you're unable to hide the labels when there is y-series grouping?

Chris605

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66391" data-time="1279056316" data-date="13 July 2010 - 02:25 PM">
Chris, 
 
So, you're unable to hide the labels when there is y-series grouping? </blockquote>
 
Hi Michael, yes I'm unable to hide the elements. You could try it with the report you sent. Take e.g. the row["PAYMENTDATE"] for grouping and preview the report. (Also in BIRT v 2.5.2) 
 
Any further ideas?? 
 
Thanks for your support, regards Chris

mwilliams

Chris,

With a quick test on the y-series grouping, I can still hide if I change the script to check for the actual values. I'll have to see if I can find a way to hide all the values under series 2 easier.

Chris605

Michael,
first thanks for your quick reply. Hopefully you can find a way to solve my problem. The lengend entries are coming dynamically from a MySQL database. Because of this fact, the entries in the dataset are never the same. I've tried a way with the help of the series title, but with no solution.

Looking forward to your reply. Regards, Chris

thuston

I suspect you'll want to loop and store the values. Then remove any duplicate.
This should keep the first set and remove the line set.

Chris605

Hi thuston, thanks for your reply. Would you please be so kind and explain what you're meaning? How can I remove the duplicates for a chart?

thuston

<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="66550" data-time="1279547166" data-date="19 July 2010 - 06:46 AM">
I suspect you'll want to loop and store the values. Then remove any duplicate. 
This should keep the first set and remove the line set. </blockquote>
Loop through the Label values and conditionally hide them. 
 
pseudo-code 
<pre class='_prettyXprint _lang-auto _linenums:0'>LegendMap = new java.util.HashMap();
//?? some code to traverse the Legend
if ( LegendMap.get( <currentLegendValue> ) == null ) {
rtMap.put( <currentLegendValue>, true );
}else{
//?? hide the legend value
}
</pre>

Chris605

thuston, would you please be so kind and implement the code within the report I've attached? I tried to implement the script but got always the message that currentLegendValue could not be found...
Within the report I've another script which should also hide the elements for second series, but as I've already told, when grouping the y-series, the legend doesn't disappear.

Regards, Chris

The report was designed in BIRT v 2.5.2

Chris605

Hi Michael,
I've just tried many different ways to hide the second series values within the legend. But I still don't have a satisfying solution on this topic.

Last thing I've tried was with the help of the beforeDrawLegendItem function. I've worked with lerh.getLabel().getCaption().getValue().compareToIgnoreCase("Standard") but now I had to realize, that with the help of this function not only the duplicates were eliminated.
The second series is named "Standard". Is there any way to define within the script, that if the Line Series is named "Standard" then the Legend shouldn't show any entries but the Series Line itself should appear?

Thanks for any help.

Chris

mwilliams

Chris,

This probably isn't the best solution out there, but it's the best I could figure out. It does the job, anyways. It keeps track of legend label values coming through, if it's a repeat, it doesn't show it. I also deleted the series name so it didn't show up.

Let me know if you have questions.

Chris605

Michael, first thanks for your quick reply. The script you gave me, was the same way I tried. But in fact, your script doesn't work too. I've added a screenshot, where you can see the result. I've no idea why it seems to run on your machine and not on mine. Would you please be so kind and add a screenshot of your result? Thanks

Kind regards

Chris

Perhaps do I need do add an addition package for modifying the legend?

mwilliams

Chris,

Click on the sorting/grouping button next to the optional y-series grouping box in the editor and set the grouping to year again. I had to do this to get both to group by year correctly. Then, it works. The method I used requires that the labels be the same.