Opening SQL Server Management Studio for Query only

I finally noticed today that if I open a SQL script file on 2005 installation, it opens the query window ONLY in SQL Server Management Studio. Otherwise, no object explorer, ect.

Since MS will not provide independent Query Analyzer as in SQL 2000 and earlier - that I provide to power end users, I want to be able to give them call to "SqlWb.exe" to open only with query window.

I checked program opions (SqlWb.exe /?) with no answer.

Does anyone know how to open SQL Server Management Studio for Query window only?

This is a way we can give our power clients the "Query Analyzer" type toolset for SQL 2005 without them using full SQL 2005 Management Studio.

Create an empty SQL script file on your "H", etc. drive. Create new SHORTCUT on desktop using below string (edit if your path for EXE or SQL file is different)

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" H:\Empty_SQL.sql -nosplash

Opening report in new window

I have a problem when opening a sql 2000 report in a new window. As
soon as the the report is opened, asp.net post-backs will fail.
This is what I do:
window.open('http//:[ip address]/reportserver?/ReportFolder/
ReportName')
As soon as I do that, asp.net post-backs on the opener will 'do
nothing'.
strange thing is that if I open the report using the name of the
server rather than ip address, it works fine
window.open('http//:[server name]/reportserver?/ReportFolder/
ReportName')
it also works fine on a development machine using 'localhost'.
The behavior I describe happens when the application is deployed to a
production server. Our customer must use the ip address of the server
for various reasons.
I've tried using a relative url ('../../reportserver?...') and i get
the same behaviour.
Any ideas?Have you tried using Globals!ReportServerUrl
"ruben@.lindenservices.com" wrote:
> I have a problem when opening a sql 2000 report in a new window. As
> soon as the the report is opened, asp.net post-backs will fail.
> This is what I do:
> window.open('http//:[ip address]/reportserver?/ReportFolder/
> ReportName')
> As soon as I do that, asp.net post-backs on the opener will 'do
> nothing'.
> strange thing is that if I open the report using the name of the
> server rather than ip address, it works fine
> window.open('http//:[server name]/reportserver?/ReportFolder/
> ReportName')
> it also works fine on a development machine using 'localhost'.
> The behavior I describe happens when the application is deployed to a
> production server. Our customer must use the ip address of the server
> for various reasons.
> I've tried using a relative url ('../../reportserver?...') and i get
> the same behaviour.
> Any ideas?
>sql

Opening hyperlink Url in new window

Hello,

I have areport with a text box. The text box is hyperlinked to another report url. The report opens in a new page when previewed with RS 2005 but when deployed the report opens in teh same page from where it is referenced.

How can I set a property with the texbox to always open in a new page the hyperlinked report.

Thanks in advance

'Kiran.

I'm not going to be any help... I have the same question. The report itself uses XML to generate not html so it is not a matter of setting target = '_blank'. That's about as far as I've gotten. Any help with this would be appreciated by me as well.

Thanks

Opening a URL in reporting services 2005 opens whatever IE window

How do I get reporting services 2005 to open a new IE window when touching a URL. Otherwise it grabs whatever one is open (not any order) which writes over what I was viewing. This is extremely frustrating. Our company uses LOTUS notes sametime as a netmeeting software which uses IE and it keeps choosing that window and "knocking" me out of the meeting. What can I do?

One thing that might work is unchecking the "Reuse windows for launching shortcuts" option under "Browsing" section located on the "Advanced" tab of IE's Internet Options. The down-side to this fix is that it only affects your user profile. This fix would have to be performed for each user's profile. I'll play around with RS and see if I can't trick it to force a new window.

Sincerely,

Micheal

Opening a PDF report without the OPEN/Save Dialog

Is there a way to render the PDF report in the same broswer window you just called it from without the Open/Save dialog box coming up. The report is being call directly by URL parameters for PDF formatNo there is not. We set the Content-Type to attachment which causes IE to prompt for this.|||

This is quite easy with custom programming, I've made a new webapp and gave the aspnet-user full access to reporting services, maybe you could add a cutom file to the Reports-Webapp..

I've default.aspx:

<%@. Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%
Dim pdfloader As New PDFLoader(Request, Response)
pdfloader.show()
%>

and default.aspx.vb:

Public Class PDFLoader

Private request As System.Web.HttpRequest
Private response As System.Web.HttpResponse

Public Sub New(ByVal request As System.Web.HttpRequest, ByVal response As System.Web.HttpResponse)
Me.request = request
Me.response = response
End Sub

Public Sub show()
Dim rsExec As New ReportExecutionService
rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials

' Prepare Render arguments
Dim historyID As String = Nothing
Dim deviceInfo As String = Nothing
Dim format As String = "PDF"
Dim showHide As String = Nothing
Dim results() As [Byte]
Dim warnings As RepExServ.Warning() = Nothing
Dim streamIDs As String() = Nothing
Dim encoding As String = String.Empty
Dim mimeType As String = String.Empty
Dim reportName As String

Dim zaehl As Integer = -1
Dim names(), name, values(), value As String
Dim ParameterValues() As RepExServ.ParameterValue
ParameterValues = New RepExServ.ParameterValue(0) {}

names = request.QueryString.AllKeys
For Each name In names
values = request.QueryString.GetValues(name)
For Each value In values
If (name = "") Then
reportName = value
Else
zaehl = zaehl + 1
If zaehl >= ParameterValues.Length Then
ReDim Preserve ParameterValues(zaehl)
End If
Dim ParameterValue As RepExServ.ParameterValue = New RepExServ.ParameterValue
ParameterValue.Name = name
ParameterValue.Value = value
ParameterValue.Label = Nothing
ParameterValues(zaehl) = ParameterValue
End If

Next

Next

Dim ei As ExecutionInfo = rsExec.LoadReport(reportName, historyID)
If zaehl > -1 Then
rsExec.SetExecutionParameters(ParameterValues, "")
End If

'Exectute the report and send it to the Client
results = rsExec.Render(format, deviceInfo, "", encoding, mimeType, warnings, streamIDs)
response.ContentType = "application/pdf"
response.BinaryWrite(results)

End Sub
End Class

Partial Class _Default
Inherits System.Web.UI.Page

End Class

This works just similar to the usual URL-Access method, but you can't specify any "rs:" - Parameters.. sampe call:

http://yourserver/YourWebApp/default.aspx?/RepPath/Repname&Parameter1=something

okay, I forgot something: you have to add WebReferences to you webapp:
http://msdn2.microsoft.com/en-us/library/ms154699(SQL.90).aspx

|||Yes, you can always add your own web app to do this. I was stating that RS does not allow you to change this behavior using either URL access or Report Manager|||You can do this with the ReportViewer control, using the ExportContentDisposition property.|||

I also would like to open my report in PDF format without opening the Open/Save Dialog box.

I read that the ExportContentDisposition is indeed the property to use.

Is there a way to put this property in the URL when calling the report? Or do I have to use the ReportViewer Control? I am using SQL Server Reporting with ASP, not ASP.net

Thx

|||

You can always mimic the approach given above of hainvg a custom page that does the export, just recode it in ASP, rather than ASP.NET.

Hope that helps,

-Lukasz

|||

I have just tried creating the web app posted by BenniG and it works great on my computer but when I try from any of my co-workers computers i get a scripting error stating invalid character on line 2 character 1.

I know this is pretty vague but then again so is the error.

Any thoughts?

Opening a PDF report without the OPEN/Save Dialog

Is there a way to render the PDF report in the same broswer window you just called it from without the Open/Save dialog box coming up. The report is being call directly by URL parameters for PDF formatNo there is not. We set the Content-Type to attachment which causes IE to prompt for this.|||

This is quite easy with custom programming, I've made a new webapp and gave the aspnet-user full access to reporting services, maybe you could add a cutom file to the Reports-Webapp..

I've default.aspx:

<%@. Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%
Dim pdfloader As New PDFLoader(Request, Response)
pdfloader.show()
%>

and default.aspx.vb:

Public Class PDFLoader

Private request As System.Web.HttpRequest
Private response As System.Web.HttpResponse

Public Sub New(ByVal request As System.Web.HttpRequest, ByVal response As System.Web.HttpResponse)
Me.request = request
Me.response = response
End Sub

Public Sub show()
Dim rsExec As New ReportExecutionService
rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials

' Prepare Render arguments
Dim historyID As String = Nothing
Dim deviceInfo As String = Nothing
Dim format As String = "PDF"
Dim showHide As String = Nothing
Dim results() As [Byte]
Dim warnings As RepExServ.Warning() = Nothing
Dim streamIDs As String() = Nothing
Dim encoding As String = String.Empty
Dim mimeType As String = String.Empty
Dim reportName As String

Dim zaehl As Integer = -1
Dim names(), name, values(), value As String
Dim ParameterValues() As RepExServ.ParameterValue
ParameterValues = New RepExServ.ParameterValue(0) {}

names = request.QueryString.AllKeys
For Each name In names
values = request.QueryString.GetValues(name)
For Each value In values
If (name = "") Then
reportName = value
Else
zaehl = zaehl + 1
If zaehl >= ParameterValues.Length Then
ReDim Preserve ParameterValues(zaehl)
End If
Dim ParameterValue As RepExServ.ParameterValue = New RepExServ.ParameterValue
ParameterValue.Name = name
ParameterValue.Value = value
ParameterValue.Label = Nothing
ParameterValues(zaehl) = ParameterValue
End If

Next

Next

Dim ei As ExecutionInfo = rsExec.LoadReport(reportName, historyID)
If zaehl > -1 Then
rsExec.SetExecutionParameters(ParameterValues, "")
End If

'Exectute the report and send it to the Client
results = rsExec.Render(format, deviceInfo, "", encoding, mimeType, warnings, streamIDs)
response.ContentType = "application/pdf"
response.BinaryWrite(results)

End Sub
End Class

Partial Class _Default
Inherits System.Web.UI.Page

End Class

This works just similar to the usual URL-Access method, but you can't specify any "rs:" - Parameters.. sampe call:

http://yourserver/YourWebApp/default.aspx?/RepPath/Repname&Parameter1=something

okay, I forgot something: you have to add WebReferences to you webapp:
http://msdn2.microsoft.com/en-us/library/ms154699(SQL.90).aspx

|||Yes, you can always add your own web app to do this. I was stating that RS does not allow you to change this behavior using either URL access or Report Manager|||You can do this with the ReportViewer control, using the ExportContentDisposition property.|||

I also would like to open my report in PDF format without opening the Open/Save Dialog box.

I read that the ExportContentDisposition is indeed the property to use.

Is there a way to put this property in the URL when calling the report? Or do I have to use the ReportViewer Control? I am using SQL Server Reporting with ASP, not ASP.net

Thx

|||

You can always mimic the approach given above of hainvg a custom page that does the export, just recode it in ASP, rather than ASP.NET.

Hope that helps,

-Lukasz

|||

I have just tried creating the web app posted by BenniG and it works great on my computer but when I try from any of my co-workers computers i get a scripting error stating invalid character on line 2 character 1.

I know this is pretty vague but then again so is the error.

Any thoughts?

Opening a PDF report without the OPEN/Save Dialog

Is there a way to render the PDF report in the same broswer window you just called it from without the Open/Save dialog box coming up. The report is being call directly by URL parameters for PDF formatNo there is not. We set the Content-Type to attachment which causes IE to prompt for this.|||

This is quite easy with custom programming, I've made a new webapp and gave the aspnet-user full access to reporting services, maybe you could add a cutom file to the Reports-Webapp..

I've default.aspx:

<%@. Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%
Dim pdfloader As New PDFLoader(Request, Response)
pdfloader.show()
%>

and default.aspx.vb:

Public Class PDFLoader

Private request As System.Web.HttpRequest
Private response As System.Web.HttpResponse

Public Sub New(ByVal request As System.Web.HttpRequest, ByVal response As System.Web.HttpResponse)
Me.request = request
Me.response = response
End Sub

Public Sub show()
Dim rsExec As New ReportExecutionService
rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials

' Prepare Render arguments
Dim historyID As String = Nothing
Dim deviceInfo As String = Nothing
Dim format As String = "PDF"
Dim showHide As String = Nothing
Dim results() As [Byte]
Dim warnings As RepExServ.Warning() = Nothing
Dim streamIDs As String() = Nothing
Dim encoding As String = String.Empty
Dim mimeType As String = String.Empty
Dim reportName As String

Dim zaehl As Integer = -1
Dim names(), name, values(), value As String
Dim ParameterValues() As RepExServ.ParameterValue
ParameterValues = New RepExServ.ParameterValue(0) {}

names = request.QueryString.AllKeys
For Each name In names
values = request.QueryString.GetValues(name)
For Each value In values
If (name = "") Then
reportName = value
Else
zaehl = zaehl + 1
If zaehl >= ParameterValues.Length Then
ReDim Preserve ParameterValues(zaehl)
End If
Dim ParameterValue As RepExServ.ParameterValue = New RepExServ.ParameterValue
ParameterValue.Name = name
ParameterValue.Value = value
ParameterValue.Label = Nothing
ParameterValues(zaehl) = ParameterValue
End If

Next

Next

Dim ei As ExecutionInfo = rsExec.LoadReport(reportName, historyID)
If zaehl > -1 Then
rsExec.SetExecutionParameters(ParameterValues, "")
End If

'Exectute the report and send it to the Client
results = rsExec.Render(format, deviceInfo, "", encoding, mimeType, warnings, streamIDs)
response.ContentType = "application/pdf"
response.BinaryWrite(results)

End Sub
End Class

Partial Class _Default
Inherits System.Web.UI.Page

End Class

This works just similar to the usual URL-Access method, but you can't specify any "rs:" - Parameters.. sampe call:

http://yourserver/YourWebApp/default.aspx?/RepPath/Repname&Parameter1=something

okay, I forgot something: you have to add WebReferences to you webapp:
http://msdn2.microsoft.com/en-us/library/ms154699(SQL.90).aspx

|||Yes, you can always add your own web app to do this. I was stating that RS does not allow you to change this behavior using either URL access or Report Manager|||You can do this with the ReportViewer control, using the ExportContentDisposition property.|||

I also would like to open my report in PDF format without opening the Open/Save Dialog box.

I read that the ExportContentDisposition is indeed the property to use.

Is there a way to put this property in the URL when calling the report? Or do I have to use the ReportViewer Control? I am using SQL Server Reporting with ASP, not ASP.net

Thx

|||

You can always mimic the approach given above of hainvg a custom page that does the export, just recode it in ASP, rather than ASP.NET.

Hope that helps,

-Lukasz

|||

I have just tried creating the web app posted by BenniG and it works great on my computer but when I try from any of my co-workers computers i get a scripting error stating invalid character on line 2 character 1.

I know this is pretty vague but then again so is the error.

Any thoughts?

Opening a new window on clicking a hyperlink

Hi,

We are opening a Crystal Enterprise report in a browser. The report is opened in a .pdf format. We need to make some texts/images appear as hyperlinks. We did so by formatting the concerned objects in the Crystal Reports Designer and specifying the website address. But on clicking the text/image, the website is being opened in the same window. What can we do so that the website gets opened in a new window? Please Help!
We are using Crystal Reports 10.

Thanks,
ManishHi,

Let me rephrase the problem again after some observations.
We have found out that the hyperlink in thus generated pdf file is indeed opening in a new window. But when this pdf file is displayed inside a frame, clicking on the hyperlink is opening in the same window/frame. Please Help.

Regards,
Manishsql

Opening a Link in a new window.

Hi

I'm would to link from a report to a second report, I would like the second report to open a new window.

I can open the new window with the samples I found in the Forum (javscript windo open'www.microsoft.com','_Blank'), when I try using the actual report and parameters

it does not work, here is what I code in the link (fx)

=void(window.open('Globals!ReportServerUrl'?/Dirxx/Report1&JParmname=" & Fields!LinkID.Value & ,'_blank',toolbar=no,location=no,directories=no,status=yes,menubar=no,scrollbar=yes,resizable=yes,copyhistory=no))"

Any suggestion?

Thank you in advance.

Trentino

Hi,

I need to do exactly what you mention in your question. I wonder if you found a solution.

="javascrippt:void(window.open('

(misspelled purposely)

First(Fields!linked_files_dir.Value, "DataSet1") + "\Crude\Crude Products.pdf"

','_blank'))"

Thank you.

|||

Hi,

Try this expression in "Jump to URL Section" ->

the targeted report should be in the same folder (Globals!ReportFolder)

=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&amp;rs:Command=Render&amp;rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

Regards

Ayzan

|||

Thank you.

I saw your posting on a different thread but my linked documents are on a different location. Changing strategies, I am trying to open the first document on a new window (from a login.aspx page). I don't see an option with rs.render.

Regards,

Dario

Opening a Link in a new window.

Hi

I'm would to link from a report to a second report, I would like the second report to open a new window.

I can open the new window with the samples I found in the Forum (javscript windo open'www.microsoft.com','_Blank'), when I try using the actual report and parameters

it does not work, here is what I code in the link (fx)

=void(window.open('Globals!ReportServerUrl'?/Dirxx/Report1&JParmname=" & Fields!LinkID.Value & ,'_blank',toolbar=no,location=no,directories=no,status=yes,menubar=no,scrollbar=yes,resizable=yes,copyhistory=no))"

Any suggestion?

Thank you in advance.

Trentino

Hi,

I need to do exactly what you mention in your question. I wonder if you found a solution.

="javascrippt:void(window.open('

(misspelled purposely)

First(Fields!linked_files_dir.Value, "DataSet1") + "\Crude\Crude Products.pdf"

','_blank'))"

Thank you.

|||

Hi,

Try this expression in "Jump to URL Section" ->

the targeted report should be in the same folder (Globals!ReportFolder)

=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&amp;rs:Command=Render&amp;rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"

Regards

Ayzan

|||

Thank you.

I saw your posting on a different thread but my linked documents are on a different location. Changing strategies, I am trying to open the first document on a new window (from a login.aspx page). I don't see an option with rs.render.

Regards,

Dario

Opening a hyperlink in new window

Hi All,
I have a hyperlink on my report. The target report opens in the same browser window. I want the target report to open in new instance of the browser.

Any clues as to how to do this?

Thanks in advance

Nikhil Dabke

I'm having the same problem. Would LOVE a little help on this!!

Thanks!
Joanie

|||You could try a this URL for the action (remove the spaces):

j a v a s c r i p t:if(window.open(yourPage.aspx','RsWindow','width=400,height=500,l­ocation=0,menubar=0,status=0,toolbar=0,scrollbars=1',true)){}

Opening a hyperlink in new window

Hi All,
I have a hyperlink on my report. The target report opens in the same browser window. I want the target report to open in new instance of the browser.

Any clues as to how to do this?

Thanks in advance

Nikhil Dabke

I'm having the same problem. Would LOVE a little help on this!!

Thanks!
Joanie

|||You could try a this URL for the action (remove the spaces):

j a v a s c r i p t:if(window.open(yourPage.aspx','RsWindow','width=400,height=500,l­ocation=0,menubar=0,status=0,toolbar=0,scrollbars=1',true)){}|||Hi,

The work around that I found for this is:

The URL that you provide under the Navigation -> Jump To Url must be replaced by :

="javascript:void(window.open('URL','_blank'))"

This worked for me fine after deploying my report to the Report Server.

Thanks,
Praveensql

Open webservice stream in a new child window

Hi,
I've tried to get this to work, and I can't!
I have no problem generating the report, but its opening in my main window.
I want it to open in a new window.
I have a Pushbutton (asp.net) which calls the RS webservice to render the
report, but how can I get the thing to open in a new window?
Any help appreciated.
PaulSolved by using an aspx that just returned the stream and calling via js
window.open on the parent.
On Tue, 21 Jun 2005 09:40:11 +0100, Paul Buxton wrote:
> Hi,
> I've tried to get this to work, and I can't!
> I have no problem generating the report, but its opening in my main window.
> I want it to open in a new window.
> I have a Pushbutton (asp.net) which calls the RS webservice to render the
> report, but how can I get the thing to open in a new window?
> Any help appreciated.
> Paul|||Could you provide an example of this, I too have been attempting this with no
luck.
Thanks,
Kel
"Paul Buxton" wrote:
> Solved by using an aspx that just returned the stream and calling via js
> window.open on the parent.
>
> On Tue, 21 Jun 2005 09:40:11 +0100, Paul Buxton wrote:
> > Hi,
> >
> > I've tried to get this to work, and I can't!
> >
> > I have no problem generating the report, but its opening in my main window.
> > I want it to open in a new window.
> >
> > I have a Pushbutton (asp.net) which calls the RS webservice to render the
> > report, but how can I get the thing to open in a new window?
> >
> > Any help appreciated.
> >
> > Paul
>|||Oh, and is there a way to do this without creating a file, just redisplaying
the data in a new window.
"Paul Buxton" wrote:
> Solved by using an aspx that just returned the stream and calling via js
> window.open on the parent.
>
> On Tue, 21 Jun 2005 09:40:11 +0100, Paul Buxton wrote:
> > Hi,
> >
> > I've tried to get this to work, and I can't!
> >
> > I have no problem generating the report, but its opening in my main window.
> > I want it to open in a new window.
> >
> > I have a Pushbutton (asp.net) which calls the RS webservice to render the
> > report, but how can I get the thing to open in a new window?
> >
> > Any help appreciated.
> >
> > Paul
>

Open URL in new page from a frame

Hi, i have a problem:
- I need to open a report in a new page, from a report contained in a
iFrame of a aspx page
I tried a javascript window.open command in the "jump to URL" property.
But:
- If i run the report in Explorer, i click and the report is correctly
open in a new page
- If i run the report in the iFrame of the aspx page, i click but the
report is wrongly open in the same page
I tried a lot but i can't see the right way. I really need help.
P.S. Sorry for my bad English LanguageHere is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
This capability was introduced with RS2000 SP1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Boa" <mugnaboa@.gmail.com> wrote in message
news:1156498995.499936.169520@.h48g2000cwc.googlegroups.com...
> Hi, i have a problem:
> - I need to open a report in a new page, from a report contained in a
> iFrame of a aspx page
> I tried a javascript window.open command in the "jump to URL" property.
> But:
> - If i run the report in Explorer, i click and the report is correctly
> open in a new page
> - If i run the report in the iFrame of the aspx page, i click but the
> report is wrongly open in the same page
> I tried a lot but i can't see the right way. I really need help.
> P.S. Sorry for my bad English Language
>|||I tried a lot of solutions, serious end crazy solutions, but i'm always
in the same situation: i can't open a link in a new page if ny report
is in a iFrame.
[URL=http://img177.imageshack.us/my.php?image=tabellatentativinf4.jpg][IMG]http://img177.imageshack.us/img177/4769/tabellatentativinf4.th.jpg[/IMG][/URL]
In the image u can see my attempts, in the Explorer Column i explain
the result if i run the report directly in the explorer's page, in the
iFrame Column i explain the result if i run the report in my
application. I need to find a "new page" in the iFrame column.
Any idea?|||Bruce ... i need your help!|||Sorry, I don't know why it isn't working. I haven't done what you are trying
to do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Boa" <mugnaboa@.gmail.com> wrote in message
news:1157640447.600521.206140@.b28g2000cwb.googlegroups.com...
> Bruce ... i need your help!
>

Open URL in New Browser

My report has a table that when I click on a cell it jumps to URL and open
it in the same browser window. How to open the URL in a new browser instead
of current browser window?
Thanks.You didn't ask about Excel but this response of mine to another post will
answer you question:
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager it puts CSV data in unicode which Excel puts all in one column. If
you export in ASCII then Excel does just as you want. To prevent a problem
with cells (Excel will object to sorting the data) you need to remove any
textboxes you have (for instance with a title, showing the parameters run
etc) and instead add additional header rows, merge the cells and put your
text in there instead. I add a link at the top of the report that says
Export Data. With RS 2005 you will be able to configure it to use ASCII
instead of Unicode.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ME" <ME@.mail.com> wrote in message
news:OPWXUKT%23GHA.2408@.TK2MSFTNGP05.phx.gbl...
> My report has a table that when I click on a cell it jumps to URL and open
> it in the same browser window. How to open the URL in a new browser
> instead of current browser window?
> Thanks.
>|||Bruce,
The report I am viewing is in SQL 2000. I replaced your example with my
server name and parameter, it didn't work.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e38AxLT%23GHA.4268@.TK2MSFTNGP02.phx.gbl...
> You didn't ask about Excel but this response of mine to another post will
> answer you question:
> Depending on how you design your reports you can do the following to
> export to Excel. Or, what I do sometimes is make a copy of the report and
> clean it up for data export and then hide it in list view. If you export
> from Report Manager it puts CSV data in unicode which Excel puts all in
> one column. If you export in ASCII then Excel does just as you want. To
> prevent a problem with cells (Excel will object to sorting the data) you
> need to remove any textboxes you have (for instance with a title, showing
> the parameters run etc) and instead add additional header rows, merge the
> cells and put your text in there instead. I add a link at the top of the
> report that says Export Data. With RS 2005 you will be able to configure
> it to use ASCII instead of Unicode.
> Here is an example of a Jump to URL link I use. This causes Excel to come
> up with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ME" <ME@.mail.com> wrote in message
> news:OPWXUKT%23GHA.2408@.TK2MSFTNGP05.phx.gbl...
>> My report has a table that when I click on a cell it jumps to URL and
>> open it in the same browser window. How to open the URL in a new browser
>> instead of current browser window?
>> Thanks.
>|||Use exactly what I have. Do not put in your server name. Replace just the
folder, report and parameters.
Even better, do a test with a report that is without parameters so you know
that is not a problem.
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value','_blank'))"
One last point, you cannot test this in the development environment, you
have to deploy it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ME" <ME@.mail.com> wrote in message
news:O66gRCU%23GHA.3860@.TK2MSFTNGP02.phx.gbl...
> Bruce,
> The report I am viewing is in SQL 2000. I replaced your example with my
> server name and parameter, it didn't work.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e38AxLT%23GHA.4268@.TK2MSFTNGP02.phx.gbl...
>> You didn't ask about Excel but this response of mine to another post will
>> answer you question:
>> Depending on how you design your reports you can do the following to
>> export to Excel. Or, what I do sometimes is make a copy of the report and
>> clean it up for data export and then hide it in list view. If you export
>> from Report Manager it puts CSV data in unicode which Excel puts all in
>> one column. If you export in ASCII then Excel does just as you want. To
>> prevent a problem with cells (Excel will object to sorting the data) you
>> need to remove any textboxes you have (for instance with a title, showing
>> the parameters run etc) and instead add additional header rows, merge the
>> cells and put your text in there instead. I add a link at the top of the
>> report that says Export Data. With RS 2005 you will be able to configure
>> it to use ASCII instead of Unicode.
>> Here is an example of a Jump to URL link I use. This causes Excel to come
>> up with the data in a separate window:
>>
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ME" <ME@.mail.com> wrote in message
>> news:OPWXUKT%23GHA.2408@.TK2MSFTNGP05.phx.gbl...
>> My report has a table that when I click on a cell it jumps to URL and
>> open it in the same browser window. How to open the URL in a new
>> browser instead of current browser window?
>> Thanks.
>>
>|||It worked finally. Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eXGqvGU%23GHA.3456@.TK2MSFTNGP02.phx.gbl...
> Use exactly what I have. Do not put in your server name. Replace just the
> folder, report and parameters.
> Even better, do a test with a report that is without parameters so you
> know that is not a problem.
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value','_blank'))"
> One last point, you cannot test this in the development environment, you
> have to deploy it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ME" <ME@.mail.com> wrote in message
> news:O66gRCU%23GHA.3860@.TK2MSFTNGP02.phx.gbl...
>> Bruce,
>> The report I am viewing is in SQL 2000. I replaced your example with my
>> server name and parameter, it didn't work.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e38AxLT%23GHA.4268@.TK2MSFTNGP02.phx.gbl...
>> You didn't ask about Excel but this response of mine to another post
>> will answer you question:
>> Depending on how you design your reports you can do the following to
>> export to Excel. Or, what I do sometimes is make a copy of the report
>> and clean it up for data export and then hide it in list view. If you
>> export from Report Manager it puts CSV data in unicode which Excel puts
>> all in one column. If you export in ASCII then Excel does just as you
>> want. To prevent a problem with cells (Excel will object to sorting the
>> data) you need to remove any textboxes you have (for instance with a
>> title, showing the parameters run etc) and instead add additional header
>> rows, merge the cells and put your text in there instead. I add a link
>> at the top of the report that says Export Data. With RS 2005 you will be
>> able to configure it to use ASCII instead of Unicode.
>> Here is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>>
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ME" <ME@.mail.com> wrote in message
>> news:OPWXUKT%23GHA.2408@.TK2MSFTNGP05.phx.gbl...
>> My report has a table that when I click on a cell it jumps to URL and
>> open it in the same browser window. How to open the URL in a new
>> browser instead of current browser window?
>> Thanks.
>>
>>
>

Open url in a new window

hi, I got a problem with reporting services 2005.

I have to create a link activated by clicking on an image.

In the image navigation properties I inserted the link in "jump to url" but the problem is that no new window is opened, the url is opened in the initial report page.
I tried to use jscript this way:

javascript:window.open("myurl","", "scrollbars=yes,width=800,height=600,left=0,top=0");

but in this case the url opens in a new window but a blank page is shown in the report page.

How can I solve this problem and open the url in a new window without changing the report page?

Thanks in advance and sorry for my english

="javascript:void window.open('http://yoururl&rs:Command=Render.....and whatever else you need "')"

|||

ok it works!

Thanks a lot for your help

|||

I made the Jump to URL expression as:

=void window.open('http://barn/apx/PortfolioDetail.aspx?linkfield=" & Fields!APX_PortfolioID.Value & "', '_blank')"

The above expression opens a new window correctly when the source report is run from the SSRS ReportServer or Reports (ReportsManager) pages. So far so good. But if the source report is first opened in an HTML frame via the following link, then clicking on the above link (on the source report) does nothing at all (just gives a click sound from IE):

<a href="http://brat/ReportServer/Pages/ReportViewer.aspx?%2fAccount+Profile&rs:Command=Render&rc:Zoom=100" target=apcontent><u>Accounts</u></a>

Very perplexing (at least to me). Any ideas on why this could be happening would be greatly appreciated. TIA.

|||

Adding more info to above. On my development machine (XP/SP2), the link is working from a frame also.

So, the link is not working on the production intranet site for some reason. The dev platform is 2005 Reporting Services with the reporting server databases on sql server 2005 on XP/SP2. The production platform is 2005 Reporting Services but the reporting server databases are on sql server 2000 on windows 2003 server.

The data source for the report is identical for both the platform (stored proc on sql 2000). Any ideas? TIA.

|||

MaryAnn80 wrote:

ok it works!

Thanks a lot for your help

Hi, mate, how did you make it work? I used the same code but the link disappeared when I use '=javascript'. I am using SQL 2005 reporting services. I just want make UserID as an URL and when I click it, it open a new window, it just doesn't work.

|||Yeahhh!I got it working now.Thanks folks!|||

I have a piece of JavaScript for Jump to URL like the following:

=void window.open('MyPage.aspx?ContactId=" + CStr(Fields!ContactId.Value) + "','_blank','location=yes,toolbar=yes,scrollbars=yes,resizable=yes,left=100,top=100,height=600,width=1000')"

The SSRS report is hosted by a Report Viewer control in a Web page (like MyPage.aspx).

The Web page is under a sub-folder of the application root (like http://MyApp/Module1).

The link works fine when the page shows up for the first time (http://MyApp/Module1/MyPage.aspx and the report shows up as expected).

However, if the Refresh button of the Report Viewer is pressed, the access path between the application root and page is chopped off (and I will have an error 404 message says Requested URL: /MyApp/MyPage.aspx resource can not be found.

Everything works fine if I change the JavaScript to:

=void window.open('http://MyServer/MyApp/Module1/MyPage.aspx?ContactId=" + CStr(Fields!ContactId.Value) + "','_blank','location=yes,toolbar=yes,scrollbars=yes,resizable=yes,left=100,top=100,height=600,width=1000')"

The problem with hard coding the full access path is that I have to modify the JavaScript every time when I roll a report from development to production.

I’ve tried a variety of access path strings to make the JavaScript server independent (such as ../Module1/MyPage.aspx, and so on) and have no luck so far.

Can anyone help?

Thanks

Open url in a new window

hi, I got a problem with reporting services 2005.

I have to create a link activated by clicking on an image.

In the image navigation properties I inserted the link in "jump to url" but the problem is that no new window is opened, the url is opened in the initial report page.
I tried to use jscript this way:

javascript:window.open("myurl","", "scrollbars=yes,width=800,height=600,left=0,top=0");

but in this case the url opens in a new window but a blank page is shown in the report page.

How can I solve this problem and open the url in a new window without changing the report page?

Thanks in advance and sorry for my english

="javascript:void window.open('http://yoururl&rs:Command=Render.....and whatever else you need "')"

|||

ok it works!

Thanks a lot for your help

|||

I made the Jump to URL expression as:

=void window.open('http://barn/apx/PortfolioDetail.aspx?linkfield=" & Fields!APX_PortfolioID.Value & "', '_blank')"

The above expression opens a new window correctly when the source report is run from the SSRS ReportServer or Reports (ReportsManager) pages. So far so good. But if the source report is first opened in an HTML frame via the following link, then clicking on the above link (on the source report) does nothing at all (just gives a click sound from IE):

<a href="http://brat/ReportServer/Pages/ReportViewer.aspx?%2fAccount+Profile&rs:Command=Render&rc:Zoom=100" target=apcontent><u>Accounts</u></a>

Very perplexing (at least to me). Any ideas on why this could be happening would be greatly appreciated. TIA.

|||

Adding more info to above. On my development machine (XP/SP2), the link is working from a frame also.

So, the link is not working on the production intranet site for some reason. The dev platform is 2005 Reporting Services with the reporting server databases on sql server 2005 on XP/SP2. The production platform is 2005 Reporting Services but the reporting server databases are on sql server 2000 on windows 2003 server.

The data source for the report is identical for both the platform (stored proc on sql 2000). Any ideas? TIA.

|||

MaryAnn80 wrote:

ok it works!

Thanks a lot for your help

Hi, mate, how did you make it work? I used the same code but the link disappeared when I use '=javascript'. I am using SQL 2005 reporting services. I just want make UserID as an URL and when I click it, it open a new window, it just doesn't work.

|||Yeahhh!I got it working now.Thanks folks!|||

I have a piece of JavaScript for Jump to URL like the following:

=void window.open('MyPage.aspx?ContactId=" + CStr(Fields!ContactId.Value) + "','_blank','location=yes,toolbar=yes,scrollbars=yes,resizable=yes,left=100,top=100,height=600,width=1000')"

The SSRS report is hosted by a Report Viewer control in a Web page (like MyPage.aspx).

The Web page is under a sub-folder of the application root (like http://MyApp/Module1).

The link works fine when the page shows up for the first time (http://MyApp/Module1/MyPage.aspx and the report shows up as expected).

However, if the Refresh button of the Report Viewer is pressed, the access path between the application root and page is chopped off (and I will have an error 404 message says Requested URL: /MyApp/MyPage.aspx resource can not be found.

Everything works fine if I change the JavaScript to:

=void window.open('http://MyServer/MyApp/Module1/MyPage.aspx?ContactId=" + CStr(Fields!ContactId.Value) + "','_blank','location=yes,toolbar=yes,scrollbars=yes,resizable=yes,left=100,top=100,height=600,width=1000')"

The problem with hard coding the full access path is that I have to modify the JavaScript every time when I roll a report from development to production.

I’ve tried a variety of access path strings to make the JavaScript server independent (such as ../Module1/MyPage.aspx, and so on) and have no luck so far.

Can anyone help?

Thanks

sql

Open url in a new window

hi, I got a problem with reporting services 2005.

I have to create a link activated by clicking on an image.

In the image navigation properties I inserted the link in "jump to url" but the problem is that no new window is opened, the url is opened in the initial report page.
I tried to use jscript this way:

javascript:window.open("myurl","", "scrollbars=yes,width=800,height=600,left=0,top=0");

but in this case the url opens in a new window but a blank page is shown in the report page.

How can I solve this problem and open the url in a new window without changing the report page?

Thanks in advance and sorry for my english

="javascript:void window.open('http://yoururl&rs:Command=Render.....and whatever else you need "')"

|||

ok it works!

Thanks a lot for your help

|||

I made the Jump to URL expression as:

=void window.open('http://barn/apx/PortfolioDetail.aspx?linkfield=" & Fields!APX_PortfolioID.Value & "', '_blank')"

The above expression opens a new window correctly when the source report is run from the SSRS ReportServer or Reports (ReportsManager) pages. So far so good. But if the source report is first opened in an HTML frame via the following link, then clicking on the above link (on the source report) does nothing at all (just gives a click sound from IE):

<a href="http://brat/ReportServer/Pages/ReportViewer.aspx?%2fAccount+Profile&rs:Command=Render&rc:Zoom=100" target=apcontent><u>Accounts</u></a>

Very perplexing (at least to me). Any ideas on why this could be happening would be greatly appreciated. TIA.

|||

Adding more info to above. On my development machine (XP/SP2), the link is working from a frame also.

So, the link is not working on the production intranet site for some reason. The dev platform is 2005 Reporting Services with the reporting server databases on sql server 2005 on XP/SP2. The production platform is 2005 Reporting Services but the reporting server databases are on sql server 2000 on windows 2003 server.

The data source for the report is identical for both the platform (stored proc on sql 2000). Any ideas? TIA.

|||

MaryAnn80 wrote:

ok it works!

Thanks a lot for your help

Hi, mate, how did you make it work? I used the same code but the link disappeared when I use '=javascript'. I am using SQL 2005 reporting services. I just want make UserID as an URL and when I click it, it open a new window, it just doesn't work.

|||Yeahhh!I got it working now.Thanks folks!|||

I have a piece of JavaScript for Jump to URL like the following:

=void window.open('MyPage.aspx?ContactId=" + CStr(Fields!ContactId.Value) + "','_blank','location=yes,toolbar=yes,scrollbars=yes,resizable=yes,left=100,top=100,height=600,width=1000')"

The SSRS report is hosted by a Report Viewer control in a Web page (like MyPage.aspx).

The Web page is under a sub-folder of the application root (like http://MyApp/Module1).

The link works fine when the page shows up for the first time (http://MyApp/Module1/MyPage.aspx and the report shows up as expected).

However, if the Refresh button of the Report Viewer is pressed, the access path between the application root and page is chopped off (and I will have an error 404 message says Requested URL: /MyApp/MyPage.aspx resource can not be found.

Everything works fine if I change the JavaScript to:

=void window.open('http://MyServer/MyApp/Module1/MyPage.aspx?ContactId=" + CStr(Fields!ContactId.Value) + "','_blank','location=yes,toolbar=yes,scrollbars=yes,resizable=yes,left=100,top=100,height=600,width=1000')"

The problem with hard coding the full access path is that I have to modify the JavaScript every time when I roll a report from development to production.

I’ve tried a variety of access path strings to make the JavaScript server independent (such as ../Module1/MyPage.aspx, and so on) and have no luck so far.

Can anyone help?

Thanks

Open url in a new window

hi, I got a problem with reporting services 2005.

I have to create a link activated by clicking on an image.

In the image navigation properties I inserted the link in "jump to url" but the problem is that no new window is opened, the url is opened in the initial report page.
I tried to use jscript this way:

javascript:window.open("myurl","", "scrollbars=yes,width=800,height=600,left=0,top=0");

but in this case the url opens in a new window but a blank page is shown in the report page.

How can I solve this problem and open the url in a new window without changing the report page?

Thanks in advance and sorry for my english

="javascript:void window.open('http://yoururl&rs:Command=Render.....and whatever else you need "')"

|||

ok it works!

Thanks a lot for your help

|||

I made the Jump to URL expression as:

=void window.open('http://barn/apx/PortfolioDetail.aspx?linkfield=" & Fields!APX_PortfolioID.Value & "', '_blank')"

The above expression opens a new window correctly when the source report is run from the SSRS ReportServer or Reports (ReportsManager) pages. So far so good. But if the source report is first opened in an HTML frame via the following link, then clicking on the above link (on the source report) does nothing at all (just gives a click sound from IE):

<a href="http://brat/ReportServer/Pages/ReportViewer.aspx?%2fAccount+Profile&rs:Command=Render&rc:Zoom=100" target=apcontent><u>Accounts</u></a>

Very perplexing (at least to me). Any ideas on why this could be happening would be greatly appreciated. TIA.

|||

Adding more info to above. On my development machine (XP/SP2), the link is working from a frame also.

So, the link is not working on the production intranet site for some reason. The dev platform is 2005 Reporting Services with the reporting server databases on sql server 2005 on XP/SP2. The production platform is 2005 Reporting Services but the reporting server databases are on sql server 2000 on windows 2003 server.

The data source for the report is identical for both the platform (stored proc on sql 2000). Any ideas? TIA.

|||

MaryAnn80 wrote:

ok it works!

Thanks a lot for your help

Hi, mate, how did you make it work? I used the same code but the link disappeared when I use '=javascript'. I am using SQL 2005 reporting services. I just want make UserID as an URL and when I click it, it open a new window, it just doesn't work.

|||Yeahhh!I got it working now.Thanks folks!|||

I have a piece of JavaScript for Jump to URL like the following:

=void window.open('MyPage.aspx?ContactId=" + CStr(Fields!ContactId.Value) + "','_blank','location=yes,toolbar=yes,scrollbars=yes,resizable=yes,left=100,top=100,height=600,width=1000')"

The SSRS report is hosted by a Report Viewer control in a Web page (like MyPage.aspx).

The Web page is under a sub-folder of the application root (like http://MyApp/Module1).

The link works fine when the page shows up for the first time (http://MyApp/Module1/MyPage.aspx and the report shows up as expected).

However, if the Refresh button of the Report Viewer is pressed, the access path between the application root and page is chopped off (and I will have an error 404 message says Requested URL: /MyApp/MyPage.aspx resource can not be found.

Everything works fine if I change the JavaScript to:

=void window.open('http://MyServer/MyApp/Module1/MyPage.aspx?ContactId=" + CStr(Fields!ContactId.Value) + "','_blank','location=yes,toolbar=yes,scrollbars=yes,resizable=yes,left=100,top=100,height=600,width=1000')"

The problem with hard coding the full access path is that I have to modify the JavaScript every time when I roll a report from development to production.

I’ve tried a variety of access path strings to make the JavaScript server independent (such as ../Module1/MyPage.aspx, and so on) and have no luck so far.

Can anyone help?

Thanks

|||

I know it's a while late - but I thought it worth posting something here which I have struggled with for some time in RS.

I have a site with 2 frames - left (named "Menu") for the... you guessed it... Menu. and the right frame called "Body".

I was using several dynamic menu items to open up RS reports.

I went to use this, as per many examples, and it did not work. It just clicked with no action (or with Friendly Error Messages turned on it came up with an error screen with the java<removethis>script in the address bar.

="java<removethis>script:void(window.open('" + Trim(Fields!MY_URL.Value) + "','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))"

I figured out after much trial and error that because everything in RS has a target of _top it was causing problems in a frameset. So, the solution which I came up with, and have implemented is as follows:

In the left menu I have added &rc:LinkTarget=Body to the end of all the calls to the report (they populate in the Body frame). Then I use the above javascript for all URL's, and it opens them in a blank window as required.

Hope this may help someone else who struggles with this one.

Cheers,

AndyCJ

Open up new window for external URL

I'm trying to use "Jump to URL" to link the report to external web site.
However, I find that there's no way to open up a new window. It seems
inconvenient for user to close the report whenever external link is clicked.
Does anyone have idea to resolve this?use target=_blank
"Edmond Lee" wrote:
> I'm trying to use "Jump to URL" to link the report to external web site.
> However, I find that there's no way to open up a new window. It seems
> inconvenient for user to close the report whenever external link is clicked.
> Does anyone have idea to resolve this?
>|||yuanxm, Thank you for your reply.
However, I had tried several time to type "target=_blank" together with URL
for "Jump to URL" insides Navigation tab and error was resulted.
Is there any trick required?
"yuanxm" wrote:
> use target=_blank
> "Edmond Lee" wrote:
> > I'm trying to use "Jump to URL" to link the report to external web site.
> > However, I find that there's no way to open up a new window. It seems
> > inconvenient for user to close the report whenever external link is clicked.
> >
> > Does anyone have idea to resolve this?
> >|||I have not personally needed to do this so I don't know from experience but
my feeling is that the solution here is where you are in another webpage
(not Reporting Services) and want to have this happen. Not when it is using
the jump to url. What you can do (and this is something I just learned this
week) is to use the ability with SP1 to use javascript. For you jump to URL
put in the following expression:
="javascript:void(window.open('http://www.google.com'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Edmond Lee" <EdmondLee@.discussions.microsoft.com> wrote in message
news:2ED75DC0-C379-4E9A-A0E1-565B3D9DC746@.microsoft.com...
> yuanxm, Thank you for your reply.
> However, I had tried several time to type "target=_blank" together with
> URL
> for "Jump to URL" insides Navigation tab and error was resulted.
> Is there any trick required?
> "yuanxm" wrote:
>> use target=_blank
>> "Edmond Lee" wrote:
>> > I'm trying to use "Jump to URL" to link the report to external web
>> > site.
>> > However, I find that there's no way to open up a new window. It seems
>> > inconvenient for user to close the report whenever external link is
>> > clicked.
>> >
>> > Does anyone have idea to resolve this?
>> >|||This works only on the reportserver, i.e. when i view reports
http://servername/reportserver/... but the java scrip doesnt work when i view
reports on the report manager like this http://servername/reports/..
Plz suggest somethng
"Bruce L-C [MVP]" wrote:
> I have not personally needed to do this so I don't know from experience but
> my feeling is that the solution here is where you are in another webpage
> (not Reporting Services) and want to have this happen. Not when it is using
> the jump to url. What you can do (and this is something I just learned this
> week) is to use the ability with SP1 to use javascript. For you jump to URL
> put in the following expression:
> ="javascript:void(window.open('http://www.google.com'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Edmond Lee" <EdmondLee@.discussions.microsoft.com> wrote in message
> news:2ED75DC0-C379-4E9A-A0E1-565B3D9DC746@.microsoft.com...
> > yuanxm, Thank you for your reply.
> >
> > However, I had tried several time to type "target=_blank" together with
> > URL
> > for "Jump to URL" insides Navigation tab and error was resulted.
> > Is there any trick required?
> >
> > "yuanxm" wrote:
> >
> >> use target=_blank
> >>
> >> "Edmond Lee" wrote:
> >>
> >> > I'm trying to use "Jump to URL" to link the report to external web
> >> > site.
> >> > However, I find that there's no way to open up a new window. It seems
> >> > inconvenient for user to close the report whenever external link is
> >> > clicked.
> >> >
> >> > Does anyone have idea to resolve this?
> >> >
>
>|||When I tried opening it on report manager, it opened 2 windows. One was
google and the other one had the
javascript:void(window.open('http://www.google.com')) on the address bar. It
was interesting!!
"NI" wrote:
> This works only on the reportserver, i.e. when i view reports
> http://servername/reportserver/... but the java scrip doesnt work when i view
> reports on the report manager like this http://servername/reports/..
> Plz suggest somethng
>
> "Bruce L-C [MVP]" wrote:
> > I have not personally needed to do this so I don't know from experience but
> > my feeling is that the solution here is where you are in another webpage
> > (not Reporting Services) and want to have this happen. Not when it is using
> > the jump to url. What you can do (and this is something I just learned this
> > week) is to use the ability with SP1 to use javascript. For you jump to URL
> > put in the following expression:
> >
> > ="javascript:void(window.open('http://www.google.com'))"
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Edmond Lee" <EdmondLee@.discussions.microsoft.com> wrote in message
> > news:2ED75DC0-C379-4E9A-A0E1-565B3D9DC746@.microsoft.com...
> > > yuanxm, Thank you for your reply.
> > >
> > > However, I had tried several time to type "target=_blank" together with
> > > URL
> > > for "Jump to URL" insides Navigation tab and error was resulted.
> > > Is there any trick required?
> > >
> > > "yuanxm" wrote:
> > >
> > >> use target=_blank
> > >>
> > >> "Edmond Lee" wrote:
> > >>
> > >> > I'm trying to use "Jump to URL" to link the report to external web
> > >> > site.
> > >> > However, I find that there's no way to open up a new window. It seems
> > >> > inconvenient for user to close the report whenever external link is
> > >> > clicked.
> > >> >
> > >> > Does anyone have idea to resolve this?
> > >> >
> >
> >
> >