RS2k - Display text to say there are no rows?

Hi,

This is probably an easy one, but its been bugging me.

If I have no rows for a particular table, is there any way that I can simply display some text saying something like 'no data available for report' ?

Similarly, I was thinking I could hider certain controls on the report if there are no rows available by using an expression in the Visible property of the control.

Any suggestions are appreciated.

Regards.

MrPeds

In the VS Properties (not the Properties from the context menu) there is a NoRows property that is the Text you want displayed when the dataset returns no rows. There is not a way to determine from the table at run time if there are any rows or not, but you can get a row count on DataSet1 like:

Code Snippet

=CountRows("DataSet1")

Hope this helps.

Larry