I am running a report that allows the user to change the date parameters. I want to be able to open another report from the main report where I pass the patient ID and also the beginning and end date that the user selected on the mian report. I have figured out how to open it passing the patient Id but it gives me all the patient encounter records not for the defined range. I haven't been able to find where or how to set the selected date parameters. I am using the jump to report feature. It shows me the fields from the data set but not the parameter values.... The stored pocedure runs fine if I run it independently from the SSRS with dates . Where do I find or set the parameter values? I am assuming I can set and expression but haven't figured that out... mahalo, Brew...
you can set it in jump to report window. for that you whould have same date parameters added to second report as well. Also add filters within dataset or in procedure to pass down parameter values to do the required filtering
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
you can set it in jump to report window. for that you whould have same date parameters added to second report as well. Also add filters within dataset or in procedure to pass down parameter values to do the required filtering
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Aloha and thanks for the help... How do I refer to the input parameters. On the jump to I see the dataset fields but not the dates that are set as parameteres in the master report. When I set the parameters in the secondary pop upreport how do I refer to the values
Passing input parameters to new report
Posted - 09/10/2012 : 22:48:03
