Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oasis1
Starting Member
35 Posts |
 Posted - 2012-09-10 : 22:48:03
|
| 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... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-11 : 00:53:35
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
oasis1
Starting Member
35 Posts |
Posted - 2012-09-11 : 14:17:28
|
quote:
Originally posted by visakh16
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 MVPhttp://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 valuesMahalo, Mark
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-11 : 14:37:44
|
| you can choose parameters from dropdown in jump to report window and map them to parameters of main report using expression likesecondreportparameter =Parameters!FirstReportParam.value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
oasis1
Starting Member
35 Posts |
Posted - 2012-09-11 : 17:40:31
|
| Thanks for the help it worked !!!! Much Aloha Brew |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-11 : 23:49:23
|
welcome  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Passing input parameters to new report