Expression as Hyperlink

We are using SSRS SP2 in SharePoint integrated mode and when I use an
expression that results in a URL that I use for a hyperlink in a report, it
works in Visual Studio but not in report viewer. If I use a static URL it
works fine.
Upon inspection of the source that is returned by SSRS when using an
expression for the URL, it doen's even add the <a href=> tag to the resulting
HTML. It is as if SSRS won't process an expression for a hyperlink but
Visual Studio's preview will. How am I supposed to have dynamic hyperlinks
in my reports? Any ideas?Are you using jump to URL? I use an expression all the time in there but not
with Sharepoint.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in message
news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
> We are using SSRS SP2 in SharePoint integrated mode and when I use an
> expression that results in a URL that I use for a hyperlink in a report,
> it
> works in Visual Studio but not in report viewer. If I use a static URL it
> works fine.
> Upon inspection of the source that is returned by SSRS when using an
> expression for the URL, it doen's even add the <a href=> tag to the
> resulting
> HTML. It is as if SSRS won't process an expression for a hyperlink but
> Visual Studio's preview will. How am I supposed to have dynamic
> hyperlinks
> in my reports? Any ideas?
>|||Yes I am using Jump To URL. I just read one of your previous posts Bruce and
I used:
="javascript:void(window.open('" & [My URL Expression] & "'))"
This solved my problem. I still don't know why the expression by itself
doesn't produce a hyperlink but this appears to trick SSRS into rendering it.
"Bruce L-C [MVP]" wrote:
> Are you using jump to URL? I use an expression all the time in there but not
> with Sharepoint.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in message
> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
> > We are using SSRS SP2 in SharePoint integrated mode and when I use an
> > expression that results in a URL that I use for a hyperlink in a report,
> > it
> > works in Visual Studio but not in report viewer. If I use a static URL it
> > works fine.
> >
> > Upon inspection of the source that is returned by SSRS when using an
> > expression for the URL, it doen's even add the <a href=> tag to the
> > resulting
> > HTML. It is as if SSRS won't process an expression for a hyperlink but
> > Visual Studio's preview will. How am I supposed to have dynamic
> > hyperlinks
> > in my reports? Any ideas?
> >
> >
>
>|||Good. Glad that worked for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in message
news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
> Yes I am using Jump To URL. I just read one of your previous posts Bruce
> and
> I used:
> ="javascript:void(window.open('" & [My URL Expression] & "'))"
> This solved my problem. I still don't know why the expression by itself
> doesn't produce a hyperlink but this appears to trick SSRS into rendering
> it.
>
> "Bruce L-C [MVP]" wrote:
>> Are you using jump to URL? I use an expression all the time in there but
>> not
>> with Sharepoint.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in message
>> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
>> > We are using SSRS SP2 in SharePoint integrated mode and when I use an
>> > expression that results in a URL that I use for a hyperlink in a
>> > report,
>> > it
>> > works in Visual Studio but not in report viewer. If I use a static URL
>> > it
>> > works fine.
>> >
>> > Upon inspection of the source that is returned by SSRS when using an
>> > expression for the URL, it doen's even add the <a href=> tag to the
>> > resulting
>> > HTML. It is as if SSRS won't process an expression for a hyperlink but
>> > Visual Studio's preview will. How am I supposed to have dynamic
>> > hyperlinks
>> > in my reports? Any ideas?
>> >
>> >
>>|||Hi Bruce,
I did the same thing but getting the following error :
"Internet explorer cannot download.Unspecified error".
The only difference is that we have a popup window that opens a server
report in PDF format using URL access and within this report there are
hyperlinks to webpages.On clicking the hyperlinks from within the report we
get the following error :
"Internet explorer cannot download.Unspecified error".
we have used javascript in the jump to URL expression:
="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
Trim(Cstr(Fields!ProjectUID.Value)) + "','_blank','location=no,toolbar=no'))"
Can you guide me on this?
"Bruce L-C [MVP]" wrote:
> Good. Glad that worked for you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in message
> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
> > Yes I am using Jump To URL. I just read one of your previous posts Bruce
> > and
> > I used:
> >
> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
> >
> > This solved my problem. I still don't know why the expression by itself
> > doesn't produce a hyperlink but this appears to trick SSRS into rendering
> > it.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Are you using jump to URL? I use an expression all the time in there but
> >> not
> >> with Sharepoint.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in message
> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
> >> > We are using SSRS SP2 in SharePoint integrated mode and when I use an
> >> > expression that results in a URL that I use for a hyperlink in a
> >> > report,
> >> > it
> >> > works in Visual Studio but not in report viewer. If I use a static URL
> >> > it
> >> > works fine.
> >> >
> >> > Upon inspection of the source that is returned by SSRS when using an
> >> > expression for the URL, it doen's even add the <a href=> tag to the
> >> > resulting
> >> > HTML. It is as if SSRS won't process an expression for a hyperlink but
> >> > Visual Studio's preview will. How am I supposed to have dynamic
> >> > hyperlinks
> >> > in my reports? Any ideas?
> >> >
> >> >
> >>
> >>
> >>
>
>|||Here are two working ones for me:
="javascript:void(window.open('http://www.google.com/','_blank'))"
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
I am using & instead of +, and I don't have the ,'location=no,toolbar=no'
Other than that I am not seeing much different.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
> Hi Bruce,
> I did the same thing but getting the following error :
> "Internet explorer cannot download.Unspecified error".
> The only difference is that we have a popup window that opens a server
> report in PDF format using URL access and within this report there are
> hyperlinks to webpages.On clicking the hyperlinks from within the report
> we
> get the following error :
> "Internet explorer cannot download.Unspecified error".
> we have used javascript in the jump to URL expression:
> ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
> Trim(Cstr(Fields!ProjectUID.Value)) +
> "','_blank','location=no,toolbar=no'))"
> Can you guide me on this?
>
> "Bruce L-C [MVP]" wrote:
>> Good. Glad that worked for you.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in message
>> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
>> > Yes I am using Jump To URL. I just read one of your previous posts
>> > Bruce
>> > and
>> > I used:
>> >
>> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
>> >
>> > This solved my problem. I still don't know why the expression by
>> > itself
>> > doesn't produce a hyperlink but this appears to trick SSRS into
>> > rendering
>> > it.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Are you using jump to URL? I use an expression all the time in there
>> >> but
>> >> not
>> >> with Sharepoint.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
>> >> > We are using SSRS SP2 in SharePoint integrated mode and when I use
>> >> > an
>> >> > expression that results in a URL that I use for a hyperlink in a
>> >> > report,
>> >> > it
>> >> > works in Visual Studio but not in report viewer. If I use a static
>> >> > URL
>> >> > it
>> >> > works fine.
>> >> >
>> >> > Upon inspection of the source that is returned by SSRS when using an
>> >> > expression for the URL, it doen's even add the <a href=> tag to the
>> >> > resulting
>> >> > HTML. It is as if SSRS won't process an expression for a hyperlink
>> >> > but
>> >> > Visual Studio's preview will. How am I supposed to have dynamic
>> >> > hyperlinks
>> >> > in my reports? Any ideas?
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||Thanks Bruce.I tried with & and the problem still persists. We are using
Microsoft SQL Server 2005 Reporting Services Version 9.00.3042.00. Does the
version really matter in this case.I read some where that we need need SP1
and above.Kindly advice.
"Bruce L-C [MVP]" wrote:
> Here are two working ones for me:
> ="javascript:void(window.open('http://www.google.com/','_blank'))"
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
> I am using & instead of +, and I don't have the ,'location=no,toolbar=no'
> Other than that I am not seeing much different.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
> > Hi Bruce,
> > I did the same thing but getting the following error :
> >
> > "Internet explorer cannot download.Unspecified error".
> >
> > The only difference is that we have a popup window that opens a server
> > report in PDF format using URL access and within this report there are
> > hyperlinks to webpages.On clicking the hyperlinks from within the report
> > we
> > get the following error :
> >
> > "Internet explorer cannot download.Unspecified error".
> >
> > we have used javascript in the jump to URL expression:
> >
> > ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid=" +
> > Trim(Cstr(Fields!ProjectUID.Value)) +
> > "','_blank','location=no,toolbar=no'))"
> >
> > Can you guide me on this?
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Good. Glad that worked for you.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in message
> >> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
> >> > Yes I am using Jump To URL. I just read one of your previous posts
> >> > Bruce
> >> > and
> >> > I used:
> >> >
> >> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
> >> >
> >> > This solved my problem. I still don't know why the expression by
> >> > itself
> >> > doesn't produce a hyperlink but this appears to trick SSRS into
> >> > rendering
> >> > it.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Are you using jump to URL? I use an expression all the time in there
> >> >> but
> >> >> not
> >> >> with Sharepoint.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
> >> >> > We are using SSRS SP2 in SharePoint integrated mode and when I use
> >> >> > an
> >> >> > expression that results in a URL that I use for a hyperlink in a
> >> >> > report,
> >> >> > it
> >> >> > works in Visual Studio but not in report viewer. If I use a static
> >> >> > URL
> >> >> > it
> >> >> > works fine.
> >> >> >
> >> >> > Upon inspection of the source that is returned by SSRS when using an
> >> >> > expression for the URL, it doen's even add the <a href=> tag to the
> >> >> > resulting
> >> >> > HTML. It is as if SSRS won't process an expression for a hyperlink
> >> >> > but
> >> >> > Visual Studio's preview will. How am I supposed to have dynamic
> >> >> > hyperlinks
> >> >> > in my reports? Any ideas?
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||SP1 and above was in regards to 2000. Any version of 2005 will work. Have
you tried putting in the google example just for a test?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
news:AA97AFAD-763D-4FF5-8E06-EBC5C0454DB6@.microsoft.com...
> Thanks Bruce.I tried with & and the problem still persists. We are using
> Microsoft SQL Server 2005 Reporting Services Version 9.00.3042.00. Does
> the
> version really matter in this case.I read some where that we need need SP1
> and above.Kindly advice.
> "Bruce L-C [MVP]" wrote:
>> Here are two working ones for me:
>> ="javascript:void(window.open('http://www.google.com/','_blank'))"
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
>> I am using & instead of +, and I don't have the ,'location=no,toolbar=no'
>> Other than that I am not seeing much different.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
>> > Hi Bruce,
>> > I did the same thing but getting the following error :
>> >
>> > "Internet explorer cannot download.Unspecified error".
>> >
>> > The only difference is that we have a popup window that opens a server
>> > report in PDF format using URL access and within this report there are
>> > hyperlinks to webpages.On clicking the hyperlinks from within the
>> > report
>> > we
>> > get the following error :
>> >
>> > "Internet explorer cannot download.Unspecified error".
>> >
>> > we have used javascript in the jump to URL expression:
>> >
>> > ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid="
>> > +
>> > Trim(Cstr(Fields!ProjectUID.Value)) +
>> > "','_blank','location=no,toolbar=no'))"
>> >
>> > Can you guide me on this?
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Good. Glad that worked for you.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
>> >> > Yes I am using Jump To URL. I just read one of your previous posts
>> >> > Bruce
>> >> > and
>> >> > I used:
>> >> >
>> >> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
>> >> >
>> >> > This solved my problem. I still don't know why the expression by
>> >> > itself
>> >> > doesn't produce a hyperlink but this appears to trick SSRS into
>> >> > rendering
>> >> > it.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Are you using jump to URL? I use an expression all the time in
>> >> >> there
>> >> >> but
>> >> >> not
>> >> >> with Sharepoint.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
>> >> >> > We are using SSRS SP2 in SharePoint integrated mode and when I
>> >> >> > use
>> >> >> > an
>> >> >> > expression that results in a URL that I use for a hyperlink in a
>> >> >> > report,
>> >> >> > it
>> >> >> > works in Visual Studio but not in report viewer. If I use a
>> >> >> > static
>> >> >> > URL
>> >> >> > it
>> >> >> > works fine.
>> >> >> >
>> >> >> > Upon inspection of the source that is returned by SSRS when using
>> >> >> > an
>> >> >> > expression for the URL, it doen's even add the <a href=> tag to
>> >> >> > the
>> >> >> > resulting
>> >> >> > HTML. It is as if SSRS won't process an expression for a
>> >> >> > hyperlink
>> >> >> > but
>> >> >> > Visual Studio's preview will. How am I supposed to have dynamic
>> >> >> > hyperlinks
>> >> >> > in my reports? Any ideas?
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||I tried just now.It is still saying :
"Internet explorer cannot download.Unspecified error".
I'm using IE 7.0 on my dev machine.It works fine when the hyperlink within
the report is invoked directly from report viewer on
http://hostname/reportserver but hyperlink invokation fails when we make URL
request to the pdf via
http://domainName/ReportServer?rs:format=PDF&rs:report=/MyReports/MyReportName
Kindly advice.
get the following error "Bruce L-C [MVP]" wrote:
> SP1 and above was in regards to 2000. Any version of 2005 will work. Have
> you tried putting in the google example just for a test?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> news:AA97AFAD-763D-4FF5-8E06-EBC5C0454DB6@.microsoft.com...
> > Thanks Bruce.I tried with & and the problem still persists. We are using
> > Microsoft SQL Server 2005 Reporting Services Version 9.00.3042.00. Does
> > the
> > version really matter in this case.I read some where that we need need SP1
> > and above.Kindly advice.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here are two working ones for me:
> >> ="javascript:void(window.open('http://www.google.com/','_blank'))"
> >>
> >> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> "?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
> >>
> >> I am using & instead of +, and I don't have the ,'location=no,toolbar=no'
> >>
> >> Other than that I am not seeing much different.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> >> news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
> >> > Hi Bruce,
> >> > I did the same thing but getting the following error :
> >> >
> >> > "Internet explorer cannot download.Unspecified error".
> >> >
> >> > The only difference is that we have a popup window that opens a server
> >> > report in PDF format using URL access and within this report there are
> >> > hyperlinks to webpages.On clicking the hyperlinks from within the
> >> > report
> >> > we
> >> > get the following error :
> >> >
> >> > "Internet explorer cannot download.Unspecified error".
> >> >
> >> > we have used javascript in the jump to URL expression:
> >> >
> >> > ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid="
> >> > +
> >> > Trim(Cstr(Fields!ProjectUID.Value)) +
> >> > "','_blank','location=no,toolbar=no'))"
> >> >
> >> > Can you guide me on this?
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Good. Glad that worked for you.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
> >> >> > Yes I am using Jump To URL. I just read one of your previous posts
> >> >> > Bruce
> >> >> > and
> >> >> > I used:
> >> >> >
> >> >> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
> >> >> >
> >> >> > This solved my problem. I still don't know why the expression by
> >> >> > itself
> >> >> > doesn't produce a hyperlink but this appears to trick SSRS into
> >> >> > rendering
> >> >> > it.
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> Are you using jump to URL? I use an expression all the time in
> >> >> >> there
> >> >> >> but
> >> >> >> not
> >> >> >> with Sharepoint.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
> >> >> >> > We are using SSRS SP2 in SharePoint integrated mode and when I
> >> >> >> > use
> >> >> >> > an
> >> >> >> > expression that results in a URL that I use for a hyperlink in a
> >> >> >> > report,
> >> >> >> > it
> >> >> >> > works in Visual Studio but not in report viewer. If I use a
> >> >> >> > static
> >> >> >> > URL
> >> >> >> > it
> >> >> >> > works fine.
> >> >> >> >
> >> >> >> > Upon inspection of the source that is returned by SSRS when using
> >> >> >> > an
> >> >> >> > expression for the URL, it doen's even add the <a href=> tag to
> >> >> >> > the
> >> >> >> > resulting
> >> >> >> > HTML. It is as if SSRS won't process an expression for a
> >> >> >> > hyperlink
> >> >> >> > but
> >> >> >> > Visual Studio's preview will. How am I supposed to have dynamic
> >> >> >> > hyperlinks
> >> >> >> > in my reports? Any ideas?
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I'm confused. Are you saying that when you try
="javascript:void(window.open('http://www.google.com/','_blank'))"
You get "Internet explorer cannot download.Unspecified error"?
If you are trying this from the development environment it won't work. You
have to deploy to test jump to URL.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
news:566219F0-0B28-4CD3-AC82-F2E5F7A25599@.microsoft.com...
>I tried just now.It is still saying :
> "Internet explorer cannot download.Unspecified error".
> I'm using IE 7.0 on my dev machine.It works fine when the hyperlink within
> the report is invoked directly from report viewer on
> http://hostname/reportserver but hyperlink invokation fails when we make
> URL
> request to the pdf via
> http://domainName/ReportServer?rs:format=PDF&rs:report=/MyReports/MyReportName
> Kindly advice.
>
> get the following error "Bruce L-C [MVP]" wrote:
>> SP1 and above was in regards to 2000. Any version of 2005 will work. Have
>> you tried putting in the google example just for a test?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> news:AA97AFAD-763D-4FF5-8E06-EBC5C0454DB6@.microsoft.com...
>> > Thanks Bruce.I tried with & and the problem still persists. We are
>> > using
>> > Microsoft SQL Server 2005 Reporting Services Version 9.00.3042.00. Does
>> > the
>> > version really matter in this case.I read some where that we need need
>> > SP1
>> > and above.Kindly advice.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Here are two working ones for me:
>> >> ="javascript:void(window.open('http://www.google.com/','_blank'))"
>> >>
>> >> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> "?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
>> >>
>> >> I am using & instead of +, and I don't have the
>> >> ,'location=no,toolbar=no'
>> >>
>> >> Other than that I am not seeing much different.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> >> news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
>> >> > Hi Bruce,
>> >> > I did the same thing but getting the following error :
>> >> >
>> >> > "Internet explorer cannot download.Unspecified error".
>> >> >
>> >> > The only difference is that we have a popup window that opens a
>> >> > server
>> >> > report in PDF format using URL access and within this report there
>> >> > are
>> >> > hyperlinks to webpages.On clicking the hyperlinks from within the
>> >> > report
>> >> > we
>> >> > get the following error :
>> >> >
>> >> > "Internet explorer cannot download.Unspecified error".
>> >> >
>> >> > we have used javascript in the jump to URL expression:
>> >> >
>> >> > ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid="
>> >> > +
>> >> > Trim(Cstr(Fields!ProjectUID.Value)) +
>> >> > "','_blank','location=no,toolbar=no'))"
>> >> >
>> >> > Can you guide me on this?
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Good. Glad that worked for you.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
>> >> >> > Yes I am using Jump To URL. I just read one of your previous
>> >> >> > posts
>> >> >> > Bruce
>> >> >> > and
>> >> >> > I used:
>> >> >> >
>> >> >> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
>> >> >> >
>> >> >> > This solved my problem. I still don't know why the expression by
>> >> >> > itself
>> >> >> > doesn't produce a hyperlink but this appears to trick SSRS into
>> >> >> > rendering
>> >> >> > it.
>> >> >> >
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> Are you using jump to URL? I use an expression all the time in
>> >> >> >> there
>> >> >> >> but
>> >> >> >> not
>> >> >> >> with Sharepoint.
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
>> >> >> >> > We are using SSRS SP2 in SharePoint integrated mode and when I
>> >> >> >> > use
>> >> >> >> > an
>> >> >> >> > expression that results in a URL that I use for a hyperlink in
>> >> >> >> > a
>> >> >> >> > report,
>> >> >> >> > it
>> >> >> >> > works in Visual Studio but not in report viewer. If I use a
>> >> >> >> > static
>> >> >> >> > URL
>> >> >> >> > it
>> >> >> >> > works fine.
>> >> >> >> >
>> >> >> >> > Upon inspection of the source that is returned by SSRS when
>> >> >> >> > using
>> >> >> >> > an
>> >> >> >> > expression for the URL, it doen's even add the <a href=> tag
>> >> >> >> > to
>> >> >> >> > the
>> >> >> >> > resulting
>> >> >> >> > HTML. It is as if SSRS won't process an expression for a
>> >> >> >> > hyperlink
>> >> >> >> > but
>> >> >> >> > Visual Studio's preview will. How am I supposed to have
>> >> >> >> > dynamic
>> >> >> >> > hyperlinks
>> >> >> >> > in my reports? Any ideas?
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||using "javascript:void(window.open('http://www.google.com/','_blank'))" in
jump to URL works fine when i deploy it on report server but i keep getting
"Internet explorer cannot download.Unspecified error" when we render the
report in pdf format from our web app in a popup using URL access method.
"Bruce L-C [MVP]" wrote:
> I'm confused. Are you saying that when you try
> ="javascript:void(window.open('http://www.google.com/','_blank'))"
> You get "Internet explorer cannot download.Unspecified error"?
> If you are trying this from the development environment it won't work. You
> have to deploy to test jump to URL.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> news:566219F0-0B28-4CD3-AC82-F2E5F7A25599@.microsoft.com...
> >I tried just now.It is still saying :
> > "Internet explorer cannot download.Unspecified error".
> >
> > I'm using IE 7.0 on my dev machine.It works fine when the hyperlink within
> > the report is invoked directly from report viewer on
> > http://hostname/reportserver but hyperlink invokation fails when we make
> > URL
> > request to the pdf via
> > http://domainName/ReportServer?rs:format=PDF&rs:report=/MyReports/MyReportName
> >
> > Kindly advice.
> >
> >
> >
> > get the following error "Bruce L-C [MVP]" wrote:
> >
> >> SP1 and above was in regards to 2000. Any version of 2005 will work. Have
> >> you tried putting in the google example just for a test?
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> >> news:AA97AFAD-763D-4FF5-8E06-EBC5C0454DB6@.microsoft.com...
> >> > Thanks Bruce.I tried with & and the problem still persists. We are
> >> > using
> >> > Microsoft SQL Server 2005 Reporting Services Version 9.00.3042.00. Does
> >> > the
> >> > version really matter in this case.I read some where that we need need
> >> > SP1
> >> > and above.Kindly advice.
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Here are two working ones for me:
> >> >> ="javascript:void(window.open('http://www.google.com/','_blank'))"
> >> >>
> >> >> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> >> "?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
> >> >>
> >> >> I am using & instead of +, and I don't have the
> >> >> ,'location=no,toolbar=no'
> >> >>
> >> >> Other than that I am not seeing much different.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> >> >> news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
> >> >> > Hi Bruce,
> >> >> > I did the same thing but getting the following error :
> >> >> >
> >> >> > "Internet explorer cannot download.Unspecified error".
> >> >> >
> >> >> > The only difference is that we have a popup window that opens a
> >> >> > server
> >> >> > report in PDF format using URL access and within this report there
> >> >> > are
> >> >> > hyperlinks to webpages.On clicking the hyperlinks from within the
> >> >> > report
> >> >> > we
> >> >> > get the following error :
> >> >> >
> >> >> > "Internet explorer cannot download.Unspecified error".
> >> >> >
> >> >> > we have used javascript in the jump to URL expression:
> >> >> >
> >> >> > ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid="
> >> >> > +
> >> >> > Trim(Cstr(Fields!ProjectUID.Value)) +
> >> >> > "','_blank','location=no,toolbar=no'))"
> >> >> >
> >> >> > Can you guide me on this?
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> Good. Glad that worked for you.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
> >> >> >> > Yes I am using Jump To URL. I just read one of your previous
> >> >> >> > posts
> >> >> >> > Bruce
> >> >> >> > and
> >> >> >> > I used:
> >> >> >> >
> >> >> >> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
> >> >> >> >
> >> >> >> > This solved my problem. I still don't know why the expression by
> >> >> >> > itself
> >> >> >> > doesn't produce a hyperlink but this appears to trick SSRS into
> >> >> >> > rendering
> >> >> >> > it.
> >> >> >> >
> >> >> >> >
> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >
> >> >> >> >> Are you using jump to URL? I use an expression all the time in
> >> >> >> >> there
> >> >> >> >> but
> >> >> >> >> not
> >> >> >> >> with Sharepoint.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >>
> >> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
> >> >> >> >> > We are using SSRS SP2 in SharePoint integrated mode and when I
> >> >> >> >> > use
> >> >> >> >> > an
> >> >> >> >> > expression that results in a URL that I use for a hyperlink in
> >> >> >> >> > a
> >> >> >> >> > report,
> >> >> >> >> > it
> >> >> >> >> > works in Visual Studio but not in report viewer. If I use a
> >> >> >> >> > static
> >> >> >> >> > URL
> >> >> >> >> > it
> >> >> >> >> > works fine.
> >> >> >> >> >
> >> >> >> >> > Upon inspection of the source that is returned by SSRS when
> >> >> >> >> > using
> >> >> >> >> > an
> >> >> >> >> > expression for the URL, it doen's even add the <a href=> tag
> >> >> >> >> > to
> >> >> >> >> > the
> >> >> >> >> > resulting
> >> >> >> >> > HTML. It is as if SSRS won't process an expression for a
> >> >> >> >> > hyperlink
> >> >> >> >> > but
> >> >> >> >> > Visual Studio's preview will. How am I supposed to have
> >> >> >> >> > dynamic
> >> >> >> >> > hyperlinks
> >> >> >> >> > in my reports? Any ideas?
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||OK, now I understand. The issue is not getting the link to work from normal
html report. That is working for you. The issue is having the link work from
a PDF. I tried some tests from PDF and Excel. Excel usually had no problem.
PDF would flash and nothing would come up.
I also tried the link without using the javascript command. That would be
erratic, sometimes working sometimes not. I think some sort of security
setting is getting in the way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
news:3A861D11-30D4-4F6B-9849-19F17A328FEE@.microsoft.com...
> using "javascript:void(window.open('http://www.google.com/','_blank'))" in
> jump to URL works fine when i deploy it on report server but i keep
> getting
> "Internet explorer cannot download.Unspecified error" when we render the
> report in pdf format from our web app in a popup using URL access method.
>
>
> "Bruce L-C [MVP]" wrote:
>> I'm confused. Are you saying that when you try
>> ="javascript:void(window.open('http://www.google.com/','_blank'))"
>> You get "Internet explorer cannot download.Unspecified error"?
>> If you are trying this from the development environment it won't work.
>> You
>> have to deploy to test jump to URL.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> news:566219F0-0B28-4CD3-AC82-F2E5F7A25599@.microsoft.com...
>> >I tried just now.It is still saying :
>> > "Internet explorer cannot download.Unspecified error".
>> >
>> > I'm using IE 7.0 on my dev machine.It works fine when the hyperlink
>> > within
>> > the report is invoked directly from report viewer on
>> > http://hostname/reportserver but hyperlink invokation fails when we
>> > make
>> > URL
>> > request to the pdf via
>> > http://domainName/ReportServer?rs:format=PDF&rs:report=/MyReports/MyReportName
>> >
>> > Kindly advice.
>> >
>> >
>> >
>> > get the following error "Bruce L-C [MVP]" wrote:
>> >
>> >> SP1 and above was in regards to 2000. Any version of 2005 will work.
>> >> Have
>> >> you tried putting in the google example just for a test?
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> >> news:AA97AFAD-763D-4FF5-8E06-EBC5C0454DB6@.microsoft.com...
>> >> > Thanks Bruce.I tried with & and the problem still persists. We are
>> >> > using
>> >> > Microsoft SQL Server 2005 Reporting Services Version 9.00.3042.00.
>> >> > Does
>> >> > the
>> >> > version really matter in this case.I read some where that we need
>> >> > need
>> >> > SP1
>> >> > and above.Kindly advice.
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Here are two working ones for me:
>> >> >> ="javascript:void(window.open('http://www.google.com/','_blank'))"
>> >> >>
>> >> >> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> >> "?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
>> >> >>
>> >> >> I am using & instead of +, and I don't have the
>> >> >> ,'location=no,toolbar=no'
>> >> >>
>> >> >> Other than that I am not seeing much different.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> >> >> news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
>> >> >> > Hi Bruce,
>> >> >> > I did the same thing but getting the following error :
>> >> >> >
>> >> >> > "Internet explorer cannot download.Unspecified error".
>> >> >> >
>> >> >> > The only difference is that we have a popup window that opens a
>> >> >> > server
>> >> >> > report in PDF format using URL access and within this report
>> >> >> > there
>> >> >> > are
>> >> >> > hyperlinks to webpages.On clicking the hyperlinks from within the
>> >> >> > report
>> >> >> > we
>> >> >> > get the following error :
>> >> >> >
>> >> >> > "Internet explorer cannot download.Unspecified error".
>> >> >> >
>> >> >> > we have used javascript in the jump to URL expression:
>> >> >> >
>> >> >> > ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid="
>> >> >> > +
>> >> >> > Trim(Cstr(Fields!ProjectUID.Value)) +
>> >> >> > "','_blank','location=no,toolbar=no'))"
>> >> >> >
>> >> >> > Can you guide me on this?
>> >> >> >
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> Good. Glad that worked for you.
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
>> >> >> >> > Yes I am using Jump To URL. I just read one of your previous
>> >> >> >> > posts
>> >> >> >> > Bruce
>> >> >> >> > and
>> >> >> >> > I used:
>> >> >> >> >
>> >> >> >> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
>> >> >> >> >
>> >> >> >> > This solved my problem. I still don't know why the expression
>> >> >> >> > by
>> >> >> >> > itself
>> >> >> >> > doesn't produce a hyperlink but this appears to trick SSRS
>> >> >> >> > into
>> >> >> >> > rendering
>> >> >> >> > it.
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >> >
>> >> >> >> >> Are you using jump to URL? I use an expression all the time
>> >> >> >> >> in
>> >> >> >> >> there
>> >> >> >> >> but
>> >> >> >> >> not
>> >> >> >> >> with Sharepoint.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> Bruce Loehle-Conger
>> >> >> >> >> MVP SQL Server Reporting Services
>> >> >> >> >>
>> >> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote
>> >> >> >> >> in
>> >> >> >> >> message
>> >> >> >> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
>> >> >> >> >> > We are using SSRS SP2 in SharePoint integrated mode and
>> >> >> >> >> > when I
>> >> >> >> >> > use
>> >> >> >> >> > an
>> >> >> >> >> > expression that results in a URL that I use for a hyperlink
>> >> >> >> >> > in
>> >> >> >> >> > a
>> >> >> >> >> > report,
>> >> >> >> >> > it
>> >> >> >> >> > works in Visual Studio but not in report viewer. If I use
>> >> >> >> >> > a
>> >> >> >> >> > static
>> >> >> >> >> > URL
>> >> >> >> >> > it
>> >> >> >> >> > works fine.
>> >> >> >> >> >
>> >> >> >> >> > Upon inspection of the source that is returned by SSRS when
>> >> >> >> >> > using
>> >> >> >> >> > an
>> >> >> >> >> > expression for the URL, it doen's even add the <a href=>
>> >> >> >> >> > tag
>> >> >> >> >> > to
>> >> >> >> >> > the
>> >> >> >> >> > resulting
>> >> >> >> >> > HTML. It is as if SSRS won't process an expression for a
>> >> >> >> >> > hyperlink
>> >> >> >> >> > but
>> >> >> >> >> > Visual Studio's preview will. How am I supposed to have
>> >> >> >> >> > dynamic
>> >> >> >> >> > hyperlinks
>> >> >> >> >> > in my reports? Any ideas?
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Yes, your understanding is right. The issue is having the link work from
a PDF. Do you know what kind of security changes are required?I have turned
the setting on to allow popups and i have also added the site as a trusted
site in the IE settings.I also looked at the adobe reader settings under
edit-->preferences-->javascript the enable Acrobat javascript checkbox is
checked.Kindly advice.
"Bruce L-C [MVP]" wrote:
> OK, now I understand. The issue is not getting the link to work from normal
> html report. That is working for you. The issue is having the link work from
> a PDF. I tried some tests from PDF and Excel. Excel usually had no problem.
> PDF would flash and nothing would come up.
> I also tried the link without using the javascript command. That would be
> erratic, sometimes working sometimes not. I think some sort of security
> setting is getting in the way.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> news:3A861D11-30D4-4F6B-9849-19F17A328FEE@.microsoft.com...
> > using "javascript:void(window.open('http://www.google.com/','_blank'))" in
> > jump to URL works fine when i deploy it on report server but i keep
> > getting
> > "Internet explorer cannot download.Unspecified error" when we render the
> > report in pdf format from our web app in a popup using URL access method.
> >
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I'm confused. Are you saying that when you try
> >>
> >> ="javascript:void(window.open('http://www.google.com/','_blank'))"
> >>
> >> You get "Internet explorer cannot download.Unspecified error"?
> >>
> >> If you are trying this from the development environment it won't work.
> >> You
> >> have to deploy to test jump to URL.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> >> news:566219F0-0B28-4CD3-AC82-F2E5F7A25599@.microsoft.com...
> >> >I tried just now.It is still saying :
> >> > "Internet explorer cannot download.Unspecified error".
> >> >
> >> > I'm using IE 7.0 on my dev machine.It works fine when the hyperlink
> >> > within
> >> > the report is invoked directly from report viewer on
> >> > http://hostname/reportserver but hyperlink invokation fails when we
> >> > make
> >> > URL
> >> > request to the pdf via
> >> > http://domainName/ReportServer?rs:format=PDF&rs:report=/MyReports/MyReportName
> >> >
> >> > Kindly advice.
> >> >
> >> >
> >> >
> >> > get the following error "Bruce L-C [MVP]" wrote:
> >> >
> >> >> SP1 and above was in regards to 2000. Any version of 2005 will work.
> >> >> Have
> >> >> you tried putting in the google example just for a test?
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> >> >> news:AA97AFAD-763D-4FF5-8E06-EBC5C0454DB6@.microsoft.com...
> >> >> > Thanks Bruce.I tried with & and the problem still persists. We are
> >> >> > using
> >> >> > Microsoft SQL Server 2005 Reporting Services Version 9.00.3042.00.
> >> >> > Does
> >> >> > the
> >> >> > version really matter in this case.I read some where that we need
> >> >> > need
> >> >> > SP1
> >> >> > and above.Kindly advice.
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> Here are two working ones for me:
> >> >> >> ="javascript:void(window.open('http://www.google.com/','_blank'))"
> >> >> >>
> >> >> >> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> >> >> "?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
> >> >> >>
> >> >> >> I am using & instead of +, and I don't have the
> >> >> >> ,'location=no,toolbar=no'
> >> >> >>
> >> >> >> Other than that I am not seeing much different.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
> >> >> >> news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
> >> >> >> > Hi Bruce,
> >> >> >> > I did the same thing but getting the following error :
> >> >> >> >
> >> >> >> > "Internet explorer cannot download.Unspecified error".
> >> >> >> >
> >> >> >> > The only difference is that we have a popup window that opens a
> >> >> >> > server
> >> >> >> > report in PDF format using URL access and within this report
> >> >> >> > there
> >> >> >> > are
> >> >> >> > hyperlinks to webpages.On clicking the hyperlinks from within the
> >> >> >> > report
> >> >> >> > we
> >> >> >> > get the following error :
> >> >> >> >
> >> >> >> > "Internet explorer cannot download.Unspecified error".
> >> >> >> >
> >> >> >> > we have used javascript in the jump to URL expression:
> >> >> >> >
> >> >> >> > ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid="
> >> >> >> > +
> >> >> >> > Trim(Cstr(Fields!ProjectUID.Value)) +
> >> >> >> > "','_blank','location=no,toolbar=no'))"
> >> >> >> >
> >> >> >> > Can you guide me on this?
> >> >> >> >
> >> >> >> >
> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >
> >> >> >> >> Good. Glad that worked for you.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >>
> >> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
> >> >> >> >> > Yes I am using Jump To URL. I just read one of your previous
> >> >> >> >> > posts
> >> >> >> >> > Bruce
> >> >> >> >> > and
> >> >> >> >> > I used:
> >> >> >> >> >
> >> >> >> >> > ="javascript:void(window.open('" & [My URL Expression] & "'))"
> >> >> >> >> >
> >> >> >> >> > This solved my problem. I still don't know why the expression
> >> >> >> >> > by
> >> >> >> >> > itself
> >> >> >> >> > doesn't produce a hyperlink but this appears to trick SSRS
> >> >> >> >> > into
> >> >> >> >> > rendering
> >> >> >> >> > it.
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >> >
> >> >> >> >> >> Are you using jump to URL? I use an expression all the time
> >> >> >> >> >> in
> >> >> >> >> >> there
> >> >> >> >> >> but
> >> >> >> >> >> not
> >> >> >> >> >> with Sharepoint.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >> >>
> >> >> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote
> >> >> >> >> >> in
> >> >> >> >> >> message
> >> >> >> >> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
> >> >> >> >> >> > We are using SSRS SP2 in SharePoint integrated mode and
> >> >> >> >> >> > when I
> >> >> >> >> >> > use
> >> >> >> >> >> > an
> >> >> >> >> >> > expression that results in a URL that I use for a hyperlink
> >> >> >> >> >> > in
> >> >> >> >> >> > a
> >> >> >> >> >> > report,
> >> >> >> >> >> > it
> >> >> >> >> >> > works in Visual Studio but not in report viewer. If I use
> >> >> >> >> >> > a
> >> >> >> >> >> > static
> >> >> >> >> >> > URL
> >> >> >> >> >> > it
> >> >> >> >> >> > works fine.
> >> >> >> >> >> >
> >> >> >> >> >> > Upon inspection of the source that is returned by SSRS when
> >> >> >> >> >> > using
> >> >> >> >> >> > an
> >> >> >> >> >> > expression for the URL, it doen's even add the <a href=>
> >> >> >> >> >> > tag
> >> >> >> >> >> > to
> >> >> >> >> >> > the
> >> >> >> >> >> > resulting
> >> >> >> >> >> > HTML. It is as if SSRS won't process an expression for a
> >> >> >> >> >> > hyperlink
> >> >> >> >> >> > but
> >> >> >> >> >> > Visual Studio's preview will. How am I supposed to have
> >> >> >> >> >> > dynamic
> >> >> >> >> >> > hyperlinks
> >> >> >> >> >> > in my reports? Any ideas?
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I suggest reposting with a new subject. At first it seemed like your issue
was creating the expression. I suggest posting with the subject: Hyperlink
not working when rendered in PDF
Also, post it here and at the web forums.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
news:7A3ECB30-CEDD-4EBB-B429-E42B942DE4DA@.microsoft.com...
> Yes, your understanding is right. The issue is having the link work from
> a PDF. Do you know what kind of security changes are required?I have
> turned
> the setting on to allow popups and i have also added the site as a trusted
> site in the IE settings.I also looked at the adobe reader settings under
> edit-->preferences-->javascript the enable Acrobat javascript checkbox is
> checked.Kindly advice.
>
> "Bruce L-C [MVP]" wrote:
>> OK, now I understand. The issue is not getting the link to work from
>> normal
>> html report. That is working for you. The issue is having the link work
>> from
>> a PDF. I tried some tests from PDF and Excel. Excel usually had no
>> problem.
>> PDF would flash and nothing would come up.
>> I also tried the link without using the javascript command. That would be
>> erratic, sometimes working sometimes not. I think some sort of security
>> setting is getting in the way.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> news:3A861D11-30D4-4F6B-9849-19F17A328FEE@.microsoft.com...
>> > using "javascript:void(window.open('http://www.google.com/','_blank'))"
>> > in
>> > jump to URL works fine when i deploy it on report server but i keep
>> > getting
>> > "Internet explorer cannot download.Unspecified error" when we render
>> > the
>> > report in pdf format from our web app in a popup using URL access
>> > method.
>> >
>> >
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> I'm confused. Are you saying that when you try
>> >>
>> >> ="javascript:void(window.open('http://www.google.com/','_blank'))"
>> >>
>> >> You get "Internet explorer cannot download.Unspecified error"?
>> >>
>> >> If you are trying this from the development environment it won't work.
>> >> You
>> >> have to deploy to test jump to URL.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> >> news:566219F0-0B28-4CD3-AC82-F2E5F7A25599@.microsoft.com...
>> >> >I tried just now.It is still saying :
>> >> > "Internet explorer cannot download.Unspecified error".
>> >> >
>> >> > I'm using IE 7.0 on my dev machine.It works fine when the hyperlink
>> >> > within
>> >> > the report is invoked directly from report viewer on
>> >> > http://hostname/reportserver but hyperlink invokation fails when we
>> >> > make
>> >> > URL
>> >> > request to the pdf via
>> >> > http://domainName/ReportServer?rs:format=PDF&rs:report=/MyReports/MyReportName
>> >> >
>> >> > Kindly advice.
>> >> >
>> >> >
>> >> >
>> >> > get the following error "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> SP1 and above was in regards to 2000. Any version of 2005 will
>> >> >> work.
>> >> >> Have
>> >> >> you tried putting in the google example just for a test?
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in message
>> >> >> news:AA97AFAD-763D-4FF5-8E06-EBC5C0454DB6@.microsoft.com...
>> >> >> > Thanks Bruce.I tried with & and the problem still persists. We
>> >> >> > are
>> >> >> > using
>> >> >> > Microsoft SQL Server 2005 Reporting Services Version
>> >> >> > 9.00.3042.00.
>> >> >> > Does
>> >> >> > the
>> >> >> > version really matter in this case.I read some where that we need
>> >> >> > need
>> >> >> > SP1
>> >> >> > and above.Kindly advice.
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> Here are two working ones for me:
>> >> >> >> ="javascript:void(window.open('http://www.google.com/','_blank'))"
>> >> >> >>
>> >> >> >> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> >> >> "?/IT/HowTo+switch+between+InTouch.doc','_blank'))"
>> >> >> >>
>> >> >> >> I am using & instead of +, and I don't have the
>> >> >> >> ,'location=no,toolbar=no'
>> >> >> >>
>> >> >> >> Other than that I am not seeing much different.
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >>
>> >> >> >> "Prabhakar" <Prabhakar@.discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:379EBFF5-7C01-4BE0-8856-A104545268D9@.microsoft.com...
>> >> >> >> > Hi Bruce,
>> >> >> >> > I did the same thing but getting the following error :
>> >> >> >> >
>> >> >> >> > "Internet explorer cannot download.Unspecified error".
>> >> >> >> >
>> >> >> >> > The only difference is that we have a popup window that opens
>> >> >> >> > a
>> >> >> >> > server
>> >> >> >> > report in PDF format using URL access and within this report
>> >> >> >> > there
>> >> >> >> > are
>> >> >> >> > hyperlinks to webpages.On clicking the hyperlinks from within
>> >> >> >> > the
>> >> >> >> > report
>> >> >> >> > we
>> >> >> >> > get the following error :
>> >> >> >> >
>> >> >> >> > "Internet explorer cannot download.Unspecified error".
>> >> >> >> >
>> >> >> >> > we have used javascript in the jump to URL expression:
>> >> >> >> >
>> >> >> >> > ="javascript:void(window.open('http://hostname/p/proj/project.aspx?uid="
>> >> >> >> > +
>> >> >> >> > Trim(Cstr(Fields!ProjectUID.Value)) +
>> >> >> >> > "','_blank','location=no,toolbar=no'))"
>> >> >> >> >
>> >> >> >> > Can you guide me on this?
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >> >
>> >> >> >> >> Good. Glad that worked for you.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> Bruce Loehle-Conger
>> >> >> >> >> MVP SQL Server Reporting Services
>> >> >> >> >>
>> >> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com> wrote
>> >> >> >> >> in
>> >> >> >> >> message
>> >> >> >> >> news:1D8F8D09-9998-4593-B8DD-AADDA5FE8612@.microsoft.com...
>> >> >> >> >> > Yes I am using Jump To URL. I just read one of your
>> >> >> >> >> > previous
>> >> >> >> >> > posts
>> >> >> >> >> > Bruce
>> >> >> >> >> > and
>> >> >> >> >> > I used:
>> >> >> >> >> >
>> >> >> >> >> > ="javascript:void(window.open('" & [My URL Expression] &
>> >> >> >> >> > "'))"
>> >> >> >> >> >
>> >> >> >> >> > This solved my problem. I still don't know why the
>> >> >> >> >> > expression
>> >> >> >> >> > by
>> >> >> >> >> > itself
>> >> >> >> >> > doesn't produce a hyperlink but this appears to trick SSRS
>> >> >> >> >> > into
>> >> >> >> >> > rendering
>> >> >> >> >> > it.
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >> >> >
>> >> >> >> >> >> Are you using jump to URL? I use an expression all the
>> >> >> >> >> >> time
>> >> >> >> >> >> in
>> >> >> >> >> >> there
>> >> >> >> >> >> but
>> >> >> >> >> >> not
>> >> >> >> >> >> with Sharepoint.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >> Bruce Loehle-Conger
>> >> >> >> >> >> MVP SQL Server Reporting Services
>> >> >> >> >> >>
>> >> >> >> >> >> "Andrew Stout" <AndrewStout@.discussions.microsoft.com>
>> >> >> >> >> >> wrote
>> >> >> >> >> >> in
>> >> >> >> >> >> message
>> >> >> >> >> >> news:9A7DAF69-E035-454B-8D78-0D877932E052@.microsoft.com...
>> >> >> >> >> >> > We are using SSRS SP2 in SharePoint integrated mode and
>> >> >> >> >> >> > when I
>> >> >> >> >> >> > use
>> >> >> >> >> >> > an
>> >> >> >> >> >> > expression that results in a URL that I use for a
>> >> >> >> >> >> > hyperlink
>> >> >> >> >> >> > in
>> >> >> >> >> >> > a
>> >> >> >> >> >> > report,
>> >> >> >> >> >> > it
>> >> >> >> >> >> > works in Visual Studio but not in report viewer. If I
>> >> >> >> >> >> > use
>> >> >> >> >> >> > a
>> >> >> >> >> >> > static
>> >> >> >> >> >> > URL
>> >> >> >> >> >> > it
>> >> >> >> >> >> > works fine.
>> >> >> >> >> >> >
>> >> >> >> >> >> > Upon inspection of the source that is returned by SSRS
>> >> >> >> >> >> > when
>> >> >> >> >> >> > using
>> >> >> >> >> >> > an
>> >> >> >> >> >> > expression for the URL, it doen's even add the <a href=>
>> >> >> >> >> >> > tag
>> >> >> >> >> >> > to
>> >> >> >> >> >> > the
>> >> >> >> >> >> > resulting
>> >> >> >> >> >> > HTML. It is as if SSRS won't process an expression for
>> >> >> >> >> >> > a
>> >> >> >> >> >> > hyperlink
>> >> >> >> >> >> > but
>> >> >> >> >> >> > Visual Studio's preview will. How am I supposed to have
>> >> >> >> >> >> > dynamic
>> >> >> >> >> >> > hyperlinks
>> >> >> >> >> >> > in my reports? Any ideas?
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>