SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Conditionally Go To URL in a new window


Conditionally Go To URL in a new window

Author
Message
jamey8420
jamey8420
SSC-Enthusiastic
SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

Group: General Forum Members
Points: 199 Visits: 135
I have a conditional hyperlink set up in my SSRS 2008 report.

=iif(Fields!budgetid.Value>1,"http://system/forms/Summary.aspx?BudgetId="&Fields!budgetid.Value,"")


This works fine. However, it is opening over my report and I don't want that. I want to open it in a new window. I know that this can be done using Javascript, but so far I've been unsuccessful in my attempts. I know I'm off with the spacing, and where single quotes should be used and where double quotes should be used.

=iif(Fields!budgetid.Value>1,"void(window.open('http://system/forms/Summary.aspx?BudgetId='&Fields!budgetid.Value,'_blank')),"")

Something like this, but it's not working.

Any help would be greatly appreciated. Thanks!
Jamey
mister.magoo
mister.magoo
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10347 Visits: 7891
jamey8420 (4/5/2013)
I have a conditional hyperlink set up in my SSRS 2008 report.

=iif(Fields!budgetid.Value>1,"http://system/forms/Summary.aspx?BudgetId="&Fields!budgetid.Value,"")


This works fine. However, it is opening over my report and I don't want that. I want to open it in a new window. I know that this can be done using Javascript, but so far I've been unsuccessful in my attempts. I know I'm off with the spacing, and where single quotes should be used and where double quotes should be used.

=iif(Fields!budgetid.Value>1,"void(window.open('http://system/forms/Summary.aspx?BudgetId='&Fields!budgetid.Value,'_blank')),"")

Something like this, but it's not working.

Any help would be greatly appreciated. Thanks!
Jamey



Try this (replace the á with a regular a):


=iif(Fields!budgetid.Value>1,"jávascript:void(""window.open('http://system/forms/Summary.aspx?BudgetId=" & Fields!budgetid.Value & "','_blank'))","")



MM


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • jamey8420
    jamey8420
    SSC-Enthusiastic
    SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

    Group: General Forum Members
    Points: 199 Visits: 135
    Thanks MM,

    I changed the code and nothing happened when I clicked on the link.

    When I viewed the properties of the link, this is what I see:

    void(%22window.open('http://system/forms/Summary.aspx?BudgetId=2849','_blank'))


    When I remove the %22 (double quote) and paste it into a browser, the link does work - I am prompted to allow pop-ups, but this doesn't surprise me. However, when I removed it from the report, it doesn't compile. Any ideas?
    mister.magoo
    mister.magoo
    SSChampion
    SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

    Group: General Forum Members
    Points: 10347 Visits: 7891
    Oh yeah, sorry - that's the problem with typing code into this forum ! w00t
    Try this (replace the á with a regular a):


    =iif(Fields!budgetid.Value>1,"jávascript:void(window.open('http://system/forms/Summary.aspx?BudgetId=" & Fields!budgetid.Value & "','_blank'))","")



    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • jamey8420
    jamey8420
    SSC-Enthusiastic
    SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

    Group: General Forum Members
    Points: 199 Visits: 135
    That link works; thanks.

    One related question. My SSRS report is in a window that doesn't have the URL displayed. So when I click on my link, nothing is still happening. I'm not seeing the prompt to Allow Pop-ups, which will allow the link to work.

    Do you know of anyway to automate this process through the link? I don't think this is possible, but thought I'd ask. Or maybe another way around this issue?

    Thanks,
    Jamey
    mister.magoo
    mister.magoo
    SSChampion
    SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

    Group: General Forum Members
    Points: 10347 Visits: 7891
    jamey8420 (4/5/2013)
    That link works; thanks.

    One related question. My SSRS report is in a window that doesn't have the URL displayed. So when I click on my link, nothing is still happening. I'm not seeing the prompt to Allow Pop-ups, which will allow the link to work.

    Do you know of anyway to automate this process through the link? I don't think this is possible, but thought I'd ask. Or maybe another way around this issue?

    Thanks,
    Jamey




    Sorry, no.

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);




  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • jamey8420
    jamey8420
    SSC-Enthusiastic
    SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

    Group: General Forum Members
    Points: 199 Visits: 135
    As a test, I ran my report in a window that does display the URL, everything on it. When I hover over the link, I can see it and it's formed properly.

    When I click, nothing happens. When I copy the shortcut, and paste it into another window, I am prompted for pop-ups and then it works.

    My report is in another window, but it's also being viewed from within an iFrame. May this be causing the issue? Just doesn't seem I can link to another page outside of that iFrame.

    Thanks,
    Jamey
    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search