How do I jump to another report based on a value in my current report. The report that I am jumping from has no parameters, just values.

Hello, Does your target report have parameters? For example, you want to go to the target report and run it with the value you selected on the current report? Or are you saying... If the field value is betweena and b, go to report 1, if it's between b and c, go to report 2, otherwise go to report 3. Can you explain a little more about your situation? Jarret

the report I am jumping from has no parameters. I want to be able to click on a value and have it jump to another report. That report possibly being jumped toomight or might not have parameters. I just used the following expression and it works to a degree, but it enables all the values in the column for jumping, rather than just the report I want =iif(Fields!YN_DESC.Value="A","Report 1","Report2")

Sorry for the delay... Thiswill only enable the "A" values to jump to a report (Report 1), any other values will not havethe jump to enabled. =Switch(Fields!YN_Desc.Value = "A", "Report 1") If you need to add additional conditions... Example, if the value is "C"- Report 31, "D" - Report 7. =Switch(Fields!YN_Desc.Value = "A", "Report 1", Fields!YN_Desc.Value = "C", "Report 31", Fields!YN_Desc.Value = "D", "Report 7") Hope this helps. Jarret

This is useful, but how do I set parameters dynamically. The reports I am calling have different parametes and different # of parameters. Thx

Hi Jarret, Thank you for give me clue for Jump To Report Action. also i get clue from your logic For Jumping parameterised I have written the iif Condition to pass parameter valu from one report to next report. Thanks again Parikshit

My report does the same thing, all the values in the column are enabled for jumping. How do i just make it jump to just the report i want?