Jump to Report Without Parameters

Hi,

Is there any way in Rs2000 "Jump to Report" Action, to pass only some off the target report parameters, and when the report opens fill the rest from the target report parameter area?

I can make this work in VS2003 but not in Report Manager.

In Report Manager when you click the link it just clear the screen and stays like that.

Thank you for your help

Rgranada

i do have a crude way of doing it and i still looking out for the best way to do it.

for example, lets take @.Empno is the parameter and u want to make it optional

so declare another variable like @.ES

when u r passing employee number , then pass @.ES = 'S' ( means selected)

when u do not want to use @.EmpNO , then pass @.ES = 'A' (means all)

use in ur query

where (@.EmpNo = '123' and @.ES = 'S') or (@.EmpNo like '%' and @.ES = 'A')

hope this works for u

Jump to report

Hi all,

I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?

regards,

Bill

I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.

The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url

|||Just a bump. Hoping someone has some insight here.

Jump to report

Hi all,

I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?

regards,

Bill

I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.

The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url

|||Just a bump. Hoping someone has some insight here.

Jump to report

Hi all,

I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?

regards,

Bill

I am having the same issue. I have a report that you can jump to via a hyperlink with parametes but I also need the ability to jump to the report and have the user get prompted for the parameter. Works in Visual Studio but not when I deploy.

The only workaround I have found is to use the jump to URL and put the "http//<servername>/reportserver?/<FolderName>/<reportname>" in there. You'd have to tack on the report parameters on the end of the url

|||Just a bump. Hoping someone has some insight here.sql