hi folks,
I want to display a message "no records retrieved" in the preview tab of the report in RS when no records are retrieved for a query specified in the data tab of the report in RS.Is there any custom code for this?How to accomplish this?Can anyone help me find a solution for this?Pls send me the procedure for this .
You could:
1. Set the message in the NoRows property of the data region bound to the dataset.
2. Display the message in a textbox which is hidden if the dataset has rows or visible otherwise.
|||Dear sir,
Thank you for your reply..I was successful with the first point.Can u tell me how to proceed with the second point?
How to display the message in the textbox?should i type something in the textbox value property?if so how?
Regards
Balaji
|||Drop a textbox in the report body with the desired text, e.g. "No data". Set the textbox Visibility Hidden expression to =IsNothing(First(Fields!<some field name>.Value, "<your dataset name>")) = Falsesqlsql
No comments:
Post a Comment