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

birt crosstab get data from dataset

AhmedAlaa

i want to make a global variable which get the data from a column in the dataset 
and use this global variable in a crosstab report.
 
i defined a new variable and set this variable as a global variable, using below code
 
var naturalcolor; 
reportContext.setPersistentGlobalVariable("naturalcolor",dataSetRow["natureColor"]);
 
then i use the ( naturalcolor ) in the measure value of the crosstab
 
 
importPackage(Packages.java.lang); 
reportContext.getPersistentGlobalVariable(naturalcolor); 
if ( measure["Value1"] != null ){ 
this.getStyle().backgroundColor = naturalcolor; 
}
 
but i think that the report doesn't seem to read the global variable as the value didn't change it's background color.
 
Any Help Please ??!!!!

Find more posts tagged with

Comments

pricher

Hi,
 
The best area to script for crosstabs is on the onCreate method of the crosstab itself. From there, you can choose between the onCreateCell or onCreateCrosstab function to dynamically change the behavior of your crosstabs.
 
The following article gives a good introduction to the API available at the crosstab level: <a data-ipb='nomediaparse' href='http://birtworld.blogspot.fr/2010/02/birt-crosstab-scripting.html'>http://birtworld.blogspot.fr/2010/02/birt-crosstab-scripting.html</a>
 
As well, I have attached a quick example that shows how to change the background color of a cell by scripting the above mentioned method.. The color information is saved in a persistent global variable set in the beforeOpen method of the data set.
 
Hope this helps,
 
P.