Empty result set

I am trying to produce a report with the page headers always showing. If the
result set is empty I need to add a "No entries found for the selected
criteria" line below the headers. If I use the NoRows property it does not
include the headers in the report, which is a requirement. Is there a way to
do this?What I do is add a table footer, and in that footer put an expression that
says iif(count(Fields!yourdata.value)=0,"No entries found","").
"MikeS" wrote:
> I am trying to produce a report with the page headers always showing. If the
> result set is empty I need to add a "No entries found for the selected
> criteria" line below the headers. If I use the NoRows property it does not
> include the headers in the report, which is a requirement. Is there a way to
> do this?|||I've tried to do this with the footer, but I get a message indicating
otherwise:
The value expression for the textbox â'textbox5â' refers to a field. Fields
cannot be used in page headers or footers.
I'd love to avoid sending a blank report, but if a 'no data is found'
message will work, that would be good. can you guys help?
-- Lynn
"dachrist" wrote:
> What I do is add a table footer, and in that footer put an expression that
> says iif(count(Fields!yourdata.value)=0,"No entries found","").
> "MikeS" wrote:
> > I am trying to produce a report with the page headers always showing. If the
> > result set is empty I need to add a "No entries found for the selected
> > criteria" line below the headers. If I use the NoRows property it does not
> > include the headers in the report, which is a requirement. Is there a way to
> > do this?