Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Access Dataset Result in Script
Access Dataset Result in Script [message #1798552] Tue, 20 November 2018 10:49
Stefan W. is currently offline Stefan W.Friend
Messages: 5
Registered: July 2018
Junior Member
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"

Previous Topic:Merging Similar Data of multiple rows and showing as one
Next Topic:Preview tab is missing
Goto Forum:
  


Current Time: Fri Nov 15 15:45:36 GMT 2019

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

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

Back to the top