Showing posts with label url. Show all posts
Showing posts with label url. Show all posts

Tuesday, March 27, 2012

Extra Browser window when exporting?

Hello,
I'm using the HTML Viewer and URL access to render my reports. When I change the format (for example to excel) on the HTML Viewer, and click the "export" link beside the drop down. A new browser window pops up and a save box prompting me to specify the location of where to save. After I choose the save destination, download the new formated report, and close the save box, the newly opened browser window remains open.

Is there any way to automatically close that browser window? or maybe even not show that browser window at all?

Thanks in AdvanceUnfortunatly there is no way to get rid of this extra box.|||Oh Well... Thanks for the response

Extra Browser window when exporting?

Hello,
I'm using the HTML Viewer and URL access to render my reports. When I change the format (for example to excel) on the HTML Viewer, and click the "export" link beside the drop down. A new browser window pops up and a save box prompting me to specify the location of where to save. After I choose the save destination, download the new formated report, and close the save box, the newly opened browser window remains open.

Is there any way to automatically close that browser window? or maybe even not show that browser window at all?

Thanks in AdvanceUnfortunatly there is no way to get rid of this extra box.|||Oh Well... Thanks for the response

Monday, March 26, 2012

External Images (URL Based) don't display on deployed reports

Hello,
I have a RS 2005 report which uses a report parameter as the source for an
image external image. When in report designer, everything works fine. When
deployed, the image shows as red x.
I am not using unattended credentials since the image is accessible without
credentials. I even tried images from microsoft.com and cnn.com
Any help would be appreciated.
-PedroHi Pedro,
Probabily the image directory is not proper. Just right click on the Red x
or view source to see where the image points to and check the directory for
your image. Better to include it in your project so that the link is not lost.
Amarnath
"Pedro" wrote:
> Hello,
> I have a RS 2005 report which uses a report parameter as the source for an
> image external image. When in report designer, everything works fine. When
> deployed, the image shows as red x.
> I am not using unattended credentials since the image is accessible without
> credentials. I even tried images from microsoft.com and cnn.com
> Any help would be appreciated.
> -Pedro
>
>

External Images - 404 Not Found and the red X image

Hello,
I have a report that is attempting to go out and grab images for certain
items off of a website. The URL is basically a guess and when it is
incorrect (404 File Not Found) RS returns an image of a red X. Is there an
expression I can use to hide the visibilty of the red X if one should appear?
I havn't been able to figure out how to do this.
Thanks!
Paulchecking the binary stream return value and if there is nothing then hide
the column displaying the image
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:616E1484-1B3D-4393-8974-F7C616A6051A@.microsoft.com...
> Hello,
> I have a report that is attempting to go out and grab images for certain
> items off of a website. The URL is basically a guess and when it is
> incorrect (404 File Not Found) RS returns an image of a red X. Is there
> an
> expression I can use to hide the visibilty of the red X if one should
> appear?
> I havn't been able to figure out how to do this.
> Thanks!
> Paul|||Ok, thanks for the post. How exactly do I go about checking the binary
stream return value in RS?
"Vaibhav" wrote:
> checking the binary stream return value and if there is nothing then hide
> the column displaying the image
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:616E1484-1B3D-4393-8974-F7C616A6051A@.microsoft.com...
> > Hello,
> >
> > I have a report that is attempting to go out and grab images for certain
> > items off of a website. The URL is basically a guess and when it is
> > incorrect (404 File Not Found) RS returns an image of a red X. Is there
> > an
> > expression I can use to hide the visibilty of the red X if one should
> > appear?
> > I havn't been able to figure out how to do this.
> >
> > Thanks!
> > Paul
>
>

External Image URL doesn't work !

Hi
I have downloaded SP1, and am trying to display an image by URL.
I have followed the steps described in the SP1Readme. However i am still unable to view my image in the "Preview" mode in report designer and also through report server. When i right click to view the source of my webpage, the image src is empty like this <img class="R1" src="http://pics.10026.com/?src=">.
Any idea, what can be wrong? This is what i did:
1) set in designer Source=External
2) set Value=http://localhost/Webmodule/test.img
3) image immediately showed up
4) Go to "Preview" mode in designer, image shows a red cross
5) ran rsconfig -e -m mycomputer -s mycomputer -u user1 -p password
6) deploy .rdl onto report server
7) image still shows a red cross
8) when view source, it shows <img class="R1" src="http://pics.10026.com/?src=">
I have set my datasource credentials to "credentials stored securely on report server" and provided the username and password in the report manager.
chiara.IMG is an unsupported image format. Supported are bmp, jpeg, gif, png, and
x-png.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chiara" <Chiara@.discussions.microsoft.com> wrote in message
news:40B9C60C-320F-47B9-857F-D7DFFD4EE4A6@.microsoft.com...
> Hi
> I have downloaded SP1, and am trying to display an image by URL.
> I have followed the steps described in the SP1Readme. However i am still
unable to view my image in the "Preview" mode in report designer and also
through report server. When i right click to view the source of my webpage,
the image src is empty like this <img class="R1" src="http://pics.10026.com/?src=">.
> Any idea, what can be wrong? This is what i did:
> 1) set in designer Source=External
> 2) set Value=http://localhost/Webmodule/test.img
> 3) image immediately showed up
> 4) Go to "Preview" mode in designer, image shows a red cross
> 5) ran rsconfig -e -m mycomputer -s mycomputer -u user1 -p password
> 6) deploy .rdl onto report server
> 7) image still shows a red cross
> 8) when view source, it shows <img class="R1" src="http://pics.10026.com/?src=">
> I have set my datasource credentials to "credentials stored securely on
report server" and provided the username and password in the report manager.
>
> chiara
>
>sql

Friday, March 9, 2012

expression question

Hi
Dose "Expression" can write any syntax such as CASE... WHEN... Structure?
I have a serial code such as B1, B2, B3.
When B1, the "jump to url" to http://b1.aspx. B2 the http://b2.aspx
I wirte this use IIF now but feel this way dosen't make sense.
So is any other way can instead of IIF?
Thanks for help! (I use RS 2005)
Anginot sure if you can use the case statement, in theory I don't see why
not. I also was getting irritated writing lengthy or having the giant
iif statements, so instead I now create methods in the Code tab and
simply pass the value into the method and return the result.
seems neater this way|||Try using SWITCH instead of IIF.
The syntax is
SWITCH(test1,option1,test2,option2,...)
compared to
IIF(test1,option1,IIF(test2,option2,IIF(...)))
It reads the comma separated sequence in pairs and executes the first
one that has a test = true.

Wednesday, March 7, 2012

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

Sunday, February 19, 2012

Exporting to Excel Problems (URL Access)

Hello,
I'm using SQL Server 2005 Reporting Services. I'm having an issues when exporting to Excel. I'm using URL Access to generate the report and display it in a browser window. I then choose Excel and click the Export link. Doing this opens a temporary browser window and then a dialog that asks if I want to save the report or open it. If I choose to open it, the report opens in Excel without problem. The problem is that the temporary browser window doesn't go away (close) automatically like it should. What makes this a little more strange is that this behavior only seem to occur on a Windows XP computer. If I run the report from a Windows 2000 or Windows Server 2003 computer, the temporary browser windows closes automatically (and the report is exported to Excel and opened).

Has anyone experienced this same issue?

Does anyone know how to "fix" this issue so that exporting to open right away always closes the temporary browser window?

Thanks.

I've noticed that issue without using URL access. My users love exporting to Excel, and it bugs me when I test exporting, and have windows open all over the place. I'd like to know what the fix is as well. I imagine it is just an IE thing, and there's nothing we can do about it.|||

Did you fine an answer for this one. I am experiencing the same issue.

Thanks for help in advance.

Mehul