Hi guys, I've got a requirement, that when the sql statement returns no values, a text should be generate in the report, that say, that the report is empty.
My question is, how can I find out, if the sql is empty?
You can use the Report.NoDataBehaviors property to define what happens when no data is returned from your connected dataset. You will want to use the ndBlankReport and ndMessageOnPage options.
See the topic in the RB help for this property for more information as well as the topic on the Report.OnNoData event.
Comments
You can use the Report.NoDataBehaviors property to define what happens
when no data is returned from your connected dataset. You will want to
use the ndBlankReport and ndMessageOnPage options.
See the topic in the RB help for this property for more information as
well as the topic on the Report.OnNoData event.
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com