Reference Empty Data Set

I have a dataset that sometimes is empty. I have it as a detail row in a table on the report, but since the dataset is null the row does not appear. What I would like to do is have it say "No results" if there are no results, otherwise have it show the results.

I tried to add a textbox and reference the textbox on the table, but it was a no go.

Here is what I had in my textbox

<code>
=code.noRows(ReportItems!table8!textbox30)
</code>

and this is what I was using in the code

<code>
Function noRows(byVal result) as string
if result = "" then
noRows = "NO Results"
else
noRows = result
end if
end function
</code>

Can anyone assist me with how to do this

Thanks

Answer this question

Reference Empty Data Set

lucone
When I use that my header disappears. Is there a way around this
I need the "No Results" to appear on the detail line and the header to stay regardless.

Thanks
Jolyqr

No. If you use the NoRows message property, it will replace the entire table.

-- Robert
ChildGuidanceCenterGB

Try this:

Data regions (matrix, table, list, chart) have a so-called NoRows property. If set, this is the message to display in a textbox (that replaces the data region when no rows of data are available).

Note: the NoRows property is available in the VS properties window.

-- Robert
Reference Empty Data Set

Answer this question