Display Error Message if SQL returns no Data

indie

Hi,<br />
<br />
i've designed a report with some input parameters, passing them to the sql statement.<br />
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.<br />
<br />
<strong class='bbc'>is there a possibility to display an info message if no data is returned by the sql statement?</strong><br />
<br />
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?<br />
<br />
________________________________________<br />
I've read the hints from Virgil, which sound great and would be exactly what i need, but (Total.count() < 1) doesn't work for me ... should Total reference the DataSet?<br />
<a class='bbc_url' href='http://www.birt-exchange.com/forum/designing-birt-reports/8801-handling-no-data-conditions-tables-charts.html'>http://www.birt-exchange.com/forum/designing-birt-reports/8801-handling-no-data-conditions-tables-charts.html</a&gt;

mwilliams

Hi indie,<br />
<br />
Here is a link to an example I posted in the devShare that shows one way to achieve this.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/522-birt-display-quot-no-data-quot-when-table-is-empty-example/'>http://www.birt-exchange.com/devshare/designing-birt-reports/522-birt-display-quot-no-data-quot-when-table-is-empty-example/</a><br />
<br />
Hope this helps.