Wednesday, October 6, 2010

In case of no records please display the message "No Records" in SSRS

=sum(Fields!ward1.Value)
in the report i was devloped on interesting thing suppose the dataset is not returned any records in this case as per the requirement we need to show "No open work is there" ort this type of message
Solutions:-Insert a Text Box then open the properties of the text box
Text box properties screen will displaying
click on the Visibility Tab
write code on the Expression =iif(rownumber("DataSet4") > 0,true,false)
it means if the dataset have records then dispaly the text box
similarly you need to disable to the table where we display the data which is returned from the Dataset4
same press click on the Visibility Tab
=iif(IsNothing("DataSet4"),"test",false)
it means it datase4 have no records then no need to show the table

No comments:

Post a Comment