Conditionally Go To URL in a new window

  • 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

  • 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
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • 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?

  • 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
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • 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

  • 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
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • 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

  • Viewing 7 posts - 1 through 6 (of 6 total)

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