Jump tag into PDF using SSRS

  • Hello,

    I am wondering if there is anyway on my report for a particular column to be able to link it to an external url then use a jump tag into a pdf to drill down to a certain number or name of the pdf url on a external webpage?

    for example,

    if I have customer ID 1 with first name bob, then when the person clicks on the ID column on 1 (the record of bob), it will open up a PDF page, then drill down and show bob highlighted... is this possible?

    I have tried something like:

    'void(window.open(''<a href="http://www.treasury.gov/ofac/downloads/t11sdn.pdf">' + b.firstname + ' '+ b.lastname + '</A>'+ ''',''blank''))'

    however the above doesnt work, the weird thing is, it does open a webpage, but sends me to:

    http://sgisqlprod02/Reports_SGI_REPORTS/Pages/%3Ca%20href=%22http://www.treasury.gov/ofac/downloads/t11sdn.pdf%22%3ELuis%20Lopez%3C/A%3E

    so the first part is actually my ssrs server, but the other part shows the correct url i want... sadly i dont know how or why my ssrs server puts itself first when all I did was put the http://www.treasury.com part... any ideas?

    Let me know if you need anything else.

    Thanks in advance.

  • Just a quick update/correction, the url above doesnt work when you remove the ssrs server, however this does:

    http://sgisqlprod02/Reports_SGI_REPORTS/Pages/%3Ca%20href=%22http://www.treasury.gov/ofac/downloads/t11sdn.pdf#Khan, Farhan"></a>

    so if you remove from http://sgisqlprod02 all the way to %20href=%22, then it will work perfect. however why does it throw my ssrs server infront... i dont know, but here is the javascript open window part...

    'void(window.open(''<a href="http://www.treasury.gov/ofac/downloads/t11sdn.pdf#'+ b.Lastname + ', ' + b.FirstName+'"></a>'+ ''',''blank''))'

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply