error message for blank reports -- sql server reporting services

bevarg
3/10/2006 6:36:28 AM

When requesting reports, if a user supplies values in the parameters
for which there is no data on the database, how can I stop him/her on
this screen with an error popup display box or a message on the report
like 'no records available for the specified criteria' instead of
generating a blank report with only headers and footers.

KimB
3/10/2006 8:03:21 AM

I am not sure about the other data regions such as list or matrix, but I know
that if you are using a table you can go into the table properties and put
the message that you would like to display under the "No Rows" property.

[quoted text, click to view]

Jim
3/10/2006 8:15:54 AM

Check the NoRows property of the table. You can enter a message there.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : error message for blank reports