CODEWITHSUNDEEP
reporting-serviceshyperlinkparametersssrs-2008ssrs-2008-r2
Aruna Raghunam
Aruna Raghunam

Reputation: 921

SSRS Hyperlink report with parameters not working properly

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?

Upvotes: 0

Views: 1040

Answers (1)

StevenWhite
StevenWhite

Reputation: 6034

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

Upvotes: 0

Related Questions