Choosing not to display a table row

Hi, I'm fairly new to BIRT reports and have what I'm hoping will be a simple question!

My report prompts the user to choose what value to display on screen, however if this value is 0 then I want to supress the row, normally I'd do it in the SQL but for this query I can't (or at least haven't yet found a way to do it!). Is there a way in BIRT when it's filling the table to say ignore this row?

Thanks in advance
Jules

Find more posts tagged with

Comments

BRM

If you can do what you want in SQL then could you pass the report parameter that the user sets to the SQL query and suppress the row that way?

I am sure there is a javascript way to suppress the row but I am less familiar with those. I tend to do as much as I can with SQL.

johnw

Select the Detail row in the report design. In the Property Editor, go to the Visibility sub-tab. For the expression, use something like the following expression: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (params["valueToDisplay"] == "0")
true;
</pre>
 
The way visibility expressions work is it will hide when the expression returns true. 
 
You can also use Filters.