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; } } }

Setting MarkerLine by script (source from db)

minthril

Hello,I would like to set 2 MarkerLines dynamically. The one has its value from parameter (and I was able to do it by myself. See attachment) but the second has source from Data in table (in Grid..) ... and I have no idea how to write properly handling of this situation.. Do anyone could help me to set MarkerLine value(label - "valFromTable")? Please look at attachment. It is code for setting MarkerLine in chart - onRender<pre class="_prettyXprint">importPackage(Packages.org.eclipse.birt.chart.model.component.impl);importPackage(Packages.org.eclipse.birt.chart.model.data.impl);importPackage(Packages.org.eclipse.birt.chart.model.attribute);importPackage(Packages.org.eclipse.birt.chart.model.attribute.impl);importPackage(Packages.org.eclipse.birt.chart.util);function beforeDrawMarkerLine( axis, markerLine, icsc ){if(markerLine.getLabel().getCaption().getValue() == "paramValue") { var cdt = icsc.getExternalContext().getScriptable().getParameterValue("paramValue"); markerLine.setValue(NumberDataElementImpl.create(cdt)); markerLine.getLabel().getCaption().setValue("param val: " + cdt); }}</pre>Best regards,minthril

Find more posts tagged with

Comments

GLO_FR

Hi, you can do the same by using a variable in which your store the value from the db. On the OnCreate event of your table cell, create a variable.<pre class="_prettyXprint _lang-js">reportContext.setPersistentGlobalVariable("MarkerLineValue",this.getValue()); </pre>Use it in the chart the same way you've done it with the parameter value.<pre class="_prettyXprint _lang-js">function beforeDrawMarkerLine( axis, markerLine, icsc ){var cdt="";if(markerLine.getLabel().getCaption().getValue() == "parameter") { cdt = icsc.getExternalContext().getScriptable().getParameterValue("parameter"); markerLine.getValue().setValue(cdt); markerLine.getLabel().getCaption().setValue("parameter: " + cdt); } if(markerLine.getLabel().getCaption().getValue() == "valFromTable") { cdt = icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("MarkerLineValue"); markerLine.getValue().setValue(cdt); markerLine.getLabel().getCaption().setValue("Value from db : " + cdt); } }</pre>Here is your example updated

minthril

Thanks a lot!

I tried something like this but without proper result

Your updated file had problem with chart - I corrected (used your tips) my file in first post - for people who need it - there is example of solution

GLO_FR

Hi, Sorry for that, I've used BIRT Designer Pro, so maybe, the version in not the correct one. Here is the same report in BIRT 3.7.2

minthril

Hello again,
I have question about setting the height of label near MarkerLine. Now I have situation that two MarkerLines are very close and the Labels overlaps. Is there some easy way to set one Label little lower than the second one? (Please see attached image - I would like to have design like for red "text1" and "text2")
 
In my design I use the almost the same script as used in example.rptdesign
 
Thanks for help
 
Best regards,
minthril