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