Extra Page in Adobe Export

Using SRS SP2 and Adobe 7.0.2
When my report renders in the preview pane it it limited to one page but
when exported to Adobe it prints an extra page. The report has Page
Header/Body/Page Footer sections.
Is this a bug or am I missing something in the config?
ThanksI have the same problem. Would like to know if there is a solution.
"Mike Harbinger" wrote:
> Using SRS SP2 and Adobe 7.0.2
> When my report renders in the preview pane it it limited to one page but
> when exported to Adobe it prints an extra page. The report has Page
> Header/Body/Page Footer sections.
> Is this a bug or am I missing something in the config?
> Thanks
>
>|||make sure there is no extra space after the table and chart
"Mike Harbinger" wrote:
> Using SRS SP2 and Adobe 7.0.2
> When my report renders in the preview pane it it limited to one page but
> when exported to Adobe it prints an extra page. The report has Page
> Header/Body/Page Footer sections.
> Is this a bug or am I missing something in the config?
> Thanks
>
>|||That was it! I had moved a field in from the right margin and after
tightening it up the extra page was gone.
Many thanks!
"RP" <RP@.discussions.microsoft.com> wrote in message
news:94E1BCC1-F540-46DE-95F7-56F242097113@.microsoft.com...
> make sure there is no extra space after the table and chart
> "Mike Harbinger" wrote:
>> Using SRS SP2 and Adobe 7.0.2
>> When my report renders in the preview pane it it limited to one page but
>> when exported to Adobe it prints an extra page. The report has Page
>> Header/Body/Page Footer sections.
>> Is this a bug or am I missing something in the config?
>> Thanks
>>

Extra columns in Excel with SP2

I would like to upgrade to Reporting Services service pack 2 so that I can
specify report colours and specify to move the header into Excel's header.
However when we upgrade to Service Pack 2 it causes extra totals columns to
appear at the end of the months in the generated reports. These columns
could possibly acceptable if they were titled as Total however they are not.
Can anybody make any suggestions in how to generate the report in excel
without the additional columns appearing in the excel output? Many thanks.Does anybody have any ideas about how to do this - any guesses even would be
appreciated. Thanks
"Nicola Jones" wrote:
> I would like to upgrade to Reporting Services service pack 2 so that I can
> specify report colours and specify to move the header into Excel's header.
> However when we upgrade to Service Pack 2 it causes extra totals columns to
> appear at the end of the months in the generated reports. These columns
> could possibly acceptable if they were titled as Total however they are not.
> Can anybody make any suggestions in how to generate the report in excel
> without the additional columns appearing in the excel output? Many thanks.

External Images on Network Share Driving Me Mad

Hi,
Using RS 2000 SP2, I'm trying to access external images that a stored
on another computer via a network share. However, I get nothing but
red x's in my report. I understand that in order for this to work, I
need to setup the UnattendedExecutionAccount. Here's the rsconfig call
I've used:
rsconfig -e -u DOMAIN\user -p password -a windows
However, the pictures still don't show. I've logged on as the user in
question and confirmed the user can see the folder and open the
images. I've also double checked that I have the correct case for the
user and the password. The image source is in the format:
file://\\Computer\Data\Images\xxxx.jpg
I've also tried:
\\Computer\Data\Images\xxxx.jpg
If I copy the images to a local drive everything works.
Is there a problem using UNC paths? Maybe the developer install has
trouble accessing shared network paths? This is driving me nuts, can
anybody shed any light?
Thanks,
CamelOn Mar 3, 11:20 am, Daniel wrote:
> Mine works with the following:
> file:\\server\share folder\xxxxxx.gif
> EggHeadCafe.com - .NET Developer Portal of Choicehttp://www.eggheadcafe.com
Unfortunately I was not able to resolve this. I suspect that it is a
permissions issue - and that it has something to do with the
UnattendedExecutionAccount not working the way I expect it to.
Regardless, I've given up and used an IIS virtual folder instead. At
least there I can control what credentials are used to access the
share.
Thanks,
Camel

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

Express SP2 install error

Hi, try to install (not an upgrade) SQLExpressSP2 on WinXPSP2 from SQLEXPR32.exe package.

.NET version 2.0 is already installed however get error below before last step of Server setup ( Excerpt from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_Core(Local) ):

</- START OF Excerpt >

<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='1603' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/2/14 16:58:23, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/2/14 16:58:23
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3416

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/2/14 16:58:23
Message pump returning: 1603
</- END OF Excerpt >

Cud u please advise workaround?

cheers,

Fred

N.B.

Also have tried to register my installation of SQL Express SP2 but the registration web page has a bug and

does not enable me to register at https://profile.microsoft.com/ProductActivation/ProductActivation.aspx?lcid=1033&WizId=0569136c-78c8-454b-bf27-cb7d7863de63

This message appears in "Red' even when legitimate email-address was entered:

"*Required: E-Mail Address"

cheers,

Fred

Tyodotnet wrote:

Hi, try to install (not an upgrade) SQLExpressSP2 on WinXPSP2 from SQLEXPR32.exe package.

.NET version 2.0 is already installed however get error below before last step of Server setup ( Excerpt from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_Core(Local) ):

</- START OF Excerpt >

<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='1603' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/2/14 16:58:23, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/2/14 16:58:23
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3416

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/2/14 16:58:23
Message pump returning: 1603
</- END OF Excerpt >

Cud u please advise workaround?

cheers,

Fred

|||

Not finding much on this one, I'm going to move this to the setup forum so the experts can take a look.

Mike

|||

Hi Mike,

Thanks for your assistance.

Meanwhile I have found out the problem i.e:
1. Instead of running SQLEXPR32.EXE I have extracted the contents
into a new folder using the commandline SQLEXPR32.EXE -X

2. I have created an autostart CD from the extracted data.

3. Run the CD, autorun will open splash.hta automatically.
This installation menu will appear:

Prepare
Review hardware and software requirements
Read the release notes
Install
Run the SQL Server Installation Wizard
Run the SQL Native Client Installation Wizard
Other Information
Browse this CD
Visit the SQL Server website
Read the SQL Server license agreement
4. Run the SQL Native Client Installation Wizard, with success,
installation closes all screens.

5. Run CD again and run the SQL Server Installation Wizard
got into error: current user (the Administrator!)
has not enough access rights to write in "C:\Program Files\Microsoft SQL Server"

6. Check and change access control with Explorer "C:\Program Files\Microsoft SQL Server"
Indeed it was totally unwritable by Admin!

7. Run CD again and the SQL Server Installation Wizard is running flawless.
All steps can be finished.

cheers,
Fred