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.

 All Forums
 Development Tools
 Reporting Services Development
 Passing input parameters to new report

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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 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

Mahalo, Mark


Go to Top of Page

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 like

secondreportparameter =Parameters!FirstReportParam.value

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

oasis1
Starting Member

35 Posts

Posted - 2012-09-11 : 17:40:31
Thanks for the help it worked !!!! Much Aloha Brew
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-11 : 23:49:23
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -