Throw an ExceptionError by the number of DataSet result

Kenichi

Dear, Birt Experts

Is there anyway to throw/raise the exception error if the DataSet returns no result?

I am working on the report which requires to pass parameters of date range (ie. 2011-06-10 to 2011-06-20). If my SQL on DataSet returns no value (or zero value), I would like to throw an exception error, and let user knows that the passing parameter does not hit any record.

My problem is that if DataSet returns no value, report layout is always blank. However, the contents on header or footer of master page always appears on report.

Thanks for your support.
Ken

mwilliams

Hi Ken,

You could put something like DSrows=0; in your initialize method, then, in the onFetch of the dataSet, put DSrows=1;. If there is a row in your dataSet, DSrows will change from 0 to 1. Now, you can use this variable in a visibility expression on your table to hide it if DSrows is still 0. Additionally, you can have a label in your report that says something like, "The parameters selected returned no results, please expand your range.". Then, you can use a visibility expression for this label that only shows it if DSrows is still 0. Hope this helps.