Switch in SSRS
I am trying to create and action to jump to another report and pass a paramater to that report if the value is true (displayed as "Yes") If it's false - i do not want it to perform any action and formatted as a non hyperlink.... any thoughts?KDW
March 10th, 2011 4:59pm

You could use an expression in the Action Jump to URL property.. =iif(somecondition = false, "","http://www.microsoft.com") If the expression resolves to an empty string, you won't get the hand icon appearing when the mouse hovers over the hyperlink. I believe the other action types have the same behaviour.
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 12:33am

I am using a value in the current report pass in as a paramater to the subreport....I do not think this will workKDW
March 11th, 2011 12:43am

I have a jump to report defined as so -> ="Myreportname", the parameters are selected after clicking the parameters button (RS2005) The Jump To Action works. If I change it to an iif -> =iif(1=0,"MyReportName",Nothing) so that it becomes Nothing, the icon doesn't change when hovered over. Check the following thread which also discusses this technique :- http://social.msdn.microsoft.com/forums/en-US/vsreportcontrols/thread/0945d3ba-478a-40fc-b9db-01734cd0c5a9 (Sorry, my previous post contained an error, the false condition needs to evaluate to Nothing, rather than an empty string.)
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 12:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics