Adding a URL to a value

Question

i have a column called contact id and i am trying to add a url to the value, so that it opens up a page of contact details when clicked on. so i clicked on the properties and clicked on the navigation and copied the URL that i was trying to get.

for a particular contact the url is

http://abcd.ccd/books.contID=1002

i copied till the = sign and pasted but when i click on the value it is not taking me to the corresponding page. what do i have to do ??please someone help me

---

msmustard

Answer 1

Hi msmustard,

Check below SSRS Sample

http://www.hoekstra.co.uk/index.php/software-mainmenu-36/ssrs-mainmenu-118/85-hyperlinking-to-a-new-window-from-ssrs.html

Regards

Olivia

Answer 2

Thanks for the reply Olivia, It does not explain.. this is exactly what it mentions, like i have pasted the URL in jump to URL but the value contact id ? How will each value take me to the corresponding page ??? Please someone help me

---

msmustard

Answer 3

I'm not sure if i clearly understood your question.

Is your target page a SSRS reprot?

If yes, you can create a drillthrough report. See the below example.
http://tinyurl.com/842pw9c

If no, you should know the URL syntax of the target. For example, the following is a valid URL for a wiki page for city Denver.
http://en.wikipedia.org/wiki/Denver

You should build URL based of this. In the actions, i've created the below expression
="http://en.wikipedia.org/wiki/"+ReportItems!Textbox1.Value

At run time ReportItems!Textbox1.Value will be evaluated to the cell a user clicks. In your case this will be ContactID.

I hope this explains a few things.

---

Regards, Samuel Vanga Twitter Blog

Answer 4

No its not a ssrs page , hence i entered the target URL in jump to URL in navigation. i entered the systax like

http://abcdd/zzz=

the original syntax is

http://abcdd/zzz=1002 for one particular contact id , hence i entered

http://abcdd/zzz= thinking when i click on the contact id number it will take me to the corresponding page of the number but it is taking me to the url

http://abcdd/zzz= but not http://abcdd/zzz=1002

Itried what you mentioned like = "http://abcdd/zzz"+fields!contactId.value but its still not taking me to the page of the corresponding ID

---

msmustard

Answer 5

Is it throwing any errors? Is it even opening internet explorer? Any details of what's happening will help answer your issue!

Thanks!

---

Regards, Samuel Vanga Twitter Blog

Answer 6

it is opening the page as i entered a url

http:/abcd/zzzz= so it is taking me to this page. i want it to take me to the page of the correspond contact id.

the url for one contact id is http:/abcd/zzzz=1001 and like so on for all the contact id's.

i want to click on the contact id and it should take me to the contact page that is there.

we have a company site where it has details like contact name and contact details.

---

msmustard

Answer 7

i went to navigation and pasted the url in jump to url tab http:/abcd/zzzz=

---

msmustard

Answer 8

Hi,

If you have contactid field in dataset then try below in jump to url try following,

="http:/abcd/zzzz=" + Fields!ContactID.value

---

Regards,

Asim Bagwan

Kindly mark the replies as Answers if they help!