I'm kinda confused, cause my problem seems so simple and obvious but i couldn't find a solution to my problem.
I'm using the report designer and got a DataSet
Select Count(column) as c
From ?
Where date = CONVERT(?, DATE)
So what i want to do is store the result of this query in a birt param called visibility. At some Row of my Grid i added a onRender script:
(i tried various combinations here, to test whether i can access the dataset or not)
params["visibility"].value=row["Count_Entity"]
params["visibility"].value=dataSetRow["Count_Entity"]
params["visibility"].value=row["Count_Entity"].getColumnValue("c");
params["visibility"].value=dataSetRow["Count_Entity"].getColumnValue("c");
when checking the visibility param its always empty in my report.
what i actually want to archive here is to check if the count query returns more then 0 and set the visibility param to either true or false like
if(dataSetRow["Count_Entity"] == 0)
{
params["visibility"] = true;
}
else
{
params["visibility"] = false;
}
and use this param in multiple rows as visibility expression.
I'm missing the correct way to "dataSetRow["Count_Entity"] == 0"