Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS/drill through reports/ parameters not getting passed.

Status
Not open for further replies.

pvidya

Programmer
Jan 26, 2007
20
US
Hi,

I have a case summary report. Each line is one case and has the case number displayed. On the case number field, I have setup a hyperlink to the case details report, which is another report in the same VS project. So, I run the summary report- I click on one of the case numbers- the detail report opens up showing that case's details.

Originally, the detail report had only one single valued parameter: Case #. And the whole setup worked fine. Now, the case detail has a few other parameters added to it. So, I came into the summary and changed the parameter linkages. After this change, clicking on the hyperlink is opening up the detail report- but its opened up like its waiting for some parameters to be entered.

The detail report now has six parameters. The first four parameters get populated with values passed in, but the fifth one does not. It just shows up blank when I click on the hyperlink like its waiting for a value.

When the detail report runs by itself, this fifth parameter works as a cascading parameter - the drop down is generated based on the first, second, third and fourth parameter's values. I do not know if that is causing this issue.

The fifth param happens to be a multi-value parameter, but I am only passing one value in. The first parameter also happens to be a multi-value, but its taking in values passed just fine. So I do not think it being a multi-value parameter is the problem. The case number which was initially the only parameter, is now the sixth/last one and is a single value.

Has anyone seen this behaviour? Perhaps you can see where I am doing something incorrect? Or possible issues that could cause this?

Thanks for your time. Any help is appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top