SSRS Hyperlink report with parameters not working

问题:

Main report which drills down to Register URL

I have main report with 3 parameters and have 3 levels of drill downs. The last drill down is to register level and it shows a hyperlink when clicked on it, it should directly take user to register report.

i.e If clicked on 1st URL – 000018045 – Cert in Childcare but it takes me to different one as below

Embedded report in hyperlink

Everything works fine in my report except hyperlinked report which showing different values other than user selected in main report drill down list.

I made sure I am using same parameters in both reports and identical datasets.

Any idea where am I going wrong?

回答1:

When using the hyperlink action in SSRS you have to encode the URL to handle all the characters. Here's an article that explains it to get you started: http://capstonebi.blogspot.com/2010/04/url-encoding-in-reporting-services.html