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 |
|
Amit-1234
Starting Member
19 Posts |
 Posted - 2012-09-18 : 09:52:10
|
| Hi,I am relatively new in SSRS 2008. Currently I am working on a drill -down report. The report has some user input parameters like Type and Parent Item. On the basis of these info a Header level report is created with Item Id. The details report can be viewed by clicking the Item Id.The problem I am facing is that the moment I click on the Item id for drill -down the values of the parameter variables(Type and Parent Item) are getting refreshed and the user has to manually enter the values again.I have already tried using default values and report variables, but it is not working.Kindly help.ThanksAmit |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-18 : 11:03:04
|
| have you set values for the parameters of drilldown report from parameters of main report? this should be done in jump to report or jump to url window------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Amit-1234
Starting Member
19 Posts |
Posted - 2012-09-19 : 01:21:43
|
| Thanks, your suggestion worked. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-19 : 12:14:22
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Parameter values refreshed during drill-down