Conditionally Go To URL in a new window

Question

Conditionally Go To URL in a new window

jamey8420

Ten Centuries

Points: 1099
More actions
April 5, 2013 at 8:21 am

#272721

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
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]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

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);

jamey8420 Ten Centuries Points: 1099 More actions · Answer 2

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 SSC-Forever Points: 47174 More actions · Answer 3

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);

jamey8420 Ten Centuries Points: 1099 More actions · Answer 4

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 SSC-Forever Points: 47174 More actions · Answer 5

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);

jamey8420 Ten Centuries Points: 1099 More actions · Answer 6

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