Hi, I have added 'mailto:' for mailing the clients in my report at the action property of an image in report. This works fine but now i want to include a hyperlink that should change according to the filters in the report. I am using it as -------------------------------------------------------------------------------------------------------------------------------------------------- & "http://abcd/reportserver?%xyz %3aParameters=false&rc%3aToolbar=false&rc%3aSection=0&rs%3aCommand=Render&PARM_A=" & @A & "PARM_B=" & @B & "PARM_C=" & @C -------------------------------------------------------------------------------------------------------------------------------------------------------- where @A,@B,@C are the parameters(filters) in the report. this gives me error for hyperlink as [BC30277] Type error '&' does not match declared datatype 'Object' Any help would be appreciated

Hi dpkas, In Reporting Services, we can pass report parameters to a report by including them in a report URL. Based on your requirement, you can try to use the following URL address when you add a “Go to URL” action: ="http://abcd/reportserver?%xyz %3aParameters=false&rc%3aToolbar=false&rc%3aSection=0&rs%3aCommand=Render&PARM_A=" & parameters!A.Value & “&PARM_B” & parameters!B.Value & “&PARM_C=” & parameters!C.Value For more information about Add a Hyperlink to a URL and URL Access, please refer to the articles below: http://msdn.microsoft.com/en-us/library/ms157159(v=sql.100).aspx http://msdn.microsoft.com/en-us/library/ms153586(v=SQL.100).aspx If you have any more questions, please feel free to ask. Thanks, Bin Long Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Trying your way Bin gives me error for '&' ,saying type do not match.Instead i used replace("link","","") which replaces '&' by '%26' . This worked fine with me and the error no more appears now. Thanks