In case of RDLC reports, you get the dataset on the frontend and then bind it with the report. You can check the dataset before binding it with report and generate propper message if dataset is empty.
In reporting services, you can provide no data message in the report. Here is the link;
http://technet.microsoft.com/en-us/library/cc645968.aspx
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]
here[/font][/url][/right]