SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Passing input parameters to new report
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

oasis1
Starting Member

34 Posts

Posted - 09/10/2012 :  22:48:03  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 09/11/2012 :  00:53:35  Show Profile  Reply with Quote
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

34 Posts

Posted - 09/11/2012 :  14:17:28  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 09/11/2012 :  14:37:44  Show Profile  Reply with Quote
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

34 Posts

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

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 09/11/2012 :  23:49:23  Show Profile  Reply with Quote
welcome

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000