Hide Grid based on Data Value

I have a dataset which returns only one row. I want to hide a grid in the report based on the value of a particular field. How to do that? I know visibility of grid row can be set but in expression builder of grid row, datarow value is not accessible. :S I have attached the screenshot of what exactly I want to achieve

Find more posts tagged with

Comments

sadiqkhoja

Is it really a difficult question?

XFabien

hello, when you select the grid, you can bind the dataset in the 'binding' tab. hope this help.

kclark

From the onCreate() of the data element you can use a script like this<pre class="_prettyXprint">if(this.value == /*some value*/) { reportContext.getDesignHandle().findElement("mygrid").getDetail( ).get( 0 ).drop();}</pre>You'll need to make sure your table is named, in this example my grid is named "mygrid"

superbeda

Hello I tried to insert the code but It doesn't works.
I tried also to insert the following code into beforeFactory event but my grid is drop also in html format:
 
var tGrid = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("grid1"); 
if (reportContext.getOutputFormat() != 'html'){ 
tGrid.drop(); 
}