I have a report that needs to "jump" to 2 URL's at the same time. I also need
them to open in a second and third window leaving the first open to the
orginal report. Can this be done? I have the report right now that can "jump"
to one of the links in the cell. But it uses the original window.TTT
"Robert B." wrote:
> I have a report that needs to "jump" to 2 URL's at the same time. I also need
> them to open in a second and third window leaving the first open to the
> orginal report. Can this be done? I have the report right now that can "jump"
> to one of the links in the cell. But it uses the original window.sql
Showing posts with label window. Show all posts
Showing posts with label window. Show all posts
Friday, March 30, 2012
Jump to URL: Opens new window but.....
Thank you Bruce L-C [MVP], as you replied to one of my post: how to open web
page in new window using Jump to URL.
= "javascript:window.open('http://www.google.com')"
This works fine. It opens new window for google; but the main page where
reports were listed loses its data and shows "[object]".
When I click "Back" button, it again lists reports.
Any Idea?Try this:
= "javascript:void(window.open('http://www.google.com'))"
"RA" wrote:
> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
web
> page in new window using Jump to URL.
> = "javascript:window.open('http://www.google.com')"
> This works fine. It opens new window for google; but the main page where
> reports were listed loses its data and shows "[object]".
> When I click "Back" button, it again lists reports.
> Any Idea?|||Thanks a lot,
That worked.
"goinoutwest" <goinoutwest@.hotmail.com> wrote in message
news:u$7mzEbzEHA.260@.TK2MSFTNGP11.phx.gbl...
> Try this:
> = "javascript:void(window.open('http://www.google.com'))"
>
> "RA" wrote:
>> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
> web
>> page in new window using Jump to URL.
>> = "javascript:window.open('http://www.google.com')"
>> This works fine. It opens new window for google; but the main page where
>> reports were listed loses its data and shows "[object]".
>> When I click "Back" button, it again lists reports.
>> Any Idea?
>|||This works only on the reportserver, i.e. when i view reports
http://servername/reportserver/... but the java scrip doesnt work when i view
reports on the report manager like this http://servername/reports/..
Plz suggest somethng
"RA" wrote:
> Thanks a lot,
> That worked.
> "goinoutwest" <goinoutwest@.hotmail.com> wrote in message
> news:u$7mzEbzEHA.260@.TK2MSFTNGP11.phx.gbl...
> > Try this:
> >
> > = "javascript:void(window.open('http://www.google.com'))"
> >
> >
> > "RA" wrote:
> >> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
> > web
> >> page in new window using Jump to URL.
> >>
> >> = "javascript:window.open('http://www.google.com')"
> >>
> >> This works fine. It opens new window for google; but the main page where
> >> reports were listed loses its data and shows "[object]".
> >>
> >> When I click "Back" button, it again lists reports.
> >>
> >> Any Idea?
> >
> >
>
>
page in new window using Jump to URL.
= "javascript:window.open('http://www.google.com')"
This works fine. It opens new window for google; but the main page where
reports were listed loses its data and shows "[object]".
When I click "Back" button, it again lists reports.
Any Idea?Try this:
= "javascript:void(window.open('http://www.google.com'))"
"RA" wrote:
> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
web
> page in new window using Jump to URL.
> = "javascript:window.open('http://www.google.com')"
> This works fine. It opens new window for google; but the main page where
> reports were listed loses its data and shows "[object]".
> When I click "Back" button, it again lists reports.
> Any Idea?|||Thanks a lot,
That worked.
"goinoutwest" <goinoutwest@.hotmail.com> wrote in message
news:u$7mzEbzEHA.260@.TK2MSFTNGP11.phx.gbl...
> Try this:
> = "javascript:void(window.open('http://www.google.com'))"
>
> "RA" wrote:
>> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
> web
>> page in new window using Jump to URL.
>> = "javascript:window.open('http://www.google.com')"
>> This works fine. It opens new window for google; but the main page where
>> reports were listed loses its data and shows "[object]".
>> When I click "Back" button, it again lists reports.
>> Any Idea?
>|||This works only on the reportserver, i.e. when i view reports
http://servername/reportserver/... but the java scrip doesnt work when i view
reports on the report manager like this http://servername/reports/..
Plz suggest somethng
"RA" wrote:
> Thanks a lot,
> That worked.
> "goinoutwest" <goinoutwest@.hotmail.com> wrote in message
> news:u$7mzEbzEHA.260@.TK2MSFTNGP11.phx.gbl...
> > Try this:
> >
> > = "javascript:void(window.open('http://www.google.com'))"
> >
> >
> > "RA" wrote:
> >> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
> > web
> >> page in new window using Jump to URL.
> >>
> >> = "javascript:window.open('http://www.google.com')"
> >>
> >> This works fine. It opens new window for google; but the main page where
> >> reports were listed loses its data and shows "[object]".
> >>
> >> When I click "Back" button, it again lists reports.
> >>
> >> Any Idea?
> >
> >
>
>
Jump to URL with new window
How can I jump to URL with new window?
Is anyway can do this?
I'm try to use &rc:targetlink=new
but it dosen't work.
how can I do this?
Thanks for any advice!
AngiHere is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
You need SP1 or SP2 if using SQL Server 2000 (this feature was added with
the release of SP1)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Angi" <enchiw@.msn.com> wrote in message
news:%236aWVy1CGHA.3876@.tk2msftngp13.phx.gbl...
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>|||Try the following URL
How to open hyperlink in a new window in Reporting Services Report (RS with
SP1 or higher)
http://binaryworld.net/Main/CodeDetail.aspx?CodeId=4012
--
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing Platform
"Angi" wrote:
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>
>|||Thanks Bruce & Nayan!
And now I have a new way for Jump to URL, for you refernce!
="javascript:void(window.open('http://Domain/ReportServer/Pages/ReportViewer.aspx?%2fBIGS%2f02bar&rs:Command=Render&rc:Toolbar=false','_blank',
'toolbar=no,location=no,directories=no,status=yes,menubar=no,scrollbar=yes,resizable=yes,copyhistory=no'))"
No IE toolbar and RS toolbar.
Thanks again!
Angi
"Angi" <enchiw@.msn.com> ¼¶¼g©ó¶l¥ó·s»D:%236aWVy1CGHA.3876@.tk2msftngp13.phx.gbl...
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>
Is anyway can do this?
I'm try to use &rc:targetlink=new
but it dosen't work.
how can I do this?
Thanks for any advice!
AngiHere is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
You need SP1 or SP2 if using SQL Server 2000 (this feature was added with
the release of SP1)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Angi" <enchiw@.msn.com> wrote in message
news:%236aWVy1CGHA.3876@.tk2msftngp13.phx.gbl...
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>|||Try the following URL
How to open hyperlink in a new window in Reporting Services Report (RS with
SP1 or higher)
http://binaryworld.net/Main/CodeDetail.aspx?CodeId=4012
--
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing Platform
"Angi" wrote:
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>
>|||Thanks Bruce & Nayan!
And now I have a new way for Jump to URL, for you refernce!
="javascript:void(window.open('http://Domain/ReportServer/Pages/ReportViewer.aspx?%2fBIGS%2f02bar&rs:Command=Render&rc:Toolbar=false','_blank',
'toolbar=no,location=no,directories=no,status=yes,menubar=no,scrollbar=yes,resizable=yes,copyhistory=no'))"
No IE toolbar and RS toolbar.
Thanks again!
Angi
"Angi" <enchiw@.msn.com> ¼¶¼g©ó¶l¥ó·s»D:%236aWVy1CGHA.3876@.tk2msftngp13.phx.gbl...
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>
Jump to URL was working - now not working
Hello. I have javascript in a bunch of my reports so that when jumping to a
url in the action property everything would go to a new browser window.
Everything is working just fine (after I upgraded the service pack so I could
do it) but now all of a sudden it doesn't work on any of the reports. Nothing
has changed on the box and none of the reports have been touched. Everything
else appears to be working as intended.
Any ideas? Any help would be very much appreciated. Thanks!Hi can i know what is the javascript you used? There is a some change in SP1
2005RS that made to do this. Few javascript code added to the RS report
manager has been changed to support and block some feature...
"dcray" wrote:
> Hello. I have javascript in a bunch of my reports so that when jumping to a
> url in the action property everything would go to a new browser window.
> Everything is working just fine (after I upgraded the service pack so I could
> do it) but now all of a sudden it doesn't work on any of the reports. Nothing
> has changed on the box and none of the reports have been touched. Everything
> else appears to be working as intended.
> Any ideas? Any help would be very much appreciated. Thanks!|||Hi, it wasn't until I upgraded the service pack that it would work at all,
and after applied worked fine just as anticipated. Nothing fancy, now all of
reports that use this js are broke and nothing has changed
="javascript:void(window.open('http://www.google.com'))"
I also tried specifiying the target window
="javascript:void(window.open('http://www.google.com','_blank'))"
still not working. These are the things that have been added to the box
reporting services is on since the reports were impliented and working with
the javascript in the action property:
Windows Malicious Software Removal Tool
Security Update for Microsoft Data Access Components 2.7 SP1
Cumulative Security Update for IE 6 SP1
Security Update for Windows 200
Cumulative Security Update for Outlook Express 6 SP1
just in case any of these might cause a prolblem...you never know.
thanks!!
"Bava Mani" wrote:
> Hi can i know what is the javascript you used? There is a some change in SP1
> 2005RS that made to do this. Few javascript code added to the RS report
> manager has been changed to support and block some feature...
> "dcray" wrote:
> > Hello. I have javascript in a bunch of my reports so that when jumping to a
> > url in the action property everything would go to a new browser window.
> > Everything is working just fine (after I upgraded the service pack so I could
> > do it) but now all of a sudden it doesn't work on any of the reports. Nothing
> > has changed on the box and none of the reports have been touched. Everything
> > else appears to be working as intended.
> >
> > Any ideas? Any help would be very much appreciated. Thanks!|||I have a report I designed in RS 2000 and converted to RS 2005. I just tried
it out and it worked fine:
= "javascript:void(window.open('http://www.google.com','_blank'))"
Looks exactly the same as below.
So, might be something else but it is not RS 2005. This requires RS 2000 SP1
or greater. I have all the latest security updates at the server and the
client (Server is 2003 SP1, client XP Pro SP2).
Anyway, not a solution but at least another data point for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dcray" <dcray@.discussions.microsoft.com> wrote in message
news:89F48B08-2279-4D1D-8FE6-FB1B98D431B8@.microsoft.com...
> Hi, it wasn't until I upgraded the service pack that it would work at all,
> and after applied worked fine just as anticipated. Nothing fancy, now all
> of
> reports that use this js are broke and nothing has changed
> ="javascript:void(window.open('http://www.google.com'))"
> I also tried specifiying the target window
> ="javascript:void(window.open('http://www.google.com','_blank'))"
> still not working. These are the things that have been added to the box
> reporting services is on since the reports were impliented and working
> with
> the javascript in the action property:
> Windows Malicious Software Removal Tool
> Security Update for Microsoft Data Access Components 2.7 SP1
> Cumulative Security Update for IE 6 SP1
> Security Update for Windows 200
> Cumulative Security Update for Outlook Express 6 SP1
> just in case any of these might cause a prolblem...you never know.
> thanks!!
>
> "Bava Mani" wrote:
>> Hi can i know what is the javascript you used? There is a some change in
>> SP1
>> 2005RS that made to do this. Few javascript code added to the RS report
>> manager has been changed to support and block some feature...
>> "dcray" wrote:
>> > Hello. I have javascript in a bunch of my reports so that when jumping
>> > to a
>> > url in the action property everything would go to a new browser window.
>> > Everything is working just fine (after I upgraded the service pack so I
>> > could
>> > do it) but now all of a sudden it doesn't work on any of the reports.
>> > Nothing
>> > has changed on the box and none of the reports have been touched.
>> > Everything
>> > else appears to be working as intended.
>> >
>> > Any ideas? Any help would be very much appreciated. Thanks!|||turns out the problem is that some of the urls to the reports that were
getting passed around used an alias for the machine that hasn't been set up
properly as one of the host headers
"Bruce L-C [MVP]" wrote:
> I have a report I designed in RS 2000 and converted to RS 2005. I just tried
> it out and it worked fine:
> = "javascript:void(window.open('http://www.google.com','_blank'))"
> Looks exactly the same as below.
> So, might be something else but it is not RS 2005. This requires RS 2000 SP1
> or greater. I have all the latest security updates at the server and the
> client (Server is 2003 SP1, client XP Pro SP2).
> Anyway, not a solution but at least another data point for you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "dcray" <dcray@.discussions.microsoft.com> wrote in message
> news:89F48B08-2279-4D1D-8FE6-FB1B98D431B8@.microsoft.com...
> >
> > Hi, it wasn't until I upgraded the service pack that it would work at all,
> > and after applied worked fine just as anticipated. Nothing fancy, now all
> > of
> > reports that use this js are broke and nothing has changed
> >
> > ="javascript:void(window.open('http://www.google.com'))"
> >
> > I also tried specifiying the target window
> >
> > ="javascript:void(window.open('http://www.google.com','_blank'))"
> >
> > still not working. These are the things that have been added to the box
> > reporting services is on since the reports were impliented and working
> > with
> > the javascript in the action property:
> >
> > Windows Malicious Software Removal Tool
> > Security Update for Microsoft Data Access Components 2.7 SP1
> > Cumulative Security Update for IE 6 SP1
> > Security Update for Windows 200
> > Cumulative Security Update for Outlook Express 6 SP1
> >
> > just in case any of these might cause a prolblem...you never know.
> > thanks!!
> >
> >
> >
> > "Bava Mani" wrote:
> >
> >> Hi can i know what is the javascript you used? There is a some change in
> >> SP1
> >> 2005RS that made to do this. Few javascript code added to the RS report
> >> manager has been changed to support and block some feature...
> >>
> >> "dcray" wrote:
> >>
> >> > Hello. I have javascript in a bunch of my reports so that when jumping
> >> > to a
> >> > url in the action property everything would go to a new browser window.
> >> > Everything is working just fine (after I upgraded the service pack so I
> >> > could
> >> > do it) but now all of a sudden it doesn't work on any of the reports.
> >> > Nothing
> >> > has changed on the box and none of the reports have been touched.
> >> > Everything
> >> > else appears to be working as intended.
> >> >
> >> > Any ideas? Any help would be very much appreciated. Thanks!
>
>
url in the action property everything would go to a new browser window.
Everything is working just fine (after I upgraded the service pack so I could
do it) but now all of a sudden it doesn't work on any of the reports. Nothing
has changed on the box and none of the reports have been touched. Everything
else appears to be working as intended.
Any ideas? Any help would be very much appreciated. Thanks!Hi can i know what is the javascript you used? There is a some change in SP1
2005RS that made to do this. Few javascript code added to the RS report
manager has been changed to support and block some feature...
"dcray" wrote:
> Hello. I have javascript in a bunch of my reports so that when jumping to a
> url in the action property everything would go to a new browser window.
> Everything is working just fine (after I upgraded the service pack so I could
> do it) but now all of a sudden it doesn't work on any of the reports. Nothing
> has changed on the box and none of the reports have been touched. Everything
> else appears to be working as intended.
> Any ideas? Any help would be very much appreciated. Thanks!|||Hi, it wasn't until I upgraded the service pack that it would work at all,
and after applied worked fine just as anticipated. Nothing fancy, now all of
reports that use this js are broke and nothing has changed
="javascript:void(window.open('http://www.google.com'))"
I also tried specifiying the target window
="javascript:void(window.open('http://www.google.com','_blank'))"
still not working. These are the things that have been added to the box
reporting services is on since the reports were impliented and working with
the javascript in the action property:
Windows Malicious Software Removal Tool
Security Update for Microsoft Data Access Components 2.7 SP1
Cumulative Security Update for IE 6 SP1
Security Update for Windows 200
Cumulative Security Update for Outlook Express 6 SP1
just in case any of these might cause a prolblem...you never know.
thanks!!
"Bava Mani" wrote:
> Hi can i know what is the javascript you used? There is a some change in SP1
> 2005RS that made to do this. Few javascript code added to the RS report
> manager has been changed to support and block some feature...
> "dcray" wrote:
> > Hello. I have javascript in a bunch of my reports so that when jumping to a
> > url in the action property everything would go to a new browser window.
> > Everything is working just fine (after I upgraded the service pack so I could
> > do it) but now all of a sudden it doesn't work on any of the reports. Nothing
> > has changed on the box and none of the reports have been touched. Everything
> > else appears to be working as intended.
> >
> > Any ideas? Any help would be very much appreciated. Thanks!|||I have a report I designed in RS 2000 and converted to RS 2005. I just tried
it out and it worked fine:
= "javascript:void(window.open('http://www.google.com','_blank'))"
Looks exactly the same as below.
So, might be something else but it is not RS 2005. This requires RS 2000 SP1
or greater. I have all the latest security updates at the server and the
client (Server is 2003 SP1, client XP Pro SP2).
Anyway, not a solution but at least another data point for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dcray" <dcray@.discussions.microsoft.com> wrote in message
news:89F48B08-2279-4D1D-8FE6-FB1B98D431B8@.microsoft.com...
> Hi, it wasn't until I upgraded the service pack that it would work at all,
> and after applied worked fine just as anticipated. Nothing fancy, now all
> of
> reports that use this js are broke and nothing has changed
> ="javascript:void(window.open('http://www.google.com'))"
> I also tried specifiying the target window
> ="javascript:void(window.open('http://www.google.com','_blank'))"
> still not working. These are the things that have been added to the box
> reporting services is on since the reports were impliented and working
> with
> the javascript in the action property:
> Windows Malicious Software Removal Tool
> Security Update for Microsoft Data Access Components 2.7 SP1
> Cumulative Security Update for IE 6 SP1
> Security Update for Windows 200
> Cumulative Security Update for Outlook Express 6 SP1
> just in case any of these might cause a prolblem...you never know.
> thanks!!
>
> "Bava Mani" wrote:
>> Hi can i know what is the javascript you used? There is a some change in
>> SP1
>> 2005RS that made to do this. Few javascript code added to the RS report
>> manager has been changed to support and block some feature...
>> "dcray" wrote:
>> > Hello. I have javascript in a bunch of my reports so that when jumping
>> > to a
>> > url in the action property everything would go to a new browser window.
>> > Everything is working just fine (after I upgraded the service pack so I
>> > could
>> > do it) but now all of a sudden it doesn't work on any of the reports.
>> > Nothing
>> > has changed on the box and none of the reports have been touched.
>> > Everything
>> > else appears to be working as intended.
>> >
>> > Any ideas? Any help would be very much appreciated. Thanks!|||turns out the problem is that some of the urls to the reports that were
getting passed around used an alias for the machine that hasn't been set up
properly as one of the host headers
"Bruce L-C [MVP]" wrote:
> I have a report I designed in RS 2000 and converted to RS 2005. I just tried
> it out and it worked fine:
> = "javascript:void(window.open('http://www.google.com','_blank'))"
> Looks exactly the same as below.
> So, might be something else but it is not RS 2005. This requires RS 2000 SP1
> or greater. I have all the latest security updates at the server and the
> client (Server is 2003 SP1, client XP Pro SP2).
> Anyway, not a solution but at least another data point for you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "dcray" <dcray@.discussions.microsoft.com> wrote in message
> news:89F48B08-2279-4D1D-8FE6-FB1B98D431B8@.microsoft.com...
> >
> > Hi, it wasn't until I upgraded the service pack that it would work at all,
> > and after applied worked fine just as anticipated. Nothing fancy, now all
> > of
> > reports that use this js are broke and nothing has changed
> >
> > ="javascript:void(window.open('http://www.google.com'))"
> >
> > I also tried specifiying the target window
> >
> > ="javascript:void(window.open('http://www.google.com','_blank'))"
> >
> > still not working. These are the things that have been added to the box
> > reporting services is on since the reports were impliented and working
> > with
> > the javascript in the action property:
> >
> > Windows Malicious Software Removal Tool
> > Security Update for Microsoft Data Access Components 2.7 SP1
> > Cumulative Security Update for IE 6 SP1
> > Security Update for Windows 200
> > Cumulative Security Update for Outlook Express 6 SP1
> >
> > just in case any of these might cause a prolblem...you never know.
> > thanks!!
> >
> >
> >
> > "Bava Mani" wrote:
> >
> >> Hi can i know what is the javascript you used? There is a some change in
> >> SP1
> >> 2005RS that made to do this. Few javascript code added to the RS report
> >> manager has been changed to support and block some feature...
> >>
> >> "dcray" wrote:
> >>
> >> > Hello. I have javascript in a bunch of my reports so that when jumping
> >> > to a
> >> > url in the action property everything would go to a new browser window.
> >> > Everything is working just fine (after I upgraded the service pack so I
> >> > could
> >> > do it) but now all of a sudden it doesn't work on any of the reports.
> >> > Nothing
> >> > has changed on the box and none of the reports have been touched.
> >> > Everything
> >> > else appears to be working as intended.
> >> >
> >> > Any ideas? Any help would be very much appreciated. Thanks!
>
>
Jump to URL popup
I am trying to create a popup window from a report.
Looked thru some previous posts and generated this string in the "Jump to
url:"
="javascript:void(window.open('http://www.yahoo.com',
'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
But when I try to preview the report I get,
Processing errors:
The url javascript:void(window.open('http://www.yahoo.com',
'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800')) has
an invalid schema.
URLs in reports may only use http://, https://, ftp://, mailto: or news:
I tried with and without "http://" in the string.
TIA,
Surekha.You need to install SP1.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Surekha" <Surekha@.discussions.microsoft.com> wrote in message
news:770516DE-1A42-4FA4-9832-AA107EA59A12@.microsoft.com...
> I am trying to create a popup window from a report.
> Looked thru some previous posts and generated this string in the "Jump to
> url:"
> ="javascript:void(window.open('http://www.yahoo.com',
> 'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
> But when I try to preview the report I get,
> Processing errors:
> The url javascript:void(window.open('http://www.yahoo.com',
> 'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))
has
> an invalid schema.
> URLs in reports may only use http://, https://, ftp://, mailto: or news:
> I tried with and without "http://" in the string.
> TIA,
> Surekha.sql
Looked thru some previous posts and generated this string in the "Jump to
url:"
="javascript:void(window.open('http://www.yahoo.com',
'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
But when I try to preview the report I get,
Processing errors:
The url javascript:void(window.open('http://www.yahoo.com',
'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800')) has
an invalid schema.
URLs in reports may only use http://, https://, ftp://, mailto: or news:
I tried with and without "http://" in the string.
TIA,
Surekha.You need to install SP1.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Surekha" <Surekha@.discussions.microsoft.com> wrote in message
news:770516DE-1A42-4FA4-9832-AA107EA59A12@.microsoft.com...
> I am trying to create a popup window from a report.
> Looked thru some previous posts and generated this string in the "Jump to
> url:"
> ="javascript:void(window.open('http://www.yahoo.com',
> 'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
> But when I try to preview the report I get,
> Processing errors:
> The url javascript:void(window.open('http://www.yahoo.com',
> 'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))
has
> an invalid schema.
> URLs in reports may only use http://, https://, ftp://, mailto: or news:
> I tried with and without "http://" in the string.
> TIA,
> Surekha.sql
Jump to URL Action in a New Window
I've read countless postings now but haven't yet found an answer to this frequently asked question: "When using the Jump to URL option in the Action property of a textbox, how do you make that URL open in a new window?" Is it possible?Have you tried the LinkTarget HTML format DeviceInfo setting? I know you
can make hyperlinks open in a new window but I don't know if this will work
for jump to URL. I assume it will :)
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"ToxicDice" <ToxicDice@.discussions.microsoft.com> wrote in message
news:E551A617-1589-4386-8E6C-49B67A5AC386@.microsoft.com...
> I've read countless postings now but haven't yet found an answer to this
frequently asked question: "When using the Jump to URL option in the Action
property of a textbox, how do you make that URL open in a new window?" Is
it possible?
can make hyperlinks open in a new window but I don't know if this will work
for jump to URL. I assume it will :)
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"ToxicDice" <ToxicDice@.discussions.microsoft.com> wrote in message
news:E551A617-1589-4386-8E6C-49B67A5AC386@.microsoft.com...
> I've read countless postings now but haven't yet found an answer to this
frequently asked question: "When using the Jump to URL option in the Action
property of a textbox, how do you make that URL open in a new window?" Is
it possible?
Jump to URL - Passing Parameter Issue with special symbols
Hi Microsoft,
I've currently using the Jump to URL Syntax (see below) to open a new window
and pop up a drilldown report in IE.
The main problem i'm having with the syntax below iswhen the account manager
name (ACCTMGR Parameter string) contains a umlaut (german name with a double
o on top of a letter), the drilldown report runs but it doesn't run the
report details (report is blank) when information does exist. I've tried
search for resolutions online and cam up with nothing.
In addition, when a parenthesis and or an ampersand is present in the
parameter, it does not run the drilldown subreport. Your help would be
greatly appreciated.
Can you help?
=iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
& Parameters!rptCurrency.Value & "&Division=" &
Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
"&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
"','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")My guess is you have to URL encode this. Here is a link. You might be able
to use HttpUtility.UrlEncode in your expression. However, if it doesn't then
you will need to use code behind reports.
http://weblogs.asp.net/psteele/pages/7509.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
> Hi Microsoft,
> I've currently using the Jump to URL Syntax (see below) to open a new
> window
> and pop up a drilldown report in IE.
> The main problem i'm having with the syntax below iswhen the account
> manager
> name (ACCTMGR Parameter string) contains a umlaut (german name with a
> double
> o on top of a letter), the drilldown report runs but it doesn't run the
> report details (report is blank) when information does exist. I've tried
> search for resolutions online and cam up with nothing.
> In addition, when a parenthesis and or an ampersand is present in the
> parameter, it does not run the drilldown subreport. Your help would be
> greatly appreciated.
> Can you help?
> =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
> & Parameters!rptCurrency.Value & "&Division=" &
> Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
> "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")|||Hi Bruce,
Thanks for the quick reply!
I've tried referencing System.Web.HttpUtility.UrlEncode (and also just
HttpUtility.UrlEncode) in the Jump to URL syntax as such:
=iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://myserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Opportunity+Report+Details&rc:Parameters=false&rptCurrency="
& Parameters!rptCurrency.Value & "&Division=" &
Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
"&ACCTMGR=" & System.Web.HttpUtility.UrlEncode(ReportItems("ACCTMGR1").Value)
& "&CAMP=LEFT+BLANK" &
"','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=1200,resizable=yes'))")
But no luck it doesn't work. It actually doesn't recognize the UrlEncode
syntax and I've also added the Reference System.Web as well to ensure
everything was referenced properly.
I'm a little new to VB so if you don't mind, I would greatly appreciate it
if you can be a little more specific on what needs to be completed iwth the
code and show an example of how would i reference it in the Jump to URL
expression below?
Thank you in advance for your help.
"Bruce L-C [MVP]" wrote:
> My guess is you have to URL encode this. Here is a link. You might be able
> to use HttpUtility.UrlEncode in your expression. However, if it doesn't then
> you will need to use code behind reports.
> http://weblogs.asp.net/psteele/pages/7509.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
> message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
> > Hi Microsoft,
> >
> > I've currently using the Jump to URL Syntax (see below) to open a new
> > window
> > and pop up a drilldown report in IE.
> >
> > The main problem i'm having with the syntax below iswhen the account
> > manager
> > name (ACCTMGR Parameter string) contains a umlaut (german name with a
> > double
> > o on top of a letter), the drilldown report runs but it doesn't run the
> > report details (report is blank) when information does exist. I've tried
> > search for resolutions online and cam up with nothing.
> >
> > In addition, when a parenthesis and or an ampersand is present in the
> > parameter, it does not run the drilldown subreport. Your help would be
> > greatly appreciated.
> >
> > Can you help?
> >
> > =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
> > & Parameters!rptCurrency.Value & "&Division=" &
> > Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> > Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> > Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> > Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> > Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> > "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
> > "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")
>
>|||I suggest creating a report with a single textbox in it. Set your expression
so you can see the result. Next read up on using the code behind reports:
Using Custom Code References in Expressions (Reporting Services)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/13fa8c92-0471-4b2f-b97c-9ebbcb13797f.htm
Your expression will look like this:
=Code.URLEncode("This is a test")URLEncode is a function you have written
that takes a single parameter and returns the encoded string.-- Bruce
Loehle-CongerMVP SQL Server Reporting Services
"RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
message news:AA9EC05C-F668-4E99-AB58-48968CF9E909@.microsoft.com...
> Hi Bruce,
> Thanks for the quick reply!
> I've tried referencing System.Web.HttpUtility.UrlEncode (and also just
> HttpUtility.UrlEncode) in the Jump to URL syntax as such:
> =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://myserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Opportunity+Report+Details&rc:Parameters=false&rptCurrency="
> & Parameters!rptCurrency.Value & "&Division=" &
> Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> "&ACCTMGR=" &
> System.Web.HttpUtility.UrlEncode(ReportItems("ACCTMGR1").Value)
> & "&CAMP=LEFT+BLANK" &
> "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=1200,resizable=yes'))")
> But no luck it doesn't work. It actually doesn't recognize the UrlEncode
> syntax and I've also added the Reference System.Web as well to ensure
> everything was referenced properly.
> I'm a little new to VB so if you don't mind, I would greatly appreciate it
> if you can be a little more specific on what needs to be completed iwth
> the
> code and show an example of how would i reference it in the Jump to URL
> expression below?
> Thank you in advance for your help.
> "Bruce L-C [MVP]" wrote:
>> My guess is you have to URL encode this. Here is a link. You might be
>> able
>> to use HttpUtility.UrlEncode in your expression. However, if it doesn't
>> then
>> you will need to use code behind reports.
>> http://weblogs.asp.net/psteele/pages/7509.aspx
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
>> message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
>> > Hi Microsoft,
>> >
>> > I've currently using the Jump to URL Syntax (see below) to open a new
>> > window
>> > and pop up a drilldown report in IE.
>> >
>> > The main problem i'm having with the syntax below iswhen the account
>> > manager
>> > name (ACCTMGR Parameter string) contains a umlaut (german name with a
>> > double
>> > o on top of a letter), the drilldown report runs but it doesn't run the
>> > report details (report is blank) when information does exist. I've
>> > tried
>> > search for resolutions online and cam up with nothing.
>> >
>> > In addition, when a parenthesis and or an ampersand is present in the
>> > parameter, it does not run the drilldown subreport. Your help would be
>> > greatly appreciated.
>> >
>> > Can you help?
>> >
>> > =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
>> > & Parameters!rptCurrency.Value & "&Division=" &
>> > Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
>> > Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
>> > Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
>> > Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
>> > Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
>> > "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
>> > "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")
>>
I've currently using the Jump to URL Syntax (see below) to open a new window
and pop up a drilldown report in IE.
The main problem i'm having with the syntax below iswhen the account manager
name (ACCTMGR Parameter string) contains a umlaut (german name with a double
o on top of a letter), the drilldown report runs but it doesn't run the
report details (report is blank) when information does exist. I've tried
search for resolutions online and cam up with nothing.
In addition, when a parenthesis and or an ampersand is present in the
parameter, it does not run the drilldown subreport. Your help would be
greatly appreciated.
Can you help?
=iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
& Parameters!rptCurrency.Value & "&Division=" &
Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
"&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
"','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")My guess is you have to URL encode this. Here is a link. You might be able
to use HttpUtility.UrlEncode in your expression. However, if it doesn't then
you will need to use code behind reports.
http://weblogs.asp.net/psteele/pages/7509.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
> Hi Microsoft,
> I've currently using the Jump to URL Syntax (see below) to open a new
> window
> and pop up a drilldown report in IE.
> The main problem i'm having with the syntax below iswhen the account
> manager
> name (ACCTMGR Parameter string) contains a umlaut (german name with a
> double
> o on top of a letter), the drilldown report runs but it doesn't run the
> report details (report is blank) when information does exist. I've tried
> search for resolutions online and cam up with nothing.
> In addition, when a parenthesis and or an ampersand is present in the
> parameter, it does not run the drilldown subreport. Your help would be
> greatly appreciated.
> Can you help?
> =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
> & Parameters!rptCurrency.Value & "&Division=" &
> Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
> "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")|||Hi Bruce,
Thanks for the quick reply!
I've tried referencing System.Web.HttpUtility.UrlEncode (and also just
HttpUtility.UrlEncode) in the Jump to URL syntax as such:
=iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://myserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Opportunity+Report+Details&rc:Parameters=false&rptCurrency="
& Parameters!rptCurrency.Value & "&Division=" &
Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
"&ACCTMGR=" & System.Web.HttpUtility.UrlEncode(ReportItems("ACCTMGR1").Value)
& "&CAMP=LEFT+BLANK" &
"','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=1200,resizable=yes'))")
But no luck it doesn't work. It actually doesn't recognize the UrlEncode
syntax and I've also added the Reference System.Web as well to ensure
everything was referenced properly.
I'm a little new to VB so if you don't mind, I would greatly appreciate it
if you can be a little more specific on what needs to be completed iwth the
code and show an example of how would i reference it in the Jump to URL
expression below?
Thank you in advance for your help.
"Bruce L-C [MVP]" wrote:
> My guess is you have to URL encode this. Here is a link. You might be able
> to use HttpUtility.UrlEncode in your expression. However, if it doesn't then
> you will need to use code behind reports.
> http://weblogs.asp.net/psteele/pages/7509.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
> message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
> > Hi Microsoft,
> >
> > I've currently using the Jump to URL Syntax (see below) to open a new
> > window
> > and pop up a drilldown report in IE.
> >
> > The main problem i'm having with the syntax below iswhen the account
> > manager
> > name (ACCTMGR Parameter string) contains a umlaut (german name with a
> > double
> > o on top of a letter), the drilldown report runs but it doesn't run the
> > report details (report is blank) when information does exist. I've tried
> > search for resolutions online and cam up with nothing.
> >
> > In addition, when a parenthesis and or an ampersand is present in the
> > parameter, it does not run the drilldown subreport. Your help would be
> > greatly appreciated.
> >
> > Can you help?
> >
> > =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
> > & Parameters!rptCurrency.Value & "&Division=" &
> > Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> > Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> > Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> > Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> > Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> > "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
> > "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")
>
>|||I suggest creating a report with a single textbox in it. Set your expression
so you can see the result. Next read up on using the code behind reports:
Using Custom Code References in Expressions (Reporting Services)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/13fa8c92-0471-4b2f-b97c-9ebbcb13797f.htm
Your expression will look like this:
=Code.URLEncode("This is a test")URLEncode is a function you have written
that takes a single parameter and returns the encoded string.-- Bruce
Loehle-CongerMVP SQL Server Reporting Services
"RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
message news:AA9EC05C-F668-4E99-AB58-48968CF9E909@.microsoft.com...
> Hi Bruce,
> Thanks for the quick reply!
> I've tried referencing System.Web.HttpUtility.UrlEncode (and also just
> HttpUtility.UrlEncode) in the Jump to URL syntax as such:
> =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://myserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Opportunity+Report+Details&rc:Parameters=false&rptCurrency="
> & Parameters!rptCurrency.Value & "&Division=" &
> Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
> Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
> Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
> Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
> Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
> "&ACCTMGR=" &
> System.Web.HttpUtility.UrlEncode(ReportItems("ACCTMGR1").Value)
> & "&CAMP=LEFT+BLANK" &
> "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=1200,resizable=yes'))")
> But no luck it doesn't work. It actually doesn't recognize the UrlEncode
> syntax and I've also added the Reference System.Web as well to ensure
> everything was referenced properly.
> I'm a little new to VB so if you don't mind, I would greatly appreciate it
> if you can be a little more specific on what needs to be completed iwth
> the
> code and show an example of how would i reference it in the Jump to URL
> expression below?
> Thank you in advance for your help.
> "Bruce L-C [MVP]" wrote:
>> My guess is you have to URL encode this. Here is a link. You might be
>> able
>> to use HttpUtility.UrlEncode in your expression. However, if it doesn't
>> then
>> you will need to use code behind reports.
>> http://weblogs.asp.net/psteele/pages/7509.aspx
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RS2005Developer" <RS2005Developer@.discussions.microsoft.com> wrote in
>> message news:2BDFEDDE-C685-4224-91A1-489DF67E757D@.microsoft.com...
>> > Hi Microsoft,
>> >
>> > I've currently using the Jump to URL Syntax (see below) to open a new
>> > window
>> > and pop up a drilldown report in IE.
>> >
>> > The main problem i'm having with the syntax below iswhen the account
>> > manager
>> > name (ACCTMGR Parameter string) contains a umlaut (german name with a
>> > double
>> > o on top of a letter), the drilldown report runs but it doesn't run the
>> > report details (report is blank) when information does exist. I've
>> > tried
>> > search for resolutions online and cam up with nothing.
>> >
>> > In addition, when a parenthesis and or an ampersand is present in the
>> > parameter, it does not run the drilldown subreport. Your help would be
>> > greatly appreciated.
>> >
>> > Can you help?
>> >
>> > =iif(sum(Fields!TotalAmount.Value)=0,"","javascript:void(window.open('http://ourreportserveralias/reportserver?%2fDrillDown+Reports%2fMarketing+Campaign+Report+Details&rc:Parameters=false&rptCurrency="
>> > & Parameters!rptCurrency.Value & "&Division=" &
>> > Join(Parameters!Division.Value, "&Division=") & "&DivSales=" &
>> > Join(Parameters!DivSales.Value, "&DivSales=") & "&DeptSales=" &
>> > Join(Parameters!DeptSales.Value, "&DeptSales=") & "&ProductLIne=" &
>> > Join(Parameters!ProductLIne.Value, "&ProductLIne=") & "&startdate=" &
>> > Parameters!startdate.Value & "&enddate=" & Parameters!enddate.Value &
>> > "&ACCTMGR=" & ReportItems("ACCTMGR1").Value & "&CAMP=LEFT+BLANK" &
>> > "','_blank','location=no,toolbar=no,left=100,top=100,height=600,width=800,resizable=yes'))")
>>
Jump to URL - Open New Window
Hello,
I'm still having an issue with opening up a new window on the report
server regarding the report designer's -> Jump to URL feature (option)
in Advanced - Navigation.
This is what I currently have now and I've tried the JavaScript syntax
(expression) i've seen on the old boards, but I keeping getting a web
syntax error from Visual Studio 2003.
We are using Reporting Services Service Pack 2 with SQL Server 2000.
="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
I've tried taking away all of the rs and rc syntax and still get the
same result.
Does anyone have any advice on how to make the syntax above work to
create a popup window from a report on the report server or provide any
syntax that makes it work?
Thanks a lot for your help!First, you are on RS 2000. Do you have SP1 or higher installed? Support for
this was introduced with SP1.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<nat.caserta@.telelogic.com> wrote in message
news:1154122192.850821.153220@.s13g2000cwa.googlegroups.com...
> Hello,
> I'm still having an issue with opening up a new window on the report
> server regarding the report designer's -> Jump to URL feature (option)
> in Advanced - Navigation.
> This is what I currently have now and I've tried the JavaScript syntax
> (expression) i've seen on the old boards, but I keeping getting a web
> syntax error from Visual Studio 2003.
> We are using Reporting Services Service Pack 2 with SQL Server 2000.
> ="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
> I've tried taking away all of the rs and rc syntax and still get the
> same result.
> Does anyone have any advice on how to make the syntax above work to
> create a popup window from a report on the report server or provide any
> syntax that makes it work?
> Thanks a lot for your help!
>|||Hi Bruce,
Seen you on quite a number of boards giving some good advice. We have
installed Services Pack 2 last year since it came out.
We understand that there is a hotfix to SP2 on this issue. Do we need
to install it to make your syntax work?
The Hot fix link is at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en
Otherwise, with SP2 installed i've tried what you've already suggested
with and without the " "&rs:Format=CSV&rc:Encoding=ASCII' ". I would
like for this to show up in an HTML popup window as opposed to an Excel
download.
Regards,
Nat
Bruce L-C [MVP] wrote:
> First, you are on RS 2000. Do you have SP1 or higher installed? Support for
> this was introduced with SP1.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> <nat.caserta@.telelogic.com> wrote in message
> news:1154122192.850821.153220@.s13g2000cwa.googlegroups.com...
> > Hello,
> >
> > I'm still having an issue with opening up a new window on the report
> > server regarding the report designer's -> Jump to URL feature (option)
> > in Advanced - Navigation.
> >
> > This is what I currently have now and I've tried the JavaScript syntax
> > (expression) i've seen on the old boards, but I keeping getting a web
> > syntax error from Visual Studio 2003.
> >
> > We are using Reporting Services Service Pack 2 with SQL Server 2000.
> >
> > ="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
> >
> > I've tried taking away all of the rs and rc syntax and still get the
> > same result.
> >
> > Does anyone have any advice on how to make the syntax above work to
> > create a popup window from a report on the report server or provide any
> > syntax that makes it work?
> >
> > Thanks a lot for your help!
> >sql
I'm still having an issue with opening up a new window on the report
server regarding the report designer's -> Jump to URL feature (option)
in Advanced - Navigation.
This is what I currently have now and I've tried the JavaScript syntax
(expression) i've seen on the old boards, but I keeping getting a web
syntax error from Visual Studio 2003.
We are using Reporting Services Service Pack 2 with SQL Server 2000.
="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
I've tried taking away all of the rs and rc syntax and still get the
same result.
Does anyone have any advice on how to make the syntax above work to
create a popup window from a report on the report server or provide any
syntax that makes it work?
Thanks a lot for your help!First, you are on RS 2000. Do you have SP1 or higher installed? Support for
this was introduced with SP1.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<nat.caserta@.telelogic.com> wrote in message
news:1154122192.850821.153220@.s13g2000cwa.googlegroups.com...
> Hello,
> I'm still having an issue with opening up a new window on the report
> server regarding the report designer's -> Jump to URL feature (option)
> in Advanced - Navigation.
> This is what I currently have now and I've tried the JavaScript syntax
> (expression) i've seen on the old boards, but I keeping getting a web
> syntax error from Visual Studio 2003.
> We are using Reporting Services Service Pack 2 with SQL Server 2000.
> ="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
> I've tried taking away all of the rs and rc syntax and still get the
> same result.
> Does anyone have any advice on how to make the syntax above work to
> create a popup window from a report on the report server or provide any
> syntax that makes it work?
> Thanks a lot for your help!
>|||Hi Bruce,
Seen you on quite a number of boards giving some good advice. We have
installed Services Pack 2 last year since it came out.
We understand that there is a hotfix to SP2 on this issue. Do we need
to install it to make your syntax work?
The Hot fix link is at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en
Otherwise, with SP2 installed i've tried what you've already suggested
with and without the " "&rs:Format=CSV&rc:Encoding=ASCII' ". I would
like for this to show up in an HTML popup window as opposed to an Excel
download.
Regards,
Nat
Bruce L-C [MVP] wrote:
> First, you are on RS 2000. Do you have SP1 or higher installed? Support for
> this was introduced with SP1.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> <nat.caserta@.telelogic.com> wrote in message
> news:1154122192.850821.153220@.s13g2000cwa.googlegroups.com...
> > Hello,
> >
> > I'm still having an issue with opening up a new window on the report
> > server regarding the report designer's -> Jump to URL feature (option)
> > in Advanced - Navigation.
> >
> > This is what I currently have now and I've tried the JavaScript syntax
> > (expression) i've seen on the old boards, but I keeping getting a web
> > syntax error from Visual Studio 2003.
> >
> > We are using Reporting Services Service Pack 2 with SQL Server 2000.
> >
> > ="http://ourserver/therepsvr?%2fMarketing+Reports%2fMarketing+New+Accounts+Details+Report&Division="&Parameters!Division.Value+"&SALESDEPT="&Parameters!SALESDEPT.Value+"&startdate="&Parameters!startdate.Value+"&enddate="&Parameters!enddate.Value+"&ACCTMGR="&Parameters!ACCTMGR.Value+"&WEB="&Parameters!WEB.Value+"&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&rc:LinkTarget=_blank&rs%3aParameterLanguage=en-US"
> >
> > I've tried taking away all of the rs and rc syntax and still get the
> > same result.
> >
> > Does anyone have any advice on how to make the syntax above work to
> > create a popup window from a report on the report server or provide any
> > syntax that makes it work?
> >
> > Thanks a lot for your help!
> >sql
Jump to URL - New Window - Ampersand
I have a Jump to URL hyperlink action using the "javascript:
void(window.open)" code. This works great, except when one of the parameters
contains an ampersand. I get an error saying that the "path of the item is
not valid. The full path must be less than 260 characters long, muster start
with slash..."
One of my parameters for the report that first comes up is
"OfficeDescription" which may contain an ampersand ("Boise R&D"). I'm
passing this to the URL as listed below. It only fails if there is that
ampersand in the OfficeDescription ("Boise Sales" works fine). I'm tried
replacing the "&" with %26 but I can't get that to work.
This works fine if I use a "Jump to Report" and pass the parameters that
way, but I need to pop up the report in a new window.
="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
Parameters!OfficeDescription.Value & "&Producer=" & Fields!Producer.Value &
"&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
Thanks for any advice anyone cares to offer!Parameter values must be URLEncoded. Please perform the following steps:
* load the report in report designer
* go to the report menu -> report properties -> References tab
* in the "References:" list, add a reference to System.Web, and click OK
* in the report, modify your expression to use the HttpUtility.UrlEncode
function (see MSDN:
http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
"&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
"&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"kaibh" <kaibh@.discussions.microsoft.com> wrote in message
news:7EAE0CF0-2C9C-47A8-8A2D-B5861AFA5740@.microsoft.com...
>I have a Jump to URL hyperlink action using the "javascript:
> void(window.open)" code. This works great, except when one of the
> parameters
> contains an ampersand. I get an error saying that the "path of the item
> is
> not valid. The full path must be less than 260 characters long, muster
> start
> with slash..."
> One of my parameters for the report that first comes up is
> "OfficeDescription" which may contain an ampersand ("Boise R&D"). I'm
> passing this to the URL as listed below. It only fails if there is that
> ampersand in the OfficeDescription ("Boise Sales" works fine). I'm tried
> replacing the "&" with %26 but I can't get that to work.
> This works fine if I use a "Jump to Report" and pass the parameters that
> way, but I need to pop up the report in a new window.
> ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> Parameters!OfficeDescription.Value & "&Producer=" & Fields!Producer.Value
> &
> "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> Thanks for any advice anyone cares to offer!
>|||Robert, thanks for the feedback, however I'm still getting the same error:
Reporting Services Error
The path of the item '/OnDemand/Producer Detail,C' is not valid.The full
path must be less than 260 characters long, must start with slash; other
restrictions apply. Check the documentation for complete set of restrictions.
(rsInvalidItemPath)
The HTML generated for this link looks like:
<a style="text-decoration:none;color:Black"
href="javascript:void(window.open('https://my.reportserver.com/ReportServer?/OnDemand/Producer%20Detail&OfficeDescription=Boise+r%26D&Producer=JSL&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))" TARGET="_top">JSL</a>
The "Boise R&D" is getting encoded as "Boise+R%26D", so that's good right?
But since I'm still getting this error, I assume there must be something else
that I'm missing.
Thanks
"Robert Bruckner [MSFT]" wrote:
> Parameter values must be URLEncoded. Please perform the following steps:
> * load the report in report designer
> * go to the report menu -> report properties -> References tab
> * in the "References:" list, add a reference to System.Web, and click OK
> * in the report, modify your expression to use the HttpUtility.UrlEncode
> function (see MSDN:
> http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
> ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
> "&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
> "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.|||I also am trying to do this. It works great in the IDE, but I get the
following error when publishing the report to Report Manager on my local
machine and any servers.
Request for the permission of type System.Web.AspNetHostingPermission,
System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.
It is probably permissions. How would I modify rssrvpolicy.config to allow
the execution of System.Web assembly?
Dan Bock
"kaibh" wrote:
> Robert, thanks for the feedback, however I'm still getting the same error:
> Reporting Services Error
> The path of the item '/OnDemand/Producer Detail,C' is not valid.The full
> path must be less than 260 characters long, must start with slash; other
> restrictions apply. Check the documentation for complete set of restrictions.
> (rsInvalidItemPath)
> The HTML generated for this link looks like:
> <a style="text-decoration:none;color:Black"
> href="http://links.10026.com/?link=javascript:void(window.open('https://my.reportserver.com/ReportServer?/OnDemand/Producer%20Detail&OfficeDescription=Boise+r%26D&Producer=JSL&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))" TARGET="_top">JSL</a>
> The "Boise R&D" is getting encoded as "Boise+R%26D", so that's good right?
> But since I'm still getting this error, I assume there must be something else
> that I'm missing.
> Thanks
>
> "Robert Bruckner [MSFT]" wrote:
> > Parameter values must be URLEncoded. Please perform the following steps:
> > * load the report in report designer
> > * go to the report menu -> report properties -> References tab
> > * in the "References:" list, add a reference to System.Web, and click OK
> > * in the report, modify your expression to use the HttpUtility.UrlEncode
> > function (see MSDN:
> > http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
> > ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> > Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> > System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
> > "&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
> > "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
>
void(window.open)" code. This works great, except when one of the parameters
contains an ampersand. I get an error saying that the "path of the item is
not valid. The full path must be less than 260 characters long, muster start
with slash..."
One of my parameters for the report that first comes up is
"OfficeDescription" which may contain an ampersand ("Boise R&D"). I'm
passing this to the URL as listed below. It only fails if there is that
ampersand in the OfficeDescription ("Boise Sales" works fine). I'm tried
replacing the "&" with %26 but I can't get that to work.
This works fine if I use a "Jump to Report" and pass the parameters that
way, but I need to pop up the report in a new window.
="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
Parameters!OfficeDescription.Value & "&Producer=" & Fields!Producer.Value &
"&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
Thanks for any advice anyone cares to offer!Parameter values must be URLEncoded. Please perform the following steps:
* load the report in report designer
* go to the report menu -> report properties -> References tab
* in the "References:" list, add a reference to System.Web, and click OK
* in the report, modify your expression to use the HttpUtility.UrlEncode
function (see MSDN:
http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
"&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
"&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"kaibh" <kaibh@.discussions.microsoft.com> wrote in message
news:7EAE0CF0-2C9C-47A8-8A2D-B5861AFA5740@.microsoft.com...
>I have a Jump to URL hyperlink action using the "javascript:
> void(window.open)" code. This works great, except when one of the
> parameters
> contains an ampersand. I get an error saying that the "path of the item
> is
> not valid. The full path must be less than 260 characters long, muster
> start
> with slash..."
> One of my parameters for the report that first comes up is
> "OfficeDescription" which may contain an ampersand ("Boise R&D"). I'm
> passing this to the URL as listed below. It only fails if there is that
> ampersand in the OfficeDescription ("Boise Sales" works fine). I'm tried
> replacing the "&" with %26 but I can't get that to work.
> This works fine if I use a "Jump to Report" and pass the parameters that
> way, but I need to pop up the report in a new window.
> ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> Parameters!OfficeDescription.Value & "&Producer=" & Fields!Producer.Value
> &
> "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> Thanks for any advice anyone cares to offer!
>|||Robert, thanks for the feedback, however I'm still getting the same error:
Reporting Services Error
The path of the item '/OnDemand/Producer Detail,C' is not valid.The full
path must be less than 260 characters long, must start with slash; other
restrictions apply. Check the documentation for complete set of restrictions.
(rsInvalidItemPath)
The HTML generated for this link looks like:
<a style="text-decoration:none;color:Black"
href="javascript:void(window.open('https://my.reportserver.com/ReportServer?/OnDemand/Producer%20Detail&OfficeDescription=Boise+r%26D&Producer=JSL&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))" TARGET="_top">JSL</a>
The "Boise R&D" is getting encoded as "Boise+R%26D", so that's good right?
But since I'm still getting this error, I assume there must be something else
that I'm missing.
Thanks
"Robert Bruckner [MSFT]" wrote:
> Parameter values must be URLEncoded. Please perform the following steps:
> * load the report in report designer
> * go to the report menu -> report properties -> References tab
> * in the "References:" list, add a reference to System.Web, and click OK
> * in the report, modify your expression to use the HttpUtility.UrlEncode
> function (see MSDN:
> http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
> ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
> "&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
> "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.|||I also am trying to do this. It works great in the IDE, but I get the
following error when publishing the report to Report Manager on my local
machine and any servers.
Request for the permission of type System.Web.AspNetHostingPermission,
System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.
It is probably permissions. How would I modify rssrvpolicy.config to allow
the execution of System.Web assembly?
Dan Bock
"kaibh" wrote:
> Robert, thanks for the feedback, however I'm still getting the same error:
> Reporting Services Error
> The path of the item '/OnDemand/Producer Detail,C' is not valid.The full
> path must be less than 260 characters long, must start with slash; other
> restrictions apply. Check the documentation for complete set of restrictions.
> (rsInvalidItemPath)
> The HTML generated for this link looks like:
> <a style="text-decoration:none;color:Black"
> href="http://links.10026.com/?link=javascript:void(window.open('https://my.reportserver.com/ReportServer?/OnDemand/Producer%20Detail&OfficeDescription=Boise+r%26D&Producer=JSL&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))" TARGET="_top">JSL</a>
> The "Boise R&D" is getting encoded as "Boise+R%26D", so that's good right?
> But since I'm still getting this error, I assume there must be something else
> that I'm missing.
> Thanks
>
> "Robert Bruckner [MSFT]" wrote:
> > Parameter values must be URLEncoded. Please perform the following steps:
> > * load the report in report designer
> > * go to the report menu -> report properties -> References tab
> > * in the "References:" list, add a reference to System.Web, and click OK
> > * in the report, modify your expression to use the HttpUtility.UrlEncode
> > function (see MSDN:
> > http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode):
> > ="javascript:void(window.open('"&Globals!ReportServerUrl+ "?" &
> > Globals!ReportFolder & "/Producer Detail&OfficeDescription=" &
> > System.Web.HttpUtility.UrlEncode(Parameters!OfficeDescription.Value) &
> > "&Producer=" & System.Web.HttpUtility.UrlEncode(Fields!Producer.Value) &
> > "&rc%3aParameters=false','_blank','height=530px,left=1px,location=no,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=1px,width=780px'))"
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
>
Jump to URL - Javascript
We are displaying reports in a PDF format through an aspx page.
I have put and URL link in an report as follows to open a new
window(cotaining another report)
="javascript:void(window.open('http://localhost/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args="
& REPORTARGS &
"','GraphDetail','left=50,top=50,width=800,height=580,menubar=no,resizable=yes,scrollbars=Yes,status=yes,toolbar=0'))"
When the report is displayed for the first time...the URL link works fine. I
get an security msg from adobe reader saying document is trying to open this
link ..asks to block or allow...when i click Allow ..the new window
opens(with the report). But when i close this new window and reclick the
link...it does not work.
I have been stuck in this for 4 days now...i am not getting what is the
issue...
The aspx page has frames...but i do not see any issue with that either...i
am tried with a simple aspx page...same issue...i have tried allowing
pop-ups ...etc
I think this is issue with adobe reader ..because if i display the report
in HTML format...the link works fine...opens every time i click it!!!!.
Has anyone has had any similar issues!!!!...
Can anyone help me ...all i want to do is...open a link in new window from
an deployed PDF report ...link is an aspx page with a new detail report.
Thanks.Hi,
my jump to link is similar and working.
my link is like this..
="javascript:" &
IIF(Fields!Acked.Value = 1,"void(0)",
"var sRS='" & Globals!ReportServerUrl &
"';void(window.open(sRS.substring(0,sRS.indexOf('/ReportServer')) +
'/rtreporting/acknowledge.aspx?FilterID=" & Fields!FILTERID.Value &
"&prmServer=" & Fields!SERVER.Value & "&prmStartDate=" &
Format(Parameters!prmDateFrom.Value,"yyyy-MM-dd HH:mm:ss") & "&prmEndDate=" &
Format(Parameters!prmDateTo.Value,"yyyy-MM-dd HH:mm:ss") & "','_blank'))")
can you use Globals!ReportServerUrl instead of localhost.
also try using _blank parameter and make it default size..
"Sunny" wrote:
> We are displaying reports in a PDF format through an aspx page.
> I have put and URL link in an report as follows to open a new
> window(cotaining another report)
> ="javascript:void(window.open('http://localhost/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args="
> & REPORTARGS &
> "','GraphDetail','left=50,top=50,width=800,height=580,menubar=no,resizable=yes,scrollbars=Yes,status=yes,toolbar=0'))"
>
> When the report is displayed for the first time...the URL link works fine. I
> get an security msg from adobe reader saying document is trying to open this
> link ..asks to block or allow...when i click Allow ..the new window
> opens(with the report). But when i close this new window and reclick the
> link...it does not work.
> I have been stuck in this for 4 days now...i am not getting what is the
> issue...
> The aspx page has frames...but i do not see any issue with that either...i
> am tried with a simple aspx page...same issue...i have tried allowing
> pop-ups ...etc
> I think this is issue with adobe reader ..because if i display the report
> in HTML format...the link works fine...opens every time i click it!!!!.
> Has anyone has had any similar issues!!!!...
> Can anyone help me ...all i want to do is...open a link in new window from
> an deployed PDF report ...link is an aspx page with a new detail report.
> Thanks.
I have put and URL link in an report as follows to open a new
window(cotaining another report)
="javascript:void(window.open('http://localhost/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args="
& REPORTARGS &
"','GraphDetail','left=50,top=50,width=800,height=580,menubar=no,resizable=yes,scrollbars=Yes,status=yes,toolbar=0'))"
When the report is displayed for the first time...the URL link works fine. I
get an security msg from adobe reader saying document is trying to open this
link ..asks to block or allow...when i click Allow ..the new window
opens(with the report). But when i close this new window and reclick the
link...it does not work.
I have been stuck in this for 4 days now...i am not getting what is the
issue...
The aspx page has frames...but i do not see any issue with that either...i
am tried with a simple aspx page...same issue...i have tried allowing
pop-ups ...etc
I think this is issue with adobe reader ..because if i display the report
in HTML format...the link works fine...opens every time i click it!!!!.
Has anyone has had any similar issues!!!!...
Can anyone help me ...all i want to do is...open a link in new window from
an deployed PDF report ...link is an aspx page with a new detail report.
Thanks.Hi,
my jump to link is similar and working.
my link is like this..
="javascript:" &
IIF(Fields!Acked.Value = 1,"void(0)",
"var sRS='" & Globals!ReportServerUrl &
"';void(window.open(sRS.substring(0,sRS.indexOf('/ReportServer')) +
'/rtreporting/acknowledge.aspx?FilterID=" & Fields!FILTERID.Value &
"&prmServer=" & Fields!SERVER.Value & "&prmStartDate=" &
Format(Parameters!prmDateFrom.Value,"yyyy-MM-dd HH:mm:ss") & "&prmEndDate=" &
Format(Parameters!prmDateTo.Value,"yyyy-MM-dd HH:mm:ss") & "','_blank'))")
can you use Globals!ReportServerUrl instead of localhost.
also try using _blank parameter and make it default size..
"Sunny" wrote:
> We are displaying reports in a PDF format through an aspx page.
> I have put and URL link in an report as follows to open a new
> window(cotaining another report)
> ="javascript:void(window.open('http://localhost/ReportViewer/ReportFrame.aspx?rptPath=REPORTPATH&args="
> & REPORTARGS &
> "','GraphDetail','left=50,top=50,width=800,height=580,menubar=no,resizable=yes,scrollbars=Yes,status=yes,toolbar=0'))"
>
> When the report is displayed for the first time...the URL link works fine. I
> get an security msg from adobe reader saying document is trying to open this
> link ..asks to block or allow...when i click Allow ..the new window
> opens(with the report). But when i close this new window and reclick the
> link...it does not work.
> I have been stuck in this for 4 days now...i am not getting what is the
> issue...
> The aspx page has frames...but i do not see any issue with that either...i
> am tried with a simple aspx page...same issue...i have tried allowing
> pop-ups ...etc
> I think this is issue with adobe reader ..because if i display the report
> in HTML format...the link works fine...opens every time i click it!!!!.
> Has anyone has had any similar issues!!!!...
> Can anyone help me ...all i want to do is...open a link in new window from
> an deployed PDF report ...link is an aspx page with a new detail report.
> Thanks.
Jump to URL
to open a report in a new window
i looked up the following line of code
=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&rs:Command=Render&rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"
I do not understand what & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" &
this implies.
I have the current report name as
http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000648
and I need to jump to
http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000699
both reports are in same folder IMS-Reports.
Thanks
"javascript:void window.open('ReportViewer.aspx? %2fCR000699', '_top', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')"
use the above code.
In reportviewer.aspx page you need to write the code as
rptViewer.ServerReport.ReportServerUrl = new Uri(http://Reportservername);
rptViewer.ServerReport.ReportPath = "/IMS-Reports/" + Request.QueryString[0];
rptViewer.ProcessingMode = ProcessingMode.Remote;
Hope it will help you
Rakam.
|||Thanks for the reply rakam,
Where do I write and store reportviewer.aspx?
Sorry for being illiterate here.
Thanks
|||Just use the following code
"javascript:void window.open('http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000699', '_top', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')"
hope it will work
sqlWednesday, March 28, 2012
Jump to report in new window?
Hi all,
Is it possible to use the "jump to report " action and have the report open in a new window?
regards,
Bill
lil' bump|||Does anyone know the answer to this question?|||Check out this thread. It should help you out.
http://tek-tips.com/viewthread.cfm?qid=1367703&page=1
regards
sqlJump to report in new window?
Hi all,
Is it possible to use the "jump to report " action and have the report open in a new window?
regards,
Bill
lil' bump|||Does anyone know the answer to this question?|||Check out this thread. It should help you out.
http://tek-tips.com/viewthread.cfm?qid=1367703&page=1
regards
Subscribe to:
Posts (Atom)