Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

In REport Services, Displaying "NO data Found" in the report 1

Status
Not open for further replies.

jpower69

Programmer
Feb 5, 2008
54
US
To all, I am new to Report Services 2005. I am part of a tema converting VFP-based application to SQL Server 2005. In VFP, when i run reports, i check the function _tally() and if tally() = 0, I display a messagebox displaying
"NO Data Found For search Criteria"..
I want to do the same thing using SQL Server Report Services, but can't seem to find out how/where to do it

any suggeestions greatly appreciated

thanks in advance....
 
The report and each control has a "No Rows" property which can be set to a message for the user. This should be able to be accessed from the standard properties bar.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Thanks for the informaiton...greatly appreciated..

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top