Hide/Show Data Based on a Value from Another Data Set

mwilliams

I have seen several instances where someone needs to hide a table or other report element based on the value in another dataSet. One way to achieve this would be to put the element or elements that you want to show/hide based on this value into a grid that is attached to the other dataSet. You can then hide the grid if the value meets your requirement to hide the data with a simple if statement in your visibility expression.<br />
<br />
Attached is an example created in BIRT 2.6.0 that does just this. A scripted dataSet randomly has a value of 0 or 1 in it to show this working. A grid is then tied to this dataSet. The table tied to the other dataSet is placed inside the grid. The visibility expression is set to hide the data if the scripted dataSet's value is 0 and to show if it's 1. The value from the scripted dataSet is shown at the top of the report so that you can see this working.