CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008ssrs-2008-r2dynamic-url
user470091
user470091

Reputation: 41

Dynamic SSRS LInk

I am creating a SSRS report with dynamic URL. Content which is in bold is the system generated ticket number which I want to pull my the Fields!Change_Number.Value column.

Original URL

https://sm.com/webtier-9.50/index.do?ctx=docEngine&file=cm3r&query=number%3D%22**C945212658%22&action=&title=Change%20C945212658

This is what I have tried

="https://sm.com/webtier-9.50/index.do?ctx=docEngine&file=cm3r&query=number%3D%22Fields!Change_Number.Value%22&action=&title=Change%20"Fields!Change_Number.Value

Error:

The ActionInfo.Action.Hyperlink expression for the text box 
‘Change_Number2’ contains an error: [BC30205] End of statement expected.

Upvotes: 2

Views: 4230

Answers (2)

Laughing Vergil
Laughing Vergil

Reputation: 3756

To embed a field into a dynamic URL, you don't actually embed it - you append it. Here is your URL corrected:

="https://sm.com/webtier-9.50/index.do?ctx=docEngine&file=cm3r&query=number%3D" + Fields!Change_Number.Value + "&action=&title=Change%20" + Fields!Change_Number.Value

Upvotes: 0

C Black
C Black

Reputation: 1008

You need to concatenate those fields: the first is within the double quote block, so it is being taken literally and adding the string 'Fields!Change_Number.Value' to the URL, not the value that you want. The second field is just bare outside the double quotes, so it doesn't know what to do with it - that is the one causing the error.

You can concatenate strings using either + or &. See: Operators in Expressions

="https://sm.com/webier-9.50/index.do?ctx=docEngine&file=cm3r&query=number%3D%22" & Fields!Change_Number.Value & "%22&action=%title=Change%20" & Fields!Change_Number.Value

Upvotes: 1

Related Questions