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

Can i Hide columns in gride

Sunil1

Hello all,

In birt report i have used gride.
see in the attached image. In that I want to hide column which contains dataset field "[OBM]" when my COUNTER variable is greater than 0.

Find more posts tagged with

Comments

mwilliams

Select the grid, then select the tab above the column, then go to the visibility section of the property editor and create the expression that checks this variable. That should do it.

Sunil1

williams thanks for your reply, 
 
actually i want to hide column based on the value of one of my dataset field "dataSetRow["OBM_BF_CORR"]" 
 
for that i have written following fx(expression) in visibility property. 
 
if(dataSetRow["OBM_BF_CORR"]>0) 
{ 
true 
} 
else 
{ 
false 
} 
 
But its not working..... still it displays whole column 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif 
 
Thanks,

mwilliams

Is the grid bound to the dataSet with this column in it? Or just the data binding? If your grid is not bound to the dataset, adding a text box from the palette to the very top of report, hiding it, initializing a variable in your initialize method, like, visibilityCheck = 0, in the onFetch of your dataSet you would set it to the row value with, visibilityCheck = row["OBM_BF_CORR"], then changing your visibility expression to check for this variable's value, and remembering to bind the text box to your dataSet with this field should do it for you. If you do have the grid bound to the dataSet you could probably try row["OBM_BF_CORR"] instead of dataSetRow in your visibility statement to see if it works before doing the other. Let me know if you have questions.