Display Error Message if SQL returns no Data

<already posted this before, pls help me on this one!> <a class='bbc_url' href='http://www.birt-exchange.com/forum/designing-birt-reports/12061-display-error-message-if-sql-returns-no-data.html'>http://www.birt-exchange.com/forum/designing-birt-reports/12061-display-error-message-if-sql-returns-no-data.html</a> 
 
i've designed a report with some input parameters, passing them to the sql statement. 
but depending on the values provided by the user through the input params, it may happen that the sql statement isn't retrieving any row(s). 
 
is there a possibility to display an info message if no data is returned by the sql statement? 
 
i guess this is done trough scripting, could somebody help me out where's the best place to put the script and the essential code lines? Espacially when using a chart, the chart itself doesn't shows up by default but i want to display a label when no data is available due to the parameters.

Find more posts tagged with

Comments

mwilliams

Hi indie,

So, you're wanting to hide a chart if no data is returned by the query? Not a table like I showed the example for? What would you like your output to look like if there is no data in the dataSet?

indie

Hey Michael, 
 
Basically i want to display a label - if the chart has no data. 
Something like "there is no data available for your input parameters". 
 
Therefore i wanted to set the visibility of that label to true if the chart has no data to display (the sql statement isn't returning data), otherways it would be hidden. 
 
any ideas? 
thx for your support!! 
 
indie

mwilliams

indie, 
 
Since the chart already disappears when there is no data. All you need to do is worry about the label. First, bind the dataSet to the label. Then, in the visibility section for the label, you just need to put something like the following: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (row["Field_Name"] == null){
false
}
else{
true
}
</pre>
 
This should do what you're wanting. If not, let me know and I'll try to find where I messed up.

indie

Finally it works, my problem was that i did not knew that i have to bind the text element to the dataset - hence the compiler was complaining about row["..."] in the script - and i was wondering what i was doing wrong ...

THANK YOU SO MUCH for your support!!!

-indie