hi ! we have a requirement like when a textbox with the table getting populated with any value the hyperlink has to work else it should remain as ordinary text box . Can it be done ?? I tried using the formula 'IIF(Filed!No.Value<>"",Report,"")' in the expression of the report name, but it dint work. kindly advice !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

IIF( Field!No.Value<>"","Reportname",NOTHING) Assuming there will not be numm values in the No field.

IIF( Field!No.Value<>"","Reportname",NOTHING) Assuming there will not be numm values in the No field. Dear Kumar, Thts not working. I am still able to get the hyperlink in that text box when the box holds no value and its allowing to the linked report with null result sets. The field of that textBox holds alphanumeric value. any help ?? please ... --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi Radhai, Based on your requirements, you can try to use the following expression to achieve it: =IIF(Fields!No.Value=Nothing,Nothing,”Your_ReportName”) For more information about Adding Links to a Report, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms159088(v=sql.100).aspx Thanks, Bin Long

Hi Radhai, Based on your requirements, you can try to use the following expression to achieve it: =IIF(Fields!No.Value=Nothing,Nothing,”Your_ReportName”) For more information about Adding Links to a Report, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms159088(v=sql.100).aspx Thanks, Bin Long Thank you Bin !! It worked. !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------