I dont see rendered report.

Hello, when I navigate to this url I can see the report, with the parameters toolbar.

http://agamenon:90/Reports/Pages/Report.aspx?ItemPath=%2fGescomRpts%2fRPT_EvaluacionRequisitos

But when I try to do it with reportviewer; I see the report parameters, then I click Generate Report, and I dont see nothing.

private

void cargarReporte()

{

string reportserver =ConfigurationSettings.AppSettings["ReportServer"].ToString();string reportfolder =ConfigurationSettings.AppSettings["ReportFolder"].ToString();int NmCiclo =Convert.ToInt32(Request.QueryString["NmCiclo"]);int NmEmpresa =Convert.ToInt32(Request.QueryString["NmEmpresa"]);int NmCargoEvaluada =Convert.ToInt32(Request.QueryString["NmCargoEvaluada"]);int NmPersonaEvaluada =Convert.ToInt32(Request.QueryString["NmPersonaEvaluada"]);

rptviewer.ServerReport.ReportServerUrl =

newUri(reportserver);

rptviewer.ServerReport.ReportPath = reportfolder +

"RPT_EvaluacionRequisitos";

rptviewer.ShowParameterPrompts =

true;

}

I had a similar problem. It was caused by setting the height attribute of the ReportViewer web control to "100%" and using asynchronous rendering. Apparently there is a bug in the way the report table is rendered when the height is a percent (http://msdn2.microsoft.com/en-us/library/ms252090.aspx). I changed to synchronous rendering and everything worked fine.

Ojala que esto le ayudaba.

Mike

|||I have the same issue but I set it to FALSE and my reports that have parameters still don't display after I click on the View Report button. However if I run reports that do not have parameters they generate.|||Hi,
Even Iam facing the same problem , did u get any solution? please let me know..

I can't access a report by URL

Hi every body,
I'm new at using Report Services and I don't understand what I am
supposed to do to access a report by URL.
For the moment, I'm still working on report samples and I try to
create an URL access to Employee Sales Summary. I've made a small web
page with this link:
<a href="http://links.10026.com/?link=http://localhost/Reports/Pages/Report.aspx?Itempath=/Sample
Reports/Employee Sales
Summary&rc:Parameters=false&rs:Command=Render&rs:format=HTML4.0&EmpId=20&ReportYear=2003&ReportMonth=12">lien
direct</a>
It accesses the page but asks me for the parameters as if they were
not in the url.
The real goal behind this is to access to the report using a
multiple-values parameter for the Employee ID. As it doesn't seem to
be possible from the basic interface of Report Sevices, I thought I
could make a form and then pass the list in the parameters and making
the "where" clause like this in the report:
where SalesPersonID IN (@.EmpID)You should use the report server URL not the Report Manager URL.
So try this:
http://localhost/reportsever?/Sample&rs:Command=Render
The full documentation on how to do this is available in Books online (also
on MSDN). Search for URL Access.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jocelyn" <j_chaumette@.yahoo.fr> wrote in message
news:15fe105b.0407190102.cb43a71@.posting.google.com...
> Hi every body,
> I'm new at using Report Services and I don't understand what I am
> supposed to do to access a report by URL.
> For the moment, I'm still working on report samples and I try to
> create an URL access to Employee Sales Summary. I've made a small web
> page with this link:
> <a href="http://links.10026.com/?link=http://localhost/Reports/Pages/Report.aspx?Itempath=/Sample
> Reports/Employee Sales
> Summary&rc:Parameters=false&rs:Command=Render&rs:format=HTML4.0&EmpId=20&ReportYear=2003&ReportMonth=12">lien
> direct</a>
> It accesses the page but asks me for the parameters as if they were
> not in the url.
> The real goal behind this is to access to the report using a
> multiple-values parameter for the Employee ID. As it doesn't seem to
> be possible from the basic interface of Report Sevices, I thought I
> could make a form and then pass the list in the parameters and making
> the "where" clause like this in the report:
> where SalesPersonID IN (@.EmpID)|||Thanks a lot!
It did work :) .
But actually, it was only the first step of my tests and I have now a
new issue.
As I have explained earlier (I think I did...), I need a multi-value
field parameter. This is the only reason why I'm making this html
page.
For the moment, the single value field works but I can't make it with
a multi-value field. It seems that my query is simply not good.
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN (@.EmpId))
I also tried to test the syntax of the list in the parameter, using
this query:
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN (20,21))
and then I tried
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN ('20','21'))
The report appears empty (the value 20 and 21 are good and the report
parameter is an integer).
Any Idea of how I should do?|||Jocelyn,
You can't use a variable in an IN clause. You need to use a Function like
the one below and either JOIN to it or use a nested SELECT.
e.g.
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
INNER JOIN dbo.fnIntList(@.EmpId) ON EmployeeID=Value
brian
---
CREATE FUNCTION dbo.fnIntList ( @.InputString varchar(2000) )
RETURNS @.IntList TABLE (Value int)
AS
BEGIN
DECLARE @.Temp int
DECLARE @.Delimiter varchar(1)
SET @.Delimiter = ','
-- remove any surrounding spaces
SET @.InputString = RTRIM(LTRIM(@.InputString ))
WHILE (CHARINDEX(@.Delimiter, @.InputString)) > 0
BEGIN
SET @.Temp = RTRIM(LTRIM(LEFT(@.InputString, CHARINDEX(@.Delimiter,
@.InputString)-1)))
IF @.Temp != ''
INSERT @.IntList Values(@.Temp)
SET @.InputString = RIGHT(@.InputString, LEN(@.InputString) -
CHARINDEX(@.Delimiter,@.InputString))
END
SET @.Temp = RTRIM(LTRIM(@.InputString))
IF @.Temp != ''
INSERT @.IntList Values(@.Temp)
RETURN
END
GO
----
"Jocelyn" <j_chaumette@.yahoo.fr> wrote in message
news:15fe105b.0407202353.225402c4@.posting.google.com...
> Thanks a lot!
> It did work :) .
> But actually, it was only the first step of my tests and I have now a
> new issue.
> As I have explained earlier (I think I did...), I need a multi-value
> field parameter. This is the only reason why I'm making this html
> page.
> For the moment, the single value field works but I can't make it with
> a multi-value field. It seems that my query is simply not good.
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN (@.EmpId))
> I also tried to test the syntax of the list in the parameter, using
> this query:
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN (20,21))
> and then I tried
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN ('20','21'))
> The report appears empty (the value 20 and 21 are good and the report
> parameter is an integer).
> Any Idea of how I should do?

I am viewing reports through a .Net interface. I want to hide

the URL when the report is rendered. How can I do this?If you are using RS 2005 and are either at or can go to 2.0 framework then
check out the new webform controls that ship with VS 2005. The other option
is to use web services instead of URL integration URL integration is easier
but it really is not suitable if you are trying to hide things from the
user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:F77A8831-CD45-4431-8DF6-E89D487C3F80@.microsoft.com...
> the URL when the report is rendered. How can I do this?

I am not able to open my report through URL It's URGENT!!!!!1

I am not able to open reports through URL.

<A HREF="http://localhost/Reports?NTIEE Reports/NTSID_LookUp">View Report</A>

When i click on this link it opens report manager and the NTIEE Reports folder.But i want to open direclty the report.Name of the report is NTSID_LookUp which is depoyed inside NTIEE Reports folder.Pls let me know how i can open a report through my web application.

Run the report in Report Manager and then right-click inside the report to get the Properties. The URL to link directly to the report is there.

If you don't want to see the manager, you should user Reportserver? instead of Reports.

cheers,

Andrew

|||

Try this

<A HREF="http://localhost/ReportServer?NTIEE Reports/NTSID_LookUp&rs:Command=render">View Report</A>

or this

<A HREF="http://localhost/ReportServer/Pages/ReportViewer.aspx?NTIEE Reports/NTSID_LookUp&rs:Command=Render">View Report</A>

Pls also make sure you use the correct the virtual directory - ReportServer (which is the default).

Cheers,

Henary

Hyperlink to send an Email

Hello,
I am looking for a way for users to click on a textbox and send an Email. I
got that to work if I set up 'On action' URL to
'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
If a user clicks next to A then Email should go to A@.myemail.com and if they
click next to B email should go to B@.myemail.com so on and so forth. I have A
and B here is value in my field MYFIELD. I tried using
mailto:Fields!MYFIELD.value that won't work.
Any ideas will be appreciated.
Thanks.Hi,
You can use the following expresion in the 'Jump to URL':
="mailto:" & Fields!MYFIELD.value
Use this with the equal sign and spaces. You can add
& "@.mycompany.com" if your field doesn't have the domain included
Jan Pieter Posthuma
"amitj" wrote:
> Hello,
> I am looking for a way for users to click on a textbox and send an Email. I
> got that to work if I set up 'On action' URL to
> 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> If a user clicks next to A then Email should go to A@.myemail.com and if they
> click next to B email should go to B@.myemail.com so on and so forth. I have A
> and B here is value in my field MYFIELD. I tried using
> mailto:Fields!MYFIELD.value that won't work.
> Any ideas will be appreciated.
> Thanks.|||Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
didn't add the field name.
"Jan Pieter Posthuma" wrote:
> Hi,
> You can use the following expresion in the 'Jump to URL':
> ="mailto:" & Fields!MYFIELD.value
> Use this with the equal sign and spaces. You can add
> & "@.mycompany.com" if your field doesn't have the domain included
> Jan Pieter Posthuma
>
> "amitj" wrote:
> > Hello,
> >
> > I am looking for a way for users to click on a textbox and send an Email. I
> > got that to work if I set up 'On action' URL to
> > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > and B here is value in my field MYFIELD. I tried using
> > mailto:Fields!MYFIELD.value that won't work.
> >
> > Any ideas will be appreciated.
> >
> > Thanks.|||Hi,
You have to add also the qoutes (") and & symbols. You have to use the equal
(=) to let RS to calculate the field. The next part is a string "mailto:"
including the quotes. Then you concatenate by using the &-sign to the value
part: Fields!MYFIELD.value.
Totally will be: <code>="mailto:" & Fields!MYFIELD.value</code>
That will work.
Jan Pieter Posthuma
"amitj" wrote:
> Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
> mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
> didn't add the field name.
> "Jan Pieter Posthuma" wrote:
> > Hi,
> >
> > You can use the following expresion in the 'Jump to URL':
> > ="mailto:" & Fields!MYFIELD.value
> >
> > Use this with the equal sign and spaces. You can add
> > & "@.mycompany.com" if your field doesn't have the domain included
> >
> > Jan Pieter Posthuma
> >
> >
> > "amitj" wrote:
> >
> > > Hello,
> > >
> > > I am looking for a way for users to click on a textbox and send an Email. I
> > > got that to work if I set up 'On action' URL to
> > > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > > and B here is value in my field MYFIELD. I tried using
> > > mailto:Fields!MYFIELD.value that won't work.
> > >
> > > Any ideas will be appreciated.
> > >
> > > Thanks.

Hyperlink to open in a new blank window.

A field in one of my reports has the navigation property jump to a url, which is a Word document on our server. The problem is the Word file opens up in the existing frame of our website, instead of opening a new frame. In the past I have used _blank. Where do I place this in Visual Studio 2003 to perform this action with Reporting Services?
Thanks for your help.

Hi
it seems that you are trying to open Document in new window so here is the line to be used in Jump to Url Textbox
="javascript:void(window.open('http://www.google.com','_blank'))" this will popup google.com in new page.
if you are picking the url from database you can use this
="javascript:void(window.open('" & Fields!URL.Value &"','_blank'))"
is this you are trying to do?
Thanks
Rohit|||

Yes, that is what I'm trying to accomplish, except it doesn't work. I copy and paste the following into Reporting Services:
Advanced TextBox Properties>Navigation>Hyperlink Action:>Jump to URL:
="javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))"
I get-->
javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))" in the URL

I'm using Windows 2000 Server, SQLServer2000, and IE 6.0.29 with all service packs installed.

|||Hi,
That means you need to Install Hotfix for SQL Server 2000 Reporting Services SP2 and make sure you already have installed Reporting Services SP2, The hot fix setup will not run on computer unless you have SP2 Installed on your computer.
Here is the Link for both
http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en

Thanks
Rohit
|||

I pulled one Report (RDl) on IE

For Example:-

I am havingtestreport.rdl file

I am giving another reporti.e testreport2.rdl in JUMP to URL box intestreport.rdl file

I opened the below linkwith testreport.rdl

http://localhost/reportserver/testreport

I Clicked oneone item ontestreport.rdl

I got Result on samewindow(OPENED IE) , But I want result on New Window(I have to open New Window for Sub report )

I got solution with Reporting Services SP2 package with SQL2000.RS-KB901383-v8.00.1042.00-ENGHotFix using this statement injumptoURL(

="javascript:void(window.open('http://localhost/reportserver/testreport2,'_blank'))"

But I want onlywith SQLserver2000 Reporting services only with out SP2 Package

Can u please helpme

With

Regards

Battula

|||

Hi

I'm not sure if we can use javascript to open new window without installing HotFix

but after the installation we can open report in new window with parameters thru Jump To URL like this

="javascript:void(window.open('http://localhost/reportserver?/testReport/ReportName&rs:Command=Render&Parameter1=" & Fields!Parameter1.Value & "','_blank'))"

Thanx

|||

Iam able to open new window but not able to see any text to identify that the link is present. Any idea on this.

i have to very hardly hover in the reprot to find where the link is located.

|||You would not put the link in the expression for the pop up. The expression for the field should be normal I.E. =Fields!some_value.Value or some hard coded value, the text should appear and when using the jump to URL should pop open your window. If you are still not seeing anything check your formatting, perhaps its the same color as the background, sillier things are known to happen in developing!

Hyperlink to a new window

I have two hyperlink-related questions:
1. How can I generate a URL from within a query or stored procedure such that it appears as a hyperlink within the report? On my first attempt, the text of the link shows but it does not appear as a "live" link within the generated report.
2. Once I've achieved #1, how can I get that link appear in a new browser window rather than the one in which the report is currently displayed?
Thanks in advance for the advice.#1:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
#2: Take a look at _LinkTarget device info setting:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> I have two hyperlink-related questions:
> 1. How can I generate a URL from within a query or stored procedure such
that it appears as a hyperlink within the report? On my first attempt, the
text of the link shows but it does not appear as a "live" link within the
generated report.
> 2. Once I've achieved #1, how can I get that link appear in a new browser
window rather than the one in which the report is currently displayed?
> Thanks in advance for the advice.
>|||Your links proved unhelpful for the following reasons:
#1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
#2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
Example:
If my report gets information from the following query...
select url from urlsource
and urlsource contains
* http://www.site1.com/
* http://www.site2.com/
How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
"Ravi Mumulla (Microsoft)" wrote:
> #1:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> #2: Take a look at _LinkTarget device info setting:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > I have two hyperlink-related questions:
> >
> > 1. How can I generate a URL from within a query or stored procedure such
> that it appears as a hyperlink within the report? On my first attempt, the
> text of the link shows but it does not appear as a "live" link within the
> generated report.
> >
> > 2. Once I've achieved #1, how can I get that link appear in a new browser
> window rather than the one in which the report is currently displayed?
> >
> > Thanks in advance for the advice.
> >
>
>|||On the question of treating your field data as a URL, there is the URLEncode command.
=Web.HttpUtility.UrlEncode(Fields!Serial.Value)
(http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=
)
There is another thread that can answer some potential issues you may have with implementing this.
(http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=)
On your second question, about being able to open a link in a new window...if you are using Report Manager for your distribution platform, then there is NOT a current way to do so. Even if you are using the HTML Viewer and sending in rc: comands, it is an all or nothing deal - either all your links open in a new window or none of them do. I have sugested a few features that I hope MS will implement into one of their future SPs, but until that time, your options are few.
"virtualfergy" wrote:
> Your links proved unhelpful for the following reasons:
> #1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
> #2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
> Example:
> If my report gets information from the following query...
> select url from urlsource
> and urlsource contains
> * http://www.site1.com/
> * http://www.site2.com/
> How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
> "Ravi Mumulla (Microsoft)" wrote:
> > #1:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> > #2: Take a look at _LinkTarget device info setting:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> > news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > > I have two hyperlink-related questions:
> > >
> > > 1. How can I generate a URL from within a query or stored procedure such
> > that it appears as a hyperlink within the report? On my first attempt, the
> > text of the link shows but it does not appear as a "live" link within the
> > generated report.
> > >
> > > 2. Once I've achieved #1, how can I get that link appear in a new browser
> > window rather than the one in which the report is currently displayed?
> > >
> > > Thanks in advance for the advice.
> > >
> >
> >
> >|||Look at my post from 8/26:
I think I have a solution. If you want a particular link to be opened in a
new window, enter this into the "Jump to URL" field:
javascript:if(window.open(yourPage.aspx','RsWindow','width=400,height=500,location=0,menubar=0,status=0,toolbar=0,scrollbars=1',true)){}
"Rob 'Spike' Stevens" wrote:
> On the question of treating your field data as a URL, there is the URLEncode command.
> =Web.HttpUtility.UrlEncode(Fields!Serial.Value)
> (http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=
> )
> There is another thread that can answer some potential issues you may have with implementing this.
> (http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?query=URLEncode&dg=microsoft.public.sqlserver.reportingsvcs&cat=&lang=en&cr=US&pt=&catlist=6C839803-6334-48D8-A2C3-72A1BEF0053D&dglist=&ptlist=&exp=)
> On your second question, about being able to open a link in a new window...if you are using Report Manager for your distribution platform, then there is NOT a current way to do so. Even if you are using the HTML Viewer and sending in rc: comands, it is an all or nothing deal - either all your links open in a new window or none of them do. I have sugested a few features that I hope MS will implement into one of their future SPs, but until that time, your options are few.
> "virtualfergy" wrote:
> > Your links proved unhelpful for the following reasons:
> >
> > #1 - This link talks about how to add a hyperlink to a report manually. I want to return a URL from a query in a field and have the link appear and be active without having to manually set it up.
> >
> > #2 - This link indicates how to use the LinkTarget parameter when executing a report to set the device to which the links in the report are directed. But what I'm attempting to do is to have certain links in a report shown in a new window. These links are not drillthrough reports, they're just links to other related subsystems (in this case a problem tracking system).
> >
> > Example:
> >
> > If my report gets information from the following query...
> >
> > select url from urlsource
> >
> > and urlsource contains
> >
> > * http://www.site1.com/
> > * http://www.site2.com/
> >
> > How could I get the site1 url to show in the same window as the report and site2 to popup a new window? And if the text of these URLs are returned as fields, can I make them active links automatically or do I have to set an action on the field?
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > #1:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_6mwb.asp
> > > #2: Take a look at _LinkTarget device info setting:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> > > news:11FD9027-8D50-4DD6-83F9-D9091D3F099A@.microsoft.com...
> > > > I have two hyperlink-related questions:
> > > >
> > > > 1. How can I generate a URL from within a query or stored procedure such
> > > that it appears as a hyperlink within the report? On my first attempt, the
> > > text of the link shows but it does not appear as a "live" link within the
> > > generated report.
> > > >
> > > > 2. Once I've achieved #1, how can I get that link appear in a new browser
> > > window rather than the one in which the report is currently displayed?
> > > >
> > > > Thanks in advance for the advice.
> > > >
> > >
> > >
> > >

Hyperlink not working when rendered in PDF

Hi,
I 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'))"
Kindly advice.On Dec 14, 1:28 pm, Prabhakar <Prabha...@.discussions.microsoft.com>
wrote:
> Hi,
> I 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'))"
> Kindly advice.
It sounds like there is either an ActiveX control or an image/etc that
is blocked in Internet Explorer (I'm assuming your default browser)
that exists on the project.aspx page. You might want to allow ActiveX
in the Internet Explorer settings (note that this could be a security
risk outside your process). Also, there might be an error in the
project.aspx page itself. I would guess that this would not throw an
error in Firefox. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Hyperlink as popup

Hi,

I'm trying to find a way to put in a hyperlink to a url so the url linked to comes up in a new popup window and leaves the original report visible. Any help greatly appreciated.

Hello,

There are a couple other posts on here for the same issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=858533&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1265427&SiteID=1

="javascript:void window.open('MyUrl')"

Hope this helps.

Jarret

hyperlink

I am trying to provide hyperlink with parameter, to open up in new window by
the following url
="javascript:void(window.open(
'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
MArk2.value is a field from query in a dataset, I tried give the parameter
mark2.value but get errors in javascript as expected '('
Can i get new window code with parameter so that i can implement.
I am using it in text box advanced navigate url.
Regards,
NavinOn Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com> wrote:
> I am trying to provide hyperlink with parameter, to open up in new window by
> the following url
> ="javascript:void(window.open(
> 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> MArk2.value is a field from query in a dataset, I tried give the parameter
> mark2.value but get errors in javascript as expected '('
> Can i get new window code with parameter so that i can implement.
> I am using it in text box advanced navigate url.
> Regards,
> Navin
Should your '=' be a '+' or '&'.
Kerrie|||Sorry inspite of that it dont work. :-(
"Kerrie" wrote:
> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com> wrote:
> > I am trying to provide hyperlink with parameter, to open up in new window by
> > the following url
> >
> > ="javascript:void(window.open(
> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> >
> > MArk2.value is a field from query in a dataset, I tried give the parameter
> > mark2.value but get errors in javascript as expected '('
> >
> > Can i get new window code with parameter so that i can implement.
> >
> > I am using it in text box advanced navigate url.
> >
> > Regards,
> > Navin
> Should your '=' be a '+' or '&'.
> Kerrie
>|||What I suggest you do is create a textbox. Put this expression in the text
box. View the report and look at it. What is happening is that you are not
assembling the string properly.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> Sorry inspite of that it dont work. :-(
> "Kerrie" wrote:
>> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com> wrote:
>> > I am trying to provide hyperlink with parameter, to open up in new
>> > window by
>> > the following url
>> >
>> > ="javascript:void(window.open(
>> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
>> >
>> > MArk2.value is a field from query in a dataset, I tried give the
>> > parameter
>> > mark2.value but get errors in javascript as expected '('
>> >
>> > Can i get new window code with parameter so that i can implement.
>> >
>> > I am using it in text box advanced navigate url.
>> >
>> > Regards,
>> > Navin
>> Should your '=' be a '+' or '&'.
>> Kerrie
>>|||Intially i was using the following link which work very fine taking the value
which is for mark2.
="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
when i click on link it would open as
http://zxy/till.asp?MainID=20075
which open in the same window now i want to open in new window instead of
same window.
="javascript:void(window.open('http://zxy/till.asp?MainID=' +
Fields!Mark2.Value,'_blank'))"
"Bruce L-C [MVP]" wrote:
> What I suggest you do is create a textbox. Put this expression in the text
> box. View the report and look at it. What is happening is that you are not
> assembling the string properly.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> >
> > Sorry inspite of that it dont work. :-(
> >
> > "Kerrie" wrote:
> >
> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com> wrote:
> >> > I am trying to provide hyperlink with parameter, to open up in new
> >> > window by
> >> > the following url
> >> >
> >> > ="javascript:void(window.open(
> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> >> >
> >> > MArk2.value is a field from query in a dataset, I tried give the
> >> > parameter
> >> > mark2.value but get errors in javascript as expected '('
> >> >
> >> > Can i get new window code with parameter so that i can implement.
> >> >
> >> > I am using it in text box advanced navigate url.
> >> >
> >> > Regards,
> >> > Navin
> >>
> >> Should your '=' be a '+' or '&'.
> >>
> >> Kerrie
> >>
> >>
>
>|||Guess what. I can tell you exactly what is wrong here. You are not
assembling the string correctly. Do as I said and you will see exactly what
you are doing wrong. Put this expression as the source of a textbox so you
can see what is happening.
Here is an example that works (it is calling a report rather than an asp
page but the idea is the same).
="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
"NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> Intially i was using the following link which work very fine taking the
> value
> which is for mark2.
> ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> when i click on link it would open as
> http://zxy/till.asp?MainID=20075
> which open in the same window now i want to open in new window instead of
> same window.
>
> ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
> Fields!Mark2.Value,'_blank'))"
>
> "Bruce L-C [MVP]" wrote:
>> What I suggest you do is create a textbox. Put this expression in the
>> text
>> box. View the report and look at it. What is happening is that you are
>> not
>> assembling the string properly.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
>> >
>> > Sorry inspite of that it dont work. :-(
>> >
>> > "Kerrie" wrote:
>> >
>> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com> wrote:
>> >> > I am trying to provide hyperlink with parameter, to open up in new
>> >> > window by
>> >> > the following url
>> >> >
>> >> > ="javascript:void(window.open(
>> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
>> >> >
>> >> > MArk2.value is a field from query in a dataset, I tried give the
>> >> > parameter
>> >> > mark2.value but get errors in javascript as expected '('
>> >> >
>> >> > Can i get new window code with parameter so that i can implement.
>> >> >
>> >> > I am using it in text box advanced navigate url.
>> >> >
>> >> > Regards,
>> >> > Navin
>> >>
>> >> Should your '=' be a '+' or '&'.
>> >>
>> >> Kerrie
>> >>
>> >>
>>|||I dont want to guess anything any more i have seen all the hyperlink answers
you have the same post you give out the same string as below:
Here is an example that works (it is calling a report rather than an asp
page but the idea is the same).
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Why dont you correct my string and send sir.
"Bruce L-C [MVP]" wrote:
> Guess what. I can tell you exactly what is wrong here. You are not
> assembling the string correctly. Do as I said and you will see exactly what
> you are doing wrong. Put this expression as the source of a textbox so you
> can see what is happening.
> Here is an example that works (it is calling a report rather than an asp
> page but the idea is the same).
> ="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
>
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> > Intially i was using the following link which work very fine taking the
> > value
> > which is for mark2.
> >
> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> >
> > when i click on link it would open as
> > http://zxy/till.asp?MainID=20075
> >
> > which open in the same window now i want to open in new window instead of
> > same window.
> >
> >
> >
> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
> > Fields!Mark2.Value,'_blank'))"
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> What I suggest you do is create a textbox. Put this expression in the
> >> text
> >> box. View the report and look at it. What is happening is that you are
> >> not
> >> assembling the string properly.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> >> >
> >> > Sorry inspite of that it dont work. :-(
> >> >
> >> > "Kerrie" wrote:
> >> >
> >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com> wrote:
> >> >> > I am trying to provide hyperlink with parameter, to open up in new
> >> >> > window by
> >> >> > the following url
> >> >> >
> >> >> > ="javascript:void(window.open(
> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> >> >> >
> >> >> > MArk2.value is a field from query in a dataset, I tried give the
> >> >> > parameter
> >> >> > mark2.value but get errors in javascript as expected '('
> >> >> >
> >> >> > Can i get new window code with parameter so that i can implement.
> >> >> >
> >> >> > I am using it in text box advanced navigate url.
> >> >> >
> >> >> > Regards,
> >> >> > Navin
> >> >>
> >> >> Should your '=' be a '+' or '&'.
> >> >>
> >> >> Kerrie
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||You haven't even tried what I suggested have you? Have you put the
expression in a text box and then run the report and look at the resulting
string? Did you look at how I assembled a working expression and then look
at your and see what you did wrong.
I help people learn. You don't seem to care to learn. Oh well.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
>I dont want to guess anything any more i have seen all the hyperlink
>answers
> you have the same post you give out the same string as below:
> Here is an example that works (it is calling a report rather than an asp
> page but the idea is the same).
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> Why dont you correct my string and send sir.
> "Bruce L-C [MVP]" wrote:
>> Guess what. I can tell you exactly what is wrong here. You are not
>> assembling the string correctly. Do as I said and you will see exactly
>> what
>> you are doing wrong. Put this expression as the source of a textbox so
>> you
>> can see what is happening.
>> Here is an example that works (it is calling a report rather than an asp
>> page but the idea is the same).
>> ="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
>>
>> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
>> > Intially i was using the following link which work very fine taking the
>> > value
>> > which is for mark2.
>> >
>> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
>> >
>> > when i click on link it would open as
>> > http://zxy/till.asp?MainID=20075
>> >
>> > which open in the same window now i want to open in new window instead
>> > of
>> > same window.
>> >
>> >
>> >
>> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
>> > Fields!Mark2.Value,'_blank'))"
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> What I suggest you do is create a textbox. Put this expression in the
>> >> text
>> >> box. View the report and look at it. What is happening is that you are
>> >> not
>> >> assembling the string properly.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
>> >> >
>> >> > Sorry inspite of that it dont work. :-(
>> >> >
>> >> > "Kerrie" wrote:
>> >> >
>> >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com>
>> >> >> wrote:
>> >> >> > I am trying to provide hyperlink with parameter, to open up in
>> >> >> > new
>> >> >> > window by
>> >> >> > the following url
>> >> >> >
>> >> >> > ="javascript:void(window.open(
>> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
>> >> >> >
>> >> >> > MArk2.value is a field from query in a dataset, I tried give the
>> >> >> > parameter
>> >> >> > mark2.value but get errors in javascript as expected '('
>> >> >> >
>> >> >> > Can i get new window code with parameter so that i can implement.
>> >> >> >
>> >> >> > I am using it in text box advanced navigate url.
>> >> >> >
>> >> >> > Regards,
>> >> >> > Navin
>> >> >>
>> >> >> Should your '=' be a '+' or '&'.
>> >> >>
>> >> >> Kerrie
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Just modify according to your needs ie replace 20075 with your parameter e.g
="javascript:Void(window.open('http://locahost/till.asp?MainID=20075','_Blank'))"
Build, deploy on a server and then check, dont do a preview and check.
Amarnath
"NAVIN.D" wrote:
> I dont want to guess anything any more i have seen all the hyperlink answers
> you have the same post you give out the same string as below:
> Here is an example that works (it is calling a report rather than an asp
> page but the idea is the same).
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> Why dont you correct my string and send sir.
> "Bruce L-C [MVP]" wrote:
> > Guess what. I can tell you exactly what is wrong here. You are not
> > assembling the string correctly. Do as I said and you will see exactly what
> > you are doing wrong. Put this expression as the source of a textbox so you
> > can see what is happening.
> >
> > Here is an example that works (it is calling a report rather than an asp
> > page but the idea is the same).
> > ="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
> >
> >
> > "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> > news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> > > Intially i was using the following link which work very fine taking the
> > > value
> > > which is for mark2.
> > >
> > > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> > >
> > > when i click on link it would open as
> > > http://zxy/till.asp?MainID=20075
> > >
> > > which open in the same window now i want to open in new window instead of
> > > same window.
> > >
> > >
> > >
> > > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
> > > Fields!Mark2.Value,'_blank'))"
> > >
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> What I suggest you do is create a textbox. Put this expression in the
> > >> text
> > >> box. View the report and look at it. What is happening is that you are
> > >> not
> > >> assembling the string properly.
> > >>
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> > >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> > >> >
> > >> > Sorry inspite of that it dont work. :-(
> > >> >
> > >> > "Kerrie" wrote:
> > >> >
> > >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com> wrote:
> > >> >> > I am trying to provide hyperlink with parameter, to open up in new
> > >> >> > window by
> > >> >> > the following url
> > >> >> >
> > >> >> > ="javascript:void(window.open(
> > >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> > >> >> >
> > >> >> > MArk2.value is a field from query in a dataset, I tried give the
> > >> >> > parameter
> > >> >> > mark2.value but get errors in javascript as expected '('
> > >> >> >
> > >> >> > Can i get new window code with parameter so that i can implement.
> > >> >> >
> > >> >> > I am using it in text box advanced navigate url.
> > >> >> >
> > >> >> > Regards,
> > >> >> > Navin
> > >> >>
> > >> >> Should your '=' be a '+' or '&'.
> > >> >>
> > >> >> Kerrie
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >|||Bruce can you split the lenght string and explain each part. So, that i have
clarity on what i am trying to implement where.
="javascript:void(window.open('" & Globals!ReportServerUrl &
> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Thanks
Navin
"Bruce L-C [MVP]" wrote:
> You haven't even tried what I suggested have you? Have you put the
> expression in a text box and then run the report and look at the resulting
> string? Did you look at how I assembled a working expression and then look
> at your and see what you did wrong.
> I help people learn. You don't seem to care to learn. Oh well.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
> >I dont want to guess anything any more i have seen all the hyperlink
> >answers
> > you have the same post you give out the same string as below:
> >
> > Here is an example that works (it is calling a report rather than an asp
> > page but the idea is the same).
> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >
> > Why dont you correct my string and send sir.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Guess what. I can tell you exactly what is wrong here. You are not
> >> assembling the string correctly. Do as I said and you will see exactly
> >> what
> >> you are doing wrong. Put this expression as the source of a textbox so
> >> you
> >> can see what is happening.
> >>
> >> Here is an example that works (it is calling a report rather than an asp
> >> page but the idea is the same).
> >> ="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
> >>
> >>
> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> >> > Intially i was using the following link which work very fine taking the
> >> > value
> >> > which is for mark2.
> >> >
> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> >> >
> >> > when i click on link it would open as
> >> > http://zxy/till.asp?MainID=20075
> >> >
> >> > which open in the same window now i want to open in new window instead
> >> > of
> >> > same window.
> >> >
> >> >
> >> >
> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
> >> > Fields!Mark2.Value,'_blank'))"
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> What I suggest you do is create a textbox. Put this expression in the
> >> >> text
> >> >> box. View the report and look at it. What is happening is that you are
> >> >> not
> >> >> assembling the string properly.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> >> >> >
> >> >> > Sorry inspite of that it dont work. :-(
> >> >> >
> >> >> > "Kerrie" wrote:
> >> >> >
> >> >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com>
> >> >> >> wrote:
> >> >> >> > I am trying to provide hyperlink with parameter, to open up in
> >> >> >> > new
> >> >> >> > window by
> >> >> >> > the following url
> >> >> >> >
> >> >> >> > ="javascript:void(window.open(
> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> >> >> >> >
> >> >> >> > MArk2.value is a field from query in a dataset, I tried give the
> >> >> >> > parameter
> >> >> >> > mark2.value but get errors in javascript as expected '('
> >> >> >> >
> >> >> >> > Can i get new window code with parameter so that i can implement.
> >> >> >> >
> >> >> >> > I am using it in text box advanced navigate url.
> >> >> >> >
> >> >> >> > Regards,
> >> >> >> > Navin
> >> >> >>
> >> >> >> Should your '=' be a '+' or '&'.
> >> >> >>
> >> >> >> Kerrie
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I believe this is the solution. The trick is making sure you end up with the
single quotes in the right place. You are assembling a string.
="javascript:void(window.open('http://zxy/till.asp?MainID=" +
Fields!Mark2.Value + "','_blank'))"
The below is what you do so it puts in the appropriate value for your report
server and you don't have to hard code it. But it is for calling a report
which is not what you are doing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
> Bruce can you split the lenght string and explain each part. So, that i
> have
> clarity on what i am trying to implement where.
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> Thanks
> Navin
> "Bruce L-C [MVP]" wrote:
>> You haven't even tried what I suggested have you? Have you put the
>> expression in a text box and then run the report and look at the
>> resulting
>> string? Did you look at how I assembled a working expression and then
>> look
>> at your and see what you did wrong.
>> I help people learn. You don't seem to care to learn. Oh well.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
>> >I dont want to guess anything any more i have seen all the hyperlink
>> >answers
>> > you have the same post you give out the same string as below:
>> >
>> > Here is an example that works (it is calling a report rather than an
>> > asp
>> > page but the idea is the same).
>> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> >
>> > Why dont you correct my string and send sir.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Guess what. I can tell you exactly what is wrong here. You are not
>> >> assembling the string correctly. Do as I said and you will see exactly
>> >> what
>> >> you are doing wrong. Put this expression as the source of a textbox so
>> >> you
>> >> can see what is happening.
>> >>
>> >> Here is an example that works (it is calling a report rather than an
>> >> asp
>> >> page but the idea is the same).
>> >> ="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
>> >>
>> >>
>> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
>> >> > Intially i was using the following link which work very fine taking
>> >> > the
>> >> > value
>> >> > which is for mark2.
>> >> >
>> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
>> >> >
>> >> > when i click on link it would open as
>> >> > http://zxy/till.asp?MainID=20075
>> >> >
>> >> > which open in the same window now i want to open in new window
>> >> > instead
>> >> > of
>> >> > same window.
>> >> >
>> >> >
>> >> >
>> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
>> >> > Fields!Mark2.Value,'_blank'))"
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> What I suggest you do is create a textbox. Put this expression in
>> >> >> the
>> >> >> text
>> >> >> box. View the report and look at it. What is happening is that you
>> >> >> are
>> >> >> not
>> >> >> assembling the string properly.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
>> >> >> >
>> >> >> > Sorry inspite of that it dont work. :-(
>> >> >> >
>> >> >> > "Kerrie" wrote:
>> >> >> >
>> >> >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com>
>> >> >> >> wrote:
>> >> >> >> > I am trying to provide hyperlink with parameter, to open up in
>> >> >> >> > new
>> >> >> >> > window by
>> >> >> >> > the following url
>> >> >> >> >
>> >> >> >> > ="javascript:void(window.open(
>> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
>> >> >> >> >
>> >> >> >> > MArk2.value is a field from query in a dataset, I tried give
>> >> >> >> > the
>> >> >> >> > parameter
>> >> >> >> > mark2.value but get errors in javascript as expected '('
>> >> >> >> >
>> >> >> >> > Can i get new window code with parameter so that i can
>> >> >> >> > implement.
>> >> >> >> >
>> >> >> >> > I am using it in text box advanced navigate url.
>> >> >> >> >
>> >> >> >> > Regards,
>> >> >> >> > Navin
>> >> >> >>
>> >> >> >> Should your '=' be a '+' or '&'.
>> >> >> >>
>> >> >> >> Kerrie
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||perfect it works with [& instead of + for me]
="javascript:void(window.open('http://zxy/till.asp?MainID=" &
Fields!Mark2.Value & "','_blank'))"
Bruce all might thanks.
"Bruce L-C [MVP]" wrote:
> I believe this is the solution. The trick is making sure you end up with the
> single quotes in the right place. You are assembling a string.
> ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
> Fields!Mark2.Value + "','_blank'))"
> The below is what you do so it puts in the appropriate value for your report
> server and you don't have to hard code it. But it is for calling a report
> which is not what you are doing.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
> > Bruce can you split the lenght string and explain each part. So, that i
> > have
> > clarity on what i am trying to implement where.
> >
> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >
> > Thanks
> > Navin
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You haven't even tried what I suggested have you? Have you put the
> >> expression in a text box and then run the report and look at the
> >> resulting
> >> string? Did you look at how I assembled a working expression and then
> >> look
> >> at your and see what you did wrong.
> >>
> >> I help people learn. You don't seem to care to learn. Oh well.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
> >> >I dont want to guess anything any more i have seen all the hyperlink
> >> >answers
> >> > you have the same post you give out the same string as below:
> >> >
> >> > Here is an example that works (it is calling a report rather than an
> >> > asp
> >> > page but the idea is the same).
> >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >> >
> >> > Why dont you correct my string and send sir.
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Guess what. I can tell you exactly what is wrong here. You are not
> >> >> assembling the string correctly. Do as I said and you will see exactly
> >> >> what
> >> >> you are doing wrong. Put this expression as the source of a textbox so
> >> >> you
> >> >> can see what is happening.
> >> >>
> >> >> Here is an example that works (it is calling a report rather than an
> >> >> asp
> >> >> page but the idea is the same).
> >> >> ="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
> >> >>
> >> >>
> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> >> >> > Intially i was using the following link which work very fine taking
> >> >> > the
> >> >> > value
> >> >> > which is for mark2.
> >> >> >
> >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> >> >> >
> >> >> > when i click on link it would open as
> >> >> > http://zxy/till.asp?MainID=20075
> >> >> >
> >> >> > which open in the same window now i want to open in new window
> >> >> > instead
> >> >> > of
> >> >> > same window.
> >> >> >
> >> >> >
> >> >> >
> >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
> >> >> > Fields!Mark2.Value,'_blank'))"
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> What I suggest you do is create a textbox. Put this expression in
> >> >> >> the
> >> >> >> text
> >> >> >> box. View the report and look at it. What is happening is that you
> >> >> >> are
> >> >> >> not
> >> >> >> assembling the string properly.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> >> >> >> >
> >> >> >> > Sorry inspite of that it dont work. :-(
> >> >> >> >
> >> >> >> > "Kerrie" wrote:
> >> >> >> >
> >> >> >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com>
> >> >> >> >> wrote:
> >> >> >> >> > I am trying to provide hyperlink with parameter, to open up in
> >> >> >> >> > new
> >> >> >> >> > window by
> >> >> >> >> > the following url
> >> >> >> >> >
> >> >> >> >> > ="javascript:void(window.open(
> >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> >> >> >> >> >
> >> >> >> >> > MArk2.value is a field from query in a dataset, I tried give
> >> >> >> >> > the
> >> >> >> >> > parameter
> >> >> >> >> > mark2.value but get errors in javascript as expected '('
> >> >> >> >> >
> >> >> >> >> > Can i get new window code with parameter so that i can
> >> >> >> >> > implement.
> >> >> >> >> >
> >> >> >> >> > I am using it in text box advanced navigate url.
> >> >> >> >> >
> >> >> >> >> > Regards,
> >> >> >> >> > Navin
> >> >> >> >>
> >> >> >> >> Should your '=' be a '+' or '&'.
> >> >> >> >>
> >> >> >> >> Kerrie
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Bruce,
We use subscription [Web archive] to send the report. When i provide the
link it works properly when u access through report server link. But it
theows error message instead of opening the link. An work arounds to avoid it.
Regards,
Navin
When users try to click the link
"Bruce L-C [MVP]" wrote:
> I believe this is the solution. The trick is making sure you end up with the
> single quotes in the right place. You are assembling a string.
> ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
> Fields!Mark2.Value + "','_blank'))"
> The below is what you do so it puts in the appropriate value for your report
> server and you don't have to hard code it. But it is for calling a report
> which is not what you are doing.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
> > Bruce can you split the lenght string and explain each part. So, that i
> > have
> > clarity on what i am trying to implement where.
> >
> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >
> > Thanks
> > Navin
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You haven't even tried what I suggested have you? Have you put the
> >> expression in a text box and then run the report and look at the
> >> resulting
> >> string? Did you look at how I assembled a working expression and then
> >> look
> >> at your and see what you did wrong.
> >>
> >> I help people learn. You don't seem to care to learn. Oh well.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
> >> >I dont want to guess anything any more i have seen all the hyperlink
> >> >answers
> >> > you have the same post you give out the same string as below:
> >> >
> >> > Here is an example that works (it is calling a report rather than an
> >> > asp
> >> > page but the idea is the same).
> >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >> >
> >> > Why dont you correct my string and send sir.
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Guess what. I can tell you exactly what is wrong here. You are not
> >> >> assembling the string correctly. Do as I said and you will see exactly
> >> >> what
> >> >> you are doing wrong. Put this expression as the source of a textbox so
> >> >> you
> >> >> can see what is happening.
> >> >>
> >> >> Here is an example that works (it is calling a report rather than an
> >> >> asp
> >> >> page but the idea is the same).
> >> >> ="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
> >> >>
> >> >>
> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> >> >> > Intially i was using the following link which work very fine taking
> >> >> > the
> >> >> > value
> >> >> > which is for mark2.
> >> >> >
> >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> >> >> >
> >> >> > when i click on link it would open as
> >> >> > http://zxy/till.asp?MainID=20075
> >> >> >
> >> >> > which open in the same window now i want to open in new window
> >> >> > instead
> >> >> > of
> >> >> > same window.
> >> >> >
> >> >> >
> >> >> >
> >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
> >> >> > Fields!Mark2.Value,'_blank'))"
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> What I suggest you do is create a textbox. Put this expression in
> >> >> >> the
> >> >> >> text
> >> >> >> box. View the report and look at it. What is happening is that you
> >> >> >> are
> >> >> >> not
> >> >> >> assembling the string properly.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> >> >> >> >
> >> >> >> > Sorry inspite of that it dont work. :-(
> >> >> >> >
> >> >> >> > "Kerrie" wrote:
> >> >> >> >
> >> >> >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com>
> >> >> >> >> wrote:
> >> >> >> >> > I am trying to provide hyperlink with parameter, to open up in
> >> >> >> >> > new
> >> >> >> >> > window by
> >> >> >> >> > the following url
> >> >> >> >> >
> >> >> >> >> > ="javascript:void(window.open(
> >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> >> >> >> >> >
> >> >> >> >> > MArk2.value is a field from query in a dataset, I tried give
> >> >> >> >> > the
> >> >> >> >> > parameter
> >> >> >> >> > mark2.value but get errors in javascript as expected '('
> >> >> >> >> >
> >> >> >> >> > Can i get new window code with parameter so that i can
> >> >> >> >> > implement.
> >> >> >> >> >
> >> >> >> >> > I am using it in text box advanced navigate url.
> >> >> >> >> >
> >> >> >> >> > Regards,
> >> >> >> >> > Navin
> >> >> >> >>
> >> >> >> >> Should your '=' be a '+' or '&'.
> >> >> >> >>
> >> >> >> >> Kerrie
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Sorry, I have not heard of this problem before. All my links still work when
I email the reports (I also use Web archive when emailing my reports).
Can't help you with this I am afraid.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
news:3F3A0D79-FB21-43C9-B478-04BB3F91B930@.microsoft.com...
> Bruce,
> We use subscription [Web archive] to send the report. When i provide the
> link it works properly when u access through report server link. But it
> theows error message instead of opening the link. An work arounds to avoid
> it.
> Regards,
> Navin
> When users try to click the link
> "Bruce L-C [MVP]" wrote:
>> I believe this is the solution. The trick is making sure you end up with
>> the
>> single quotes in the right place. You are assembling a string.
>> ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
>> Fields!Mark2.Value + "','_blank'))"
>> The below is what you do so it puts in the appropriate value for your
>> report
>> server and you don't have to hard code it. But it is for calling a report
>> which is not what you are doing.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
>> > Bruce can you split the lenght string and explain each part. So, that i
>> > have
>> > clarity on what i am trying to implement where.
>> >
>> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> >
>> > Thanks
>> > Navin
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> You haven't even tried what I suggested have you? Have you put the
>> >> expression in a text box and then run the report and look at the
>> >> resulting
>> >> string? Did you look at how I assembled a working expression and then
>> >> look
>> >> at your and see what you did wrong.
>> >>
>> >> I help people learn. You don't seem to care to learn. Oh well.
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
>> >> >I dont want to guess anything any more i have seen all the hyperlink
>> >> >answers
>> >> > you have the same post you give out the same string as below:
>> >> >
>> >> > Here is an example that works (it is calling a report rather than an
>> >> > asp
>> >> > page but the idea is the same).
>> >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> >> >
>> >> > Why dont you correct my string and send sir.
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Guess what. I can tell you exactly what is wrong here. You are not
>> >> >> assembling the string correctly. Do as I said and you will see
>> >> >> exactly
>> >> >> what
>> >> >> you are doing wrong. Put this expression as the source of a textbox
>> >> >> so
>> >> >> you
>> >> >> can see what is happening.
>> >> >>
>> >> >> Here is an example that works (it is calling a report rather than
>> >> >> an
>> >> >> asp
>> >> >> page but the idea is the same).
>> >> >> ="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
>> >> >>
>> >> >>
>> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
>> >> >> > Intially i was using the following link which work very fine
>> >> >> > taking
>> >> >> > the
>> >> >> > value
>> >> >> > which is for mark2.
>> >> >> >
>> >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
>> >> >> >
>> >> >> > when i click on link it would open as
>> >> >> > http://zxy/till.asp?MainID=20075
>> >> >> >
>> >> >> > which open in the same window now i want to open in new window
>> >> >> > instead
>> >> >> > of
>> >> >> > same window.
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
>> >> >> > Fields!Mark2.Value,'_blank'))"
>> >> >> >
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> What I suggest you do is create a textbox. Put this expression
>> >> >> >> in
>> >> >> >> the
>> >> >> >> text
>> >> >> >> box. View the report and look at it. What is happening is that
>> >> >> >> you
>> >> >> >> are
>> >> >> >> not
>> >> >> >> assembling the string properly.
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
>> >> >> >> >
>> >> >> >> > Sorry inspite of that it dont work. :-(
>> >> >> >> >
>> >> >> >> > "Kerrie" wrote:
>> >> >> >> >
>> >> >> >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com>
>> >> >> >> >> wrote:
>> >> >> >> >> > I am trying to provide hyperlink with parameter, to open up
>> >> >> >> >> > in
>> >> >> >> >> > new
>> >> >> >> >> > window by
>> >> >> >> >> > the following url
>> >> >> >> >> >
>> >> >> >> >> > ="javascript:void(window.open(
>> >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
>> >> >> >> >> >
>> >> >> >> >> > MArk2.value is a field from query in a dataset, I tried
>> >> >> >> >> > give
>> >> >> >> >> > the
>> >> >> >> >> > parameter
>> >> >> >> >> > mark2.value but get errors in javascript as expected '('
>> >> >> >> >> >
>> >> >> >> >> > Can i get new window code with parameter so that i can
>> >> >> >> >> > implement.
>> >> >> >> >> >
>> >> >> >> >> > I am using it in text box advanced navigate url.
>> >> >> >> >> >
>> >> >> >> >> > Regards,
>> >> >> >> >> > Navin
>> >> >> >> >>
>> >> >> >> >> Should your '=' be a '+' or '&'.
>> >> >> >> >>
>> >> >> >> >> Kerrie
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||May I know if this works fine in RS 2000 with SP1?
I always get the error message: URLs in reports may only use http://,
https:// etc..
Thanks.
"NAVIN.D" wrote:
> perfect it works with [& instead of + for me]
> ="javascript:void(window.open('http://zxy/till.asp?MainID=" &
> Fields!Mark2.Value & "','_blank'))"
> Bruce all might thanks.
>
> "Bruce L-C [MVP]" wrote:
> > I believe this is the solution. The trick is making sure you end up with the
> > single quotes in the right place. You are assembling a string.
> >
> > ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
> > Fields!Mark2.Value + "','_blank'))"
> >
> > The below is what you do so it puts in the appropriate value for your report
> > server and you don't have to hard code it. But it is for calling a report
> > which is not what you are doing.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> > news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
> > > Bruce can you split the lenght string and explain each part. So, that i
> > > have
> > > clarity on what i am trying to implement where.
> > >
> > > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> > >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> > >
> > > Thanks
> > > Navin
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> You haven't even tried what I suggested have you? Have you put the
> > >> expression in a text box and then run the report and look at the
> > >> resulting
> > >> string? Did you look at how I assembled a working expression and then
> > >> look
> > >> at your and see what you did wrong.
> > >>
> > >> I help people learn. You don't seem to care to learn. Oh well.
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> > >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
> > >> >I dont want to guess anything any more i have seen all the hyperlink
> > >> >answers
> > >> > you have the same post you give out the same string as below:
> > >> >
> > >> > Here is an example that works (it is calling a report rather than an
> > >> > asp
> > >> > page but the idea is the same).
> > >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> > >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> > >> >
> > >> > Why dont you correct my string and send sir.
> > >> >
> > >> > "Bruce L-C [MVP]" wrote:
> > >> >
> > >> >> Guess what. I can tell you exactly what is wrong here. You are not
> > >> >> assembling the string correctly. Do as I said and you will see exactly
> > >> >> what
> > >> >> you are doing wrong. Put this expression as the source of a textbox so
> > >> >> you
> > >> >> can see what is happening.
> > >> >>
> > >> >> Here is an example that works (it is calling a report rather than an
> > >> >> asp
> > >> >> page but the idea is the same).
> > >> >> ="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
> > >> >>
> > >> >>
> > >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> > >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> > >> >> > Intially i was using the following link which work very fine taking
> > >> >> > the
> > >> >> > value
> > >> >> > which is for mark2.
> > >> >> >
> > >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> > >> >> >
> > >> >> > when i click on link it would open as
> > >> >> > http://zxy/till.asp?MainID=20075
> > >> >> >
> > >> >> > which open in the same window now i want to open in new window
> > >> >> > instead
> > >> >> > of
> > >> >> > same window.
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
> > >> >> > Fields!Mark2.Value,'_blank'))"
> > >> >> >
> > >> >> >
> > >> >> > "Bruce L-C [MVP]" wrote:
> > >> >> >
> > >> >> >> What I suggest you do is create a textbox. Put this expression in
> > >> >> >> the
> > >> >> >> text
> > >> >> >> box. View the report and look at it. What is happening is that you
> > >> >> >> are
> > >> >> >> not
> > >> >> >> assembling the string properly.
> > >> >> >>
> > >> >> >>
> > >> >> >> --
> > >> >> >> Bruce Loehle-Conger
> > >> >> >> MVP SQL Server Reporting Services
> > >> >> >>
> > >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> > >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> > >> >> >> >
> > >> >> >> > Sorry inspite of that it dont work. :-(
> > >> >> >> >
> > >> >> >> > "Kerrie" wrote:
> > >> >> >> >
> > >> >> >> >> On Feb 1, 5:08 am, NAVIN.D <NAV...@.discussions.microsoft.com>
> > >> >> >> >> wrote:
> > >> >> >> >> > I am trying to provide hyperlink with parameter, to open up in
> > >> >> >> >> > new
> > >> >> >> >> > window by
> > >> >> >> >> > the following url
> > >> >> >> >> >
> > >> >> >> >> > ="javascript:void(window.open(
> > >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> > >> >> >> >> >
> > >> >> >> >> > MArk2.value is a field from query in a dataset, I tried give
> > >> >> >> >> > the
> > >> >> >> >> > parameter
> > >> >> >> >> > mark2.value but get errors in javascript as expected '('
> > >> >> >> >> >
> > >> >> >> >> > Can i get new window code with parameter so that i can
> > >> >> >> >> > implement.
> > >> >> >> >> >
> > >> >> >> >> > I am using it in text box advanced navigate url.
> > >> >> >> >> >
> > >> >> >> >> > Regards,
> > >> >> >> >> > Navin
> > >> >> >> >>
> > >> >> >> >> Should your '=' be a '+' or '&'.
> > >> >> >> >>
> > >> >> >> >> Kerrie
> > >> >> >> >>
> > >> >> >> >>
> > >> >> >>
> > >> >> >>
> > >> >> >>
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >|||Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
If you want to go to another website then do this:
= "javascript:void(window.open('http://www.google.com'))"
For any of these with window.open to work you have to have 2000 sp1 or
greater installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sammy" <sammy@.discussions.microsoft.com> wrote in message
news:040FADAB-6F34-4CDD-BC56-9AD5DC53F2E5@.microsoft.com...
> May I know if this works fine in RS 2000 with SP1?
> I always get the error message: URLs in reports may only use http://,
> https:// etc..
> Thanks.
> "NAVIN.D" wrote:
>> perfect it works with [& instead of + for me]
>> ="javascript:void(window.open('http://zxy/till.asp?MainID=" &
>> Fields!Mark2.Value & "','_blank'))"
>> Bruce all might thanks.
>>
>> "Bruce L-C [MVP]" wrote:
>> > I believe this is the solution. The trick is making sure you end up
>> > with the
>> > single quotes in the right place. You are assembling a string.
>> >
>> > ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
>> > Fields!Mark2.Value + "','_blank'))"
>> >
>> > The below is what you do so it puts in the appropriate value for your
>> > report
>> > server and you don't have to hard code it. But it is for calling a
>> > report
>> > which is not what you are doing.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> > news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
>> > > Bruce can you split the lenght string and explain each part. So, that
>> > > i
>> > > have
>> > > clarity on what i am trying to implement where.
>> > >
>> > > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> > >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value
>> > >> > &
>> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> > >
>> > > Thanks
>> > > Navin
>> > >
>> > > "Bruce L-C [MVP]" wrote:
>> > >
>> > >> You haven't even tried what I suggested have you? Have you put the
>> > >> expression in a text box and then run the report and look at the
>> > >> resulting
>> > >> string? Did you look at how I assembled a working expression and
>> > >> then
>> > >> look
>> > >> at your and see what you did wrong.
>> > >>
>> > >> I help people learn. You don't seem to care to learn. Oh well.
>> > >>
>> > >> --
>> > >> Bruce Loehle-Conger
>> > >> MVP SQL Server Reporting Services
>> > >>
>> > >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> > >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
>> > >> >I dont want to guess anything any more i have seen all the
>> > >> >hyperlink
>> > >> >answers
>> > >> > you have the same post you give out the same string as below:
>> > >> >
>> > >> > Here is an example that works (it is calling a report rather than
>> > >> > an
>> > >> > asp
>> > >> > page but the idea is the same).
>> > >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> > >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value
>> > >> > &
>> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> > >> >
>> > >> > Why dont you correct my string and send sir.
>> > >> >
>> > >> > "Bruce L-C [MVP]" wrote:
>> > >> >
>> > >> >> Guess what. I can tell you exactly what is wrong here. You are
>> > >> >> not
>> > >> >> assembling the string correctly. Do as I said and you will see
>> > >> >> exactly
>> > >> >> what
>> > >> >> you are doing wrong. Put this expression as the source of a
>> > >> >> textbox so
>> > >> >> you
>> > >> >> can see what is happening.
>> > >> >>
>> > >> >> Here is an example that works (it is calling a report rather than
>> > >> >> an
>> > >> >> asp
>> > >> >> page but the idea is the same).
>> > >> >> ="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
>> > >> >>
>> > >> >>
>> > >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> > >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
>> > >> >> > Intially i was using the following link which work very fine
>> > >> >> > taking
>> > >> >> > the
>> > >> >> > value
>> > >> >> > which is for mark2.
>> > >> >> >
>> > >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
>> > >> >> >
>> > >> >> > when i click on link it would open as
>> > >> >> > http://zxy/till.asp?MainID=20075
>> > >> >> >
>> > >> >> > which open in the same window now i want to open in new window
>> > >> >> > instead
>> > >> >> > of
>> > >> >> > same window.
>> > >> >> >
>> > >> >> >
>> > >> >> >
>> > >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
>> > >> >> > Fields!Mark2.Value,'_blank'))"
>> > >> >> >
>> > >> >> >
>> > >> >> > "Bruce L-C [MVP]" wrote:
>> > >> >> >
>> > >> >> >> What I suggest you do is create a textbox. Put this expression
>> > >> >> >> in
>> > >> >> >> the
>> > >> >> >> text
>> > >> >> >> box. View the report and look at it. What is happening is that
>> > >> >> >> you
>> > >> >> >> are
>> > >> >> >> not
>> > >> >> >> assembling the string properly.
>> > >> >> >>
>> > >> >> >>
>> > >> >> >> --
>> > >> >> >> Bruce Loehle-Conger
>> > >> >> >> MVP SQL Server Reporting Services
>> > >> >> >>
>> > >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> > >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
>> > >> >> >> >
>> > >> >> >> > Sorry inspite of that it dont work. :-(
>> > >> >> >> >
>> > >> >> >> > "Kerrie" wrote:
>> > >> >> >> >
>> > >> >> >> >> On Feb 1, 5:08 am, NAVIN.D
>> > >> >> >> >> <NAV...@.discussions.microsoft.com>
>> > >> >> >> >> wrote:
>> > >> >> >> >> > I am trying to provide hyperlink with parameter, to open
>> > >> >> >> >> > up in
>> > >> >> >> >> > new
>> > >> >> >> >> > window by
>> > >> >> >> >> > the following url
>> > >> >> >> >> >
>> > >> >> >> >> > ="javascript:void(window.open(
>> > >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
>> > >> >> >> >> >
>> > >> >> >> >> > MArk2.value is a field from query in a dataset, I tried
>> > >> >> >> >> > give
>> > >> >> >> >> > the
>> > >> >> >> >> > parameter
>> > >> >> >> >> > mark2.value but get errors in javascript as expected '('
>> > >> >> >> >> >
>> > >> >> >> >> > Can i get new window code with parameter so that i can
>> > >> >> >> >> > implement.
>> > >> >> >> >> >
>> > >> >> >> >> > I am using it in text box advanced navigate url.
>> > >> >> >> >> >
>> > >> >> >> >> > Regards,
>> > >> >> >> >> > Navin
>> > >> >> >> >>
>> > >> >> >> >> Should your '=' be a '+' or '&'.
>> > >> >> >> >>
>> > >> >> >> >> Kerrie
>> > >> >> >> >>
>> > >> >> >> >>
>> > >> >> >>
>> > >> >> >>
>> > >> >> >>
>> > >> >>
>> > >> >>
>> > >> >>
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >|||Thanks Bruce for your reply.
Unfortunately, I still cannot get my result. I have a table in which one
textbox cell I wish to set hyperlink which open in new window. I've tried
this: The textbox value is a hard code value, its action is Jump to url with
the expression you gave. ="javascript:void(window.open('http://www.google.com'))"
Though I get error from preview, i still deployed the report and tested from
IE. However, the report cannot be displayed. I got the below page. Seems like
it treats the "javascript:void..." as URL. It can only recognise if I started
with "http://". What is the problem? Need setting for Javascript? My SQL
Server version is 2000 with SP1.
Reporting Services Erro
----
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
The url javascript:void(window.open('http://www.google.com')) has an invalid
schema. URLs in reports may only use http://, https://, ftp://, mailto: or
news: (rsUnsupportedURLProtocol) Get Online Help
----
Microsoft Reporting Services
Thanks a lot!
"Bruce L-C [MVP]" wrote:
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
> If you want to go to another website then do this:
> = "javascript:void(window.open('http://www.google.com'))"
> For any of these with window.open to work you have to have 2000 sp1 or
> greater installed.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sammy" <sammy@.discussions.microsoft.com> wrote in message
> news:040FADAB-6F34-4CDD-BC56-9AD5DC53F2E5@.microsoft.com...
> > May I know if this works fine in RS 2000 with SP1?
> > I always get the error message: URLs in reports may only use http://,
> > https:// etc..
> >
> > Thanks.
> >
> > "NAVIN.D" wrote:
> >
> >>
> >> perfect it works with [& instead of + for me]
> >> ="javascript:void(window.open('http://zxy/till.asp?MainID=" &
> >> Fields!Mark2.Value & "','_blank'))"
> >>
> >> Bruce all might thanks.
> >>
> >>
> >> "Bruce L-C [MVP]" wrote:
> >>
> >> > I believe this is the solution. The trick is making sure you end up
> >> > with the
> >> > single quotes in the right place. You are assembling a string.
> >> >
> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
> >> > Fields!Mark2.Value + "','_blank'))"
> >> >
> >> > The below is what you do so it puts in the appropriate value for your
> >> > report
> >> > server and you don't have to hard code it. But it is for calling a
> >> > report
> >> > which is not what you are doing.
> >> >
> >> >
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> >
> >> > "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> > news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
> >> > > Bruce can you split the lenght string and explain each part. So, that
> >> > > i
> >> > > have
> >> > > clarity on what i am trying to implement where.
> >> > >
> >> > > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> > >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value
> >> > >> > &
> >> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >> > >
> >> > > Thanks
> >> > > Navin
> >> > >
> >> > > "Bruce L-C [MVP]" wrote:
> >> > >
> >> > >> You haven't even tried what I suggested have you? Have you put the
> >> > >> expression in a text box and then run the report and look at the
> >> > >> resulting
> >> > >> string? Did you look at how I assembled a working expression and
> >> > >> then
> >> > >> look
> >> > >> at your and see what you did wrong.
> >> > >>
> >> > >> I help people learn. You don't seem to care to learn. Oh well.
> >> > >>
> >> > >> --
> >> > >> Bruce Loehle-Conger
> >> > >> MVP SQL Server Reporting Services
> >> > >>
> >> > >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> > >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
> >> > >> >I dont want to guess anything any more i have seen all the
> >> > >> >hyperlink
> >> > >> >answers
> >> > >> > you have the same post you give out the same string as below:
> >> > >> >
> >> > >> > Here is an example that works (it is calling a report rather than
> >> > >> > an
> >> > >> > asp
> >> > >> > page but the idea is the same).
> >> > >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> > >> > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value
> >> > >> > &
> >> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >> > >> >
> >> > >> > Why dont you correct my string and send sir.
> >> > >> >
> >> > >> > "Bruce L-C [MVP]" wrote:
> >> > >> >
> >> > >> >> Guess what. I can tell you exactly what is wrong here. You are
> >> > >> >> not
> >> > >> >> assembling the string correctly. Do as I said and you will see
> >> > >> >> exactly
> >> > >> >> what
> >> > >> >> you are doing wrong. Put this expression as the source of a
> >> > >> >> textbox so
> >> > >> >> you
> >> > >> >> can see what is happening.
> >> > >> >>
> >> > >> >> Here is an example that works (it is calling a report rather than
> >> > >> >> an
> >> > >> >> asp
> >> > >> >> page but the idea is the same).
> >> > >> >> ="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
> >> > >> >>
> >> > >> >>
> >> > >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> > >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> >> > >> >> > Intially i was using the following link which work very fine
> >> > >> >> > taking
> >> > >> >> > the
> >> > >> >> > value
> >> > >> >> > which is for mark2.
> >> > >> >> >
> >> > >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> >> > >> >> >
> >> > >> >> > when i click on link it would open as
> >> > >> >> > http://zxy/till.asp?MainID=20075
> >> > >> >> >
> >> > >> >> > which open in the same window now i want to open in new window
> >> > >> >> > instead
> >> > >> >> > of
> >> > >> >> > same window.
> >> > >> >> >
> >> > >> >> >
> >> > >> >> >
> >> > >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=' +
> >> > >> >> > Fields!Mark2.Value,'_blank'))"
> >> > >> >> >
> >> > >> >> >
> >> > >> >> > "Bruce L-C [MVP]" wrote:
> >> > >> >> >
> >> > >> >> >> What I suggest you do is create a textbox. Put this expression
> >> > >> >> >> in
> >> > >> >> >> the
> >> > >> >> >> text
> >> > >> >> >> box. View the report and look at it. What is happening is that
> >> > >> >> >> you
> >> > >> >> >> are
> >> > >> >> >> not
> >> > >> >> >> assembling the string properly.
> >> > >> >> >>
> >> > >> >> >>
> >> > >> >> >> --
> >> > >> >> >> Bruce Loehle-Conger
> >> > >> >> >> MVP SQL Server Reporting Services
> >> > >> >> >>
> >> > >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> > >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> >> > >> >> >> >
> >> > >> >> >> > Sorry inspite of that it dont work. :-(
> >> > >> >> >> >
> >> > >> >> >> > "Kerrie" wrote:
> >> > >> >> >> >
> >> > >> >> >> >> On Feb 1, 5:08 am, NAVIN.D
> >> > >> >> >> >> <NAV...@.discussions.microsoft.com>
> >> > >> >> >> >> wrote:
> >> > >> >> >> >> > I am trying to provide hyperlink with parameter, to open
> >> > >> >> >> >> > up in
> >> > >> >> >> >> > new
> >> > >> >> >> >> > window by
> >> > >> >> >> >> > the following url
> >> > >> >> >> >> >
> >> > >> >> >> >> > ="javascript:void(window.open(
> >> > >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> >> > >> >> >> >> >
> >> > >> >> >> >> > MArk2.value is a field from query in a dataset, I tried
> >> > >> >> >> >> > give
> >> > >> >> >> >> > the
> >> > >> >> >> >> > parameter
> >> > >> >> >> >> > mark2.value but get errors in javascript as expected '('
> >> > >> >> >> >> >
> >> > >> >> >> >> > Can i get new window code with parameter so that i can
> >> > >> >> >> >> > implement.
> >> > >> >> >> >> >
> >> > >> >> >> >> > I am using it in text box advanced navigate url.
> >> > >> >> >> >> >
> >> > >> >> >> >> > Regards,
> >> > >> >> >> >> > Navin
> >> > >> >> >> >>
> >> > >> >> >> >> Should your '=' be a '+' or '&'.
> >> > >> >> >> >>
> >> > >> >> >> >> Kerrie
> >> > >> >> >> >>
> >> > >> >> >> >>
> >> > >> >> >>
> >> > >> >> >>
> >> > >> >> >>
> >> > >> >>
> >> > >> >>
> >> > >> >>
> >> > >>
> >> > >>
> >> > >>
> >> >
> >> >
> >> >
>
>|||Check the version of RS (when you say you have SQL Server I assume you mean
reporting services since SQL Server DB should be SP3a at least). To check
the version go to http://MyServerName/ReportServer
Also, did you upgrade both the development box as well as the server with
SP1. You need to do this for SP1.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sammy" <sammy@.discussions.microsoft.com> wrote in message
news:640BB5FF-3B40-4F5D-A626-0D440269E357@.microsoft.com...
> Thanks Bruce for your reply.
> Unfortunately, I still cannot get my result. I have a table in which one
> textbox cell I wish to set hyperlink which open in new window. I've tried
> this: The textbox value is a hard code value, its action is Jump to url
> with
> the expression you gave. => "javascript:void(window.open('http://www.google.com'))"
> Though I get error from preview, i still deployed the report and tested
> from
> IE. However, the report cannot be displayed. I got the below page. Seems
> like
> it treats the "javascript:void..." as URL. It can only recognise if I
> started
> with "http://". What is the problem? Need setting for Javascript? My SQL
> Server version is 2000 with SP1.
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> The url javascript:void(window.open('http://www.google.com')) has an
> invalid
> schema. URLs in reports may only use http://, https://, ftp://, mailto: or
> news: (rsUnsupportedURLProtocol) Get Online Help
> ----
> Microsoft Reporting Services
> Thanks a lot!
>
> "Bruce L-C [MVP]" wrote:
>> Here is an example of a Jump to URL link I use. This causes Excel to come
>> up
>> with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> If you don't want to have it appear in a new window then do this in jump
>> to
>> URL:
>> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> If you want to go to another website then do this:
>> = "javascript:void(window.open('http://www.google.com'))"
>> For any of these with window.open to work you have to have 2000 sp1 or
>> greater installed.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "sammy" <sammy@.discussions.microsoft.com> wrote in message
>> news:040FADAB-6F34-4CDD-BC56-9AD5DC53F2E5@.microsoft.com...
>> > May I know if this works fine in RS 2000 with SP1?
>> > I always get the error message: URLs in reports may only use http://,
>> > https:// etc..
>> >
>> > Thanks.
>> >
>> > "NAVIN.D" wrote:
>> >
>> >>
>> >> perfect it works with [& instead of + for me]
>> >> ="javascript:void(window.open('http://zxy/till.asp?MainID=" &
>> >> Fields!Mark2.Value & "','_blank'))"
>> >>
>> >> Bruce all might thanks.
>> >>
>> >>
>> >> "Bruce L-C [MVP]" wrote:
>> >>
>> >> > I believe this is the solution. The trick is making sure you end up
>> >> > with the
>> >> > single quotes in the right place. You are assembling a string.
>> >> >
>> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
>> >> > Fields!Mark2.Value + "','_blank'))"
>> >> >
>> >> > The below is what you do so it puts in the appropriate value for
>> >> > your
>> >> > report
>> >> > server and you don't have to hard code it. But it is for calling a
>> >> > report
>> >> > which is not what you are doing.
>> >> >
>> >> >
>> >> > --
>> >> > Bruce Loehle-Conger
>> >> > MVP SQL Server Reporting Services
>> >> >
>> >> > "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> > news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
>> >> > > Bruce can you split the lenght string and explain each part. So,
>> >> > > that
>> >> > > i
>> >> > > have
>> >> > > clarity on what i am trying to implement where.
>> >> > >
>> >> > > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> > >> > "?/SomeFolder/SomeReport&ParamName=" &
>> >> > >> > Parameters!ParamName.Value
>> >> > >> > &
>> >> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> >> > >
>> >> > > Thanks
>> >> > > Navin
>> >> > >
>> >> > > "Bruce L-C [MVP]" wrote:
>> >> > >
>> >> > >> You haven't even tried what I suggested have you? Have you put
>> >> > >> the
>> >> > >> expression in a text box and then run the report and look at the
>> >> > >> resulting
>> >> > >> string? Did you look at how I assembled a working expression and
>> >> > >> then
>> >> > >> look
>> >> > >> at your and see what you did wrong.
>> >> > >>
>> >> > >> I help people learn. You don't seem to care to learn. Oh well.
>> >> > >>
>> >> > >> --
>> >> > >> Bruce Loehle-Conger
>> >> > >> MVP SQL Server Reporting Services
>> >> > >>
>> >> > >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> > >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
>> >> > >> >I dont want to guess anything any more i have seen all the
>> >> > >> >hyperlink
>> >> > >> >answers
>> >> > >> > you have the same post you give out the same string as below:
>> >> > >> >
>> >> > >> > Here is an example that works (it is calling a report rather
>> >> > >> > than
>> >> > >> > an
>> >> > >> > asp
>> >> > >> > page but the idea is the same).
>> >> > >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> > >> > "?/SomeFolder/SomeReport&ParamName=" &
>> >> > >> > Parameters!ParamName.Value
>> >> > >> > &
>> >> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> >> > >> >
>> >> > >> > Why dont you correct my string and send sir.
>> >> > >> >
>> >> > >> > "Bruce L-C [MVP]" wrote:
>> >> > >> >
>> >> > >> >> Guess what. I can tell you exactly what is wrong here. You are
>> >> > >> >> not
>> >> > >> >> assembling the string correctly. Do as I said and you will see
>> >> > >> >> exactly
>> >> > >> >> what
>> >> > >> >> you are doing wrong. Put this expression as the source of a
>> >> > >> >> textbox so
>> >> > >> >> you
>> >> > >> >> can see what is happening.
>> >> > >> >>
>> >> > >> >> Here is an example that works (it is calling a report rather
>> >> > >> >> than
>> >> > >> >> an
>> >> > >> >> asp
>> >> > >> >> page but the idea is the same).
>> >> > >> >> ="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
>> >> > >> >>
>> >> > >> >>
>> >> > >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> > >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
>> >> > >> >> > Intially i was using the following link which work very fine
>> >> > >> >> > taking
>> >> > >> >> > the
>> >> > >> >> > value
>> >> > >> >> > which is for mark2.
>> >> > >> >> >
>> >> > >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
>> >> > >> >> >
>> >> > >> >> > when i click on link it would open as
>> >> > >> >> > http://zxy/till.asp?MainID=20075
>> >> > >> >> >
>> >> > >> >> > which open in the same window now i want to open in new
>> >> > >> >> > window
>> >> > >> >> > instead
>> >> > >> >> > of
>> >> > >> >> > same window.
>> >> > >> >> >
>> >> > >> >> >
>> >> > >> >> >
>> >> > >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID='
>> >> > >> >> > +
>> >> > >> >> > Fields!Mark2.Value,'_blank'))"
>> >> > >> >> >
>> >> > >> >> >
>> >> > >> >> > "Bruce L-C [MVP]" wrote:
>> >> > >> >> >
>> >> > >> >> >> What I suggest you do is create a textbox. Put this
>> >> > >> >> >> expression
>> >> > >> >> >> in
>> >> > >> >> >> the
>> >> > >> >> >> text
>> >> > >> >> >> box. View the report and look at it. What is happening is
>> >> > >> >> >> that
>> >> > >> >> >> you
>> >> > >> >> >> are
>> >> > >> >> >> not
>> >> > >> >> >> assembling the string properly.
>> >> > >> >> >>
>> >> > >> >> >>
>> >> > >> >> >> --
>> >> > >> >> >> Bruce Loehle-Conger
>> >> > >> >> >> MVP SQL Server Reporting Services
>> >> > >> >> >>
>> >> > >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in
>> >> > >> >> >> message
>> >> > >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
>> >> > >> >> >> >
>> >> > >> >> >> > Sorry inspite of that it dont work. :-(
>> >> > >> >> >> >
>> >> > >> >> >> > "Kerrie" wrote:
>> >> > >> >> >> >
>> >> > >> >> >> >> On Feb 1, 5:08 am, NAVIN.D
>> >> > >> >> >> >> <NAV...@.discussions.microsoft.com>
>> >> > >> >> >> >> wrote:
>> >> > >> >> >> >> > I am trying to provide hyperlink with parameter, to
>> >> > >> >> >> >> > open
>> >> > >> >> >> >> > up in
>> >> > >> >> >> >> > new
>> >> > >> >> >> >> > window by
>> >> > >> >> >> >> > the following url
>> >> > >> >> >> >> >
>> >> > >> >> >> >> > ="javascript:void(window.open(
>> >> > >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
>> >> > >> >> >> >> >
>> >> > >> >> >> >> > MArk2.value is a field from query in a dataset, I
>> >> > >> >> >> >> > tried
>> >> > >> >> >> >> > give
>> >> > >> >> >> >> > the
>> >> > >> >> >> >> > parameter
>> >> > >> >> >> >> > mark2.value but get errors in javascript as expected
>> >> > >> >> >> >> > '('
>> >> > >> >> >> >> >
>> >> > >> >> >> >> > Can i get new window code with parameter so that i can
>> >> > >> >> >> >> > implement.
>> >> > >> >> >> >> >
>> >> > >> >> >> >> > I am using it in text box advanced navigate url.
>> >> > >> >> >> >> >
>> >> > >> >> >> >> > Regards,
>> >> > >> >> >> >> > Navin
>> >> > >> >> >> >>
>> >> > >> >> >> >> Should your '=' be a '+' or '&'.
>> >> > >> >> >> >>
>> >> > >> >> >> >> Kerrie
>> >> > >> >> >> >>
>> >> > >> >> >> >>
>> >> > >> >> >>
>> >> > >> >> >>
>> >> > >> >> >>
>> >> > >> >>
>> >> > >> >>
>> >> > >> >>
>> >> > >>
>> >> > >>
>> >> > >>
>> >> >
>> >> >
>> >> >
>>|||Bruce,
I get this: Microsoft SQL Server Reporting Services Version 8.00.743.00
Does this version run Javascript?
And I use Visual Studio .NET 2003 as well as Windows Server 2003.
Many thanks.
"Bruce L-C [MVP]" wrote:
> Check the version of RS (when you say you have SQL Server I assume you mean
> reporting services since SQL Server DB should be SP3a at least). To check
> the version go to http://MyServerName/ReportServer
> Also, did you upgrade both the development box as well as the server with
> SP1. You need to do this for SP1.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "sammy" <sammy@.discussions.microsoft.com> wrote in message
> news:640BB5FF-3B40-4F5D-A626-0D440269E357@.microsoft.com...
> > Thanks Bruce for your reply.
> > Unfortunately, I still cannot get my result. I have a table in which one
> > textbox cell I wish to set hyperlink which open in new window. I've tried
> > this: The textbox value is a hard code value, its action is Jump to url
> > with
> > the expression you gave. => > "javascript:void(window.open('http://www.google.com'))"
> >
> > Though I get error from preview, i still deployed the report and tested
> > from
> > IE. However, the report cannot be displayed. I got the below page. Seems
> > like
> > it treats the "javascript:void..." as URL. It can only recognise if I
> > started
> > with "http://". What is the problem? Need setting for Javascript? My SQL
> > Server version is 2000 with SP1.
> >
> > Reporting Services Error
> > ----
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > The url javascript:void(window.open('http://www.google.com')) has an
> > invalid
> > schema. URLs in reports may only use http://, https://, ftp://, mailto: or
> > news: (rsUnsupportedURLProtocol) Get Online Help
> >
> > ----
> > Microsoft Reporting Services
> >
> > Thanks a lot!
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is an example of a Jump to URL link I use. This causes Excel to come
> >> up
> >> with the data in a separate window:
> >>
> >> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> >> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >>
> >> If you don't want to have it appear in a new window then do this in jump
> >> to
> >> URL:
> >>
> >> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> >> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
> >>
> >> If you want to go to another website then do this:
> >>
> >> = "javascript:void(window.open('http://www.google.com'))"
> >>
> >> For any of these with window.open to work you have to have 2000 sp1 or
> >> greater installed.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "sammy" <sammy@.discussions.microsoft.com> wrote in message
> >> news:040FADAB-6F34-4CDD-BC56-9AD5DC53F2E5@.microsoft.com...
> >> > May I know if this works fine in RS 2000 with SP1?
> >> > I always get the error message: URLs in reports may only use http://,
> >> > https:// etc..
> >> >
> >> > Thanks.
> >> >
> >> > "NAVIN.D" wrote:
> >> >
> >> >>
> >> >> perfect it works with [& instead of + for me]
> >> >> ="javascript:void(window.open('http://zxy/till.asp?MainID=" &
> >> >> Fields!Mark2.Value & "','_blank'))"
> >> >>
> >> >> Bruce all might thanks.
> >> >>
> >> >>
> >> >> "Bruce L-C [MVP]" wrote:
> >> >>
> >> >> > I believe this is the solution. The trick is making sure you end up
> >> >> > with the
> >> >> > single quotes in the right place. You are assembling a string.
> >> >> >
> >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
> >> >> > Fields!Mark2.Value + "','_blank'))"
> >> >> >
> >> >> > The below is what you do so it puts in the appropriate value for
> >> >> > your
> >> >> > report
> >> >> > server and you don't have to hard code it. But it is for calling a
> >> >> > report
> >> >> > which is not what you are doing.
> >> >> >
> >> >> >
> >> >> > --
> >> >> > Bruce Loehle-Conger
> >> >> > MVP SQL Server Reporting Services
> >> >> >
> >> >> > "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> >> > news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
> >> >> > > Bruce can you split the lenght string and explain each part. So,
> >> >> > > that
> >> >> > > i
> >> >> > > have
> >> >> > > clarity on what i am trying to implement where.
> >> >> > >
> >> >> > > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> >> > >> > "?/SomeFolder/SomeReport&ParamName=" &
> >> >> > >> > Parameters!ParamName.Value
> >> >> > >> > &
> >> >> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >> >> > >
> >> >> > > Thanks
> >> >> > > Navin
> >> >> > >
> >> >> > > "Bruce L-C [MVP]" wrote:
> >> >> > >
> >> >> > >> You haven't even tried what I suggested have you? Have you put
> >> >> > >> the
> >> >> > >> expression in a text box and then run the report and look at the
> >> >> > >> resulting
> >> >> > >> string? Did you look at how I assembled a working expression and
> >> >> > >> then
> >> >> > >> look
> >> >> > >> at your and see what you did wrong.
> >> >> > >>
> >> >> > >> I help people learn. You don't seem to care to learn. Oh well.
> >> >> > >>
> >> >> > >> --
> >> >> > >> Bruce Loehle-Conger
> >> >> > >> MVP SQL Server Reporting Services
> >> >> > >>
> >> >> > >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> >> > >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
> >> >> > >> >I dont want to guess anything any more i have seen all the
> >> >> > >> >hyperlink
> >> >> > >> >answers
> >> >> > >> > you have the same post you give out the same string as below:
> >> >> > >> >
> >> >> > >> > Here is an example that works (it is calling a report rather
> >> >> > >> > than
> >> >> > >> > an
> >> >> > >> > asp
> >> >> > >> > page but the idea is the same).
> >> >> > >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
> >> >> > >> > "?/SomeFolder/SomeReport&ParamName=" &
> >> >> > >> > Parameters!ParamName.Value
> >> >> > >> > &
> >> >> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> >> >> > >> >
> >> >> > >> > Why dont you correct my string and send sir.
> >> >> > >> >
> >> >> > >> > "Bruce L-C [MVP]" wrote:
> >> >> > >> >
> >> >> > >> >> Guess what. I can tell you exactly what is wrong here. You are
> >> >> > >> >> not
> >> >> > >> >> assembling the string correctly. Do as I said and you will see
> >> >> > >> >> exactly
> >> >> > >> >> what
> >> >> > >> >> you are doing wrong. Put this expression as the source of a
> >> >> > >> >> textbox so
> >> >> > >> >> you
> >> >> > >> >> can see what is happening.
> >> >> > >> >>
> >> >> > >> >> Here is an example that works (it is calling a report rather
> >> >> > >> >> than
> >> >> > >> >> an
> >> >> > >> >> asp
> >> >> > >> >> page but the idea is the same).
> >> >> > >> >> ="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
> >> >> > >> >>
> >> >> > >> >>
> >> >> > >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
> >> >> > >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
> >> >> > >> >> > Intially i was using the following link which work very fine
> >> >> > >> >> > taking
> >> >> > >> >> > the
> >> >> > >> >> > value
> >> >> > >> >> > which is for mark2.
> >> >> > >> >> >
> >> >> > >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
> >> >> > >> >> >
> >> >> > >> >> > when i click on link it would open as
> >> >> > >> >> > http://zxy/till.asp?MainID=20075
> >> >> > >> >> >
> >> >> > >> >> > which open in the same window now i want to open in new
> >> >> > >> >> > window
> >> >> > >> >> > instead
> >> >> > >> >> > of
> >> >> > >> >> > same window.
> >> >> > >> >> >
> >> >> > >> >> >
> >> >> > >> >> >
> >> >> > >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID='
> >> >> > >> >> > +
> >> >> > >> >> > Fields!Mark2.Value,'_blank'))"
> >> >> > >> >> >
> >> >> > >> >> >
> >> >> > >> >> > "Bruce L-C [MVP]" wrote:
> >> >> > >> >> >
> >> >> > >> >> >> What I suggest you do is create a textbox. Put this
> >> >> > >> >> >> expression
> >> >> > >> >> >> in
> >> >> > >> >> >> the
> >> >> > >> >> >> text
> >> >> > >> >> >> box. View the report and look at it. What is happening is
> >> >> > >> >> >> that
> >> >> > >> >> >> you
> >> >> > >> >> >> are
> >> >> > >> >> >> not
> >> >> > >> >> >> assembling the string properly.
> >> >> > >> >> >>
> >> >> > >> >> >>
> >> >> > >> >> >> --
> >> >> > >> >> >> Bruce Loehle-Conger
> >> >> > >> >> >> MVP SQL Server Reporting Services
> >> >> > >> >> >>
> >> >> > >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in
> >> >> > >> >> >> message
> >> >> > >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
> >> >> > >> >> >> >
> >> >> > >> >> >> > Sorry inspite of that it dont work. :-(
> >> >> > >> >> >> >
> >> >> > >> >> >> > "Kerrie" wrote:
> >> >> > >> >> >> >
> >> >> > >> >> >> >> On Feb 1, 5:08 am, NAVIN.D
> >> >> > >> >> >> >> <NAV...@.discussions.microsoft.com>
> >> >> > >> >> >> >> wrote:
> >> >> > >> >> >> >> > I am trying to provide hyperlink with parameter, to
> >> >> > >> >> >> >> > open
> >> >> > >> >> >> >> > up in
> >> >> > >> >> >> >> > new
> >> >> > >> >> >> >> > window by
> >> >> > >> >> >> >> > the following url
> >> >> > >> >> >> >> >
> >> >> > >> >> >> >> > ="javascript:void(window.open(
> >> >> > >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
> >> >> > >> >> >> >> >
> >> >> > >> >> >> >> > MArk2.value is a field from query in a dataset, I
> >> >> > >> >> >> >> > tried
> >> >> > >> >> >> >> > give
> >> >> > >> >> >> >> > the
> >> >> > >> >> >> >> > parameter
> >> >> > >> >> >> >> > mark2.value but get errors in javascript as expected
> >> >> > >> >> >> >> > '('
> >> >> > >> >> >> >> >
> >> >> > >> >> >> >> > Can i get new window code with parameter so that i can
> >> >> > >> >> >> >> > implement.
> >> >> > >> >> >> >> >
> >> >> > >> >> >> >> > I am using it in text box advanced navigate url.
> >> >> > >> >> >> >> >
> >> >> > >> >> >> >> > Regards,
> >> >> > >> >> >> >> > Navin
> >> >> > >> >> >> >>
> >> >> > >> >> >> >> Should your '=' be a '+' or '&'.
> >> >> > >> >> >> >>
> >> >> > >> >> >> >> Kerrie
> >> >> > >> >> >> >>
> >> >> > >> >> >> >>
> >> >> > >> >> >>
> >> >> > >> >> >>
> >> >> > >> >> >>
> >> >> > >> >>
> >> >> > >> >>
> >> >> > >> >>
> >> >> > >>
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >|||Just as I thought. You are not on RS SP1. This is why it is not working.
Here are the versions:
RTM: 8.00.743.00 (first release)
SP1: 8.00.878.00
SP2: 8.00.1038.00
When you install you should install both in the development environment and
the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sammy" <sammy@.discussions.microsoft.com> wrote in message
news:812E0E51-6F33-4D73-B53B-41DE61023F97@.microsoft.com...
> Bruce,
> I get this: Microsoft SQL Server Reporting Services Version 8.00.743.00
> Does this version run Javascript?
> And I use Visual Studio .NET 2003 as well as Windows Server 2003.
> Many thanks.
> "Bruce L-C [MVP]" wrote:
>> Check the version of RS (when you say you have SQL Server I assume you
>> mean
>> reporting services since SQL Server DB should be SP3a at least). To check
>> the version go to http://MyServerName/ReportServer
>> Also, did you upgrade both the development box as well as the server with
>> SP1. You need to do this for SP1.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "sammy" <sammy@.discussions.microsoft.com> wrote in message
>> news:640BB5FF-3B40-4F5D-A626-0D440269E357@.microsoft.com...
>> > Thanks Bruce for your reply.
>> > Unfortunately, I still cannot get my result. I have a table in which
>> > one
>> > textbox cell I wish to set hyperlink which open in new window. I've
>> > tried
>> > this: The textbox value is a hard code value, its action is Jump to url
>> > with
>> > the expression you gave. =>> > "javascript:void(window.open('http://www.google.com'))"
>> >
>> > Though I get error from preview, i still deployed the report and tested
>> > from
>> > IE. However, the report cannot be displayed. I got the below page.
>> > Seems
>> > like
>> > it treats the "javascript:void..." as URL. It can only recognise if I
>> > started
>> > with "http://". What is the problem? Need setting for Javascript? My
>> > SQL
>> > Server version is 2000 with SP1.
>> >
>> > Reporting Services Error
>> > ----
>> >
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. (rrRenderingError) Get Online Help
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown.
>> > The url javascript:void(window.open('http://www.google.com')) has an
>> > invalid
>> > schema. URLs in reports may only use http://, https://, ftp://, mailto:
>> > or
>> > news: (rsUnsupportedURLProtocol) Get Online Help
>> >
>> > ----
>> > Microsoft Reporting Services
>> >
>> > Thanks a lot!
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Here is an example of a Jump to URL link I use. This causes Excel to
>> >> come
>> >> up
>> >> with the data in a separate window:
>> >>
>> >> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> >> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> >>
>> >> If you don't want to have it appear in a new window then do this in
>> >> jump
>> >> to
>> >> URL:
>> >>
>> >> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
>> >> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>> >>
>> >> If you want to go to another website then do this:
>> >>
>> >> = "javascript:void(window.open('http://www.google.com'))"
>> >>
>> >> For any of these with window.open to work you have to have 2000 sp1 or
>> >> greater installed.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "sammy" <sammy@.discussions.microsoft.com> wrote in message
>> >> news:040FADAB-6F34-4CDD-BC56-9AD5DC53F2E5@.microsoft.com...
>> >> > May I know if this works fine in RS 2000 with SP1?
>> >> > I always get the error message: URLs in reports may only use
>> >> > http://,
>> >> > https:// etc..
>> >> >
>> >> > Thanks.
>> >> >
>> >> > "NAVIN.D" wrote:
>> >> >
>> >> >>
>> >> >> perfect it works with [& instead of + for me]
>> >> >> ="javascript:void(window.open('http://zxy/till.asp?MainID=" &
>> >> >> Fields!Mark2.Value & "','_blank'))"
>> >> >>
>> >> >> Bruce all might thanks.
>> >> >>
>> >> >>
>> >> >> "Bruce L-C [MVP]" wrote:
>> >> >>
>> >> >> > I believe this is the solution. The trick is making sure you end
>> >> >> > up
>> >> >> > with the
>> >> >> > single quotes in the right place. You are assembling a string.
>> >> >> >
>> >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID=" +
>> >> >> > Fields!Mark2.Value + "','_blank'))"
>> >> >> >
>> >> >> > The below is what you do so it puts in the appropriate value for
>> >> >> > your
>> >> >> > report
>> >> >> > server and you don't have to hard code it. But it is for calling
>> >> >> > a
>> >> >> > report
>> >> >> > which is not what you are doing.
>> >> >> >
>> >> >> >
>> >> >> > --
>> >> >> > Bruce Loehle-Conger
>> >> >> > MVP SQL Server Reporting Services
>> >> >> >
>> >> >> > "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> >> > news:59506FC0-DD62-4125-BB2B-47D545C631AF@.microsoft.com...
>> >> >> > > Bruce can you split the lenght string and explain each part.
>> >> >> > > So,
>> >> >> > > that
>> >> >> > > i
>> >> >> > > have
>> >> >> > > clarity on what i am trying to implement where.
>> >> >> > >
>> >> >> > > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> >> > >> > "?/SomeFolder/SomeReport&ParamName=" &
>> >> >> > >> > Parameters!ParamName.Value
>> >> >> > >> > &
>> >> >> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> >> >> > >
>> >> >> > > Thanks
>> >> >> > > Navin
>> >> >> > >
>> >> >> > > "Bruce L-C [MVP]" wrote:
>> >> >> > >
>> >> >> > >> You haven't even tried what I suggested have you? Have you put
>> >> >> > >> the
>> >> >> > >> expression in a text box and then run the report and look at
>> >> >> > >> the
>> >> >> > >> resulting
>> >> >> > >> string? Did you look at how I assembled a working expression
>> >> >> > >> and
>> >> >> > >> then
>> >> >> > >> look
>> >> >> > >> at your and see what you did wrong.
>> >> >> > >>
>> >> >> > >> I help people learn. You don't seem to care to learn. Oh
>> >> >> > >> well.
>> >> >> > >>
>> >> >> > >> --
>> >> >> > >> Bruce Loehle-Conger
>> >> >> > >> MVP SQL Server Reporting Services
>> >> >> > >>
>> >> >> > >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in message
>> >> >> > >> news:34AA8B64-3DD3-4758-9FB8-5F7D2ABF8D46@.microsoft.com...
>> >> >> > >> >I dont want to guess anything any more i have seen all the
>> >> >> > >> >hyperlink
>> >> >> > >> >answers
>> >> >> > >> > you have the same post you give out the same string as
>> >> >> > >> > below:
>> >> >> > >> >
>> >> >> > >> > Here is an example that works (it is calling a report rather
>> >> >> > >> > than
>> >> >> > >> > an
>> >> >> > >> > asp
>> >> >> > >> > page but the idea is the same).
>> >> >> > >> > ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> >> >> > >> > "?/SomeFolder/SomeReport&ParamName=" &
>> >> >> > >> > Parameters!ParamName.Value
>> >> >> > >> > &
>> >> >> > >> > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> >> >> > >> >
>> >> >> > >> > Why dont you correct my string and send sir.
>> >> >> > >> >
>> >> >> > >> > "Bruce L-C [MVP]" wrote:
>> >> >> > >> >
>> >> >> > >> >> Guess what. I can tell you exactly what is wrong here. You
>> >> >> > >> >> are
>> >> >> > >> >> not
>> >> >> > >> >> assembling the string correctly. Do as I said and you will
>> >> >> > >> >> see
>> >> >> > >> >> exactly
>> >> >> > >> >> what
>> >> >> > >> >> you are doing wrong. Put this expression as the source of a
>> >> >> > >> >> textbox so
>> >> >> > >> >> you
>> >> >> > >> >> can see what is happening.
>> >> >> > >> >>
>> >> >> > >> >> Here is an example that works (it is calling a report
>> >> >> > >> >> rather
>> >> >> > >> >> than
>> >> >> > >> >> an
>> >> >> > >> >> asp
>> >> >> > >> >> page but the idea is the same).
>> >> >> > >> >> ="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
>> >> >> > >> >>
>> >> >> > >> >>
>> >> >> > >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in
>> >> >> > >> >> message
>> >> >> > >> >> news:D5DFA4BA-EFAC-451A-9AA1-A8D009285CA7@.microsoft.com...
>> >> >> > >> >> > Intially i was using the following link which work very
>> >> >> > >> >> > fine
>> >> >> > >> >> > taking
>> >> >> > >> >> > the
>> >> >> > >> >> > value
>> >> >> > >> >> > which is for mark2.
>> >> >> > >> >> >
>> >> >> > >> >> > ="http://zxy/till.asp?MainID= " &Fields!Mark2.Value
>> >> >> > >> >> >
>> >> >> > >> >> > when i click on link it would open as
>> >> >> > >> >> > http://zxy/till.asp?MainID=20075
>> >> >> > >> >> >
>> >> >> > >> >> > which open in the same window now i want to open in new
>> >> >> > >> >> > window
>> >> >> > >> >> > instead
>> >> >> > >> >> > of
>> >> >> > >> >> > same window.
>> >> >> > >> >> >
>> >> >> > >> >> >
>> >> >> > >> >> >
>> >> >> > >> >> > ="javascript:void(window.open('http://zxy/till.asp?MainID='
>> >> >> > >> >> > +
>> >> >> > >> >> > Fields!Mark2.Value,'_blank'))"
>> >> >> > >> >> >
>> >> >> > >> >> >
>> >> >> > >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> > >> >> >
>> >> >> > >> >> >> What I suggest you do is create a textbox. Put this
>> >> >> > >> >> >> expression
>> >> >> > >> >> >> in
>> >> >> > >> >> >> the
>> >> >> > >> >> >> text
>> >> >> > >> >> >> box. View the report and look at it. What is happening
>> >> >> > >> >> >> is
>> >> >> > >> >> >> that
>> >> >> > >> >> >> you
>> >> >> > >> >> >> are
>> >> >> > >> >> >> not
>> >> >> > >> >> >> assembling the string properly.
>> >> >> > >> >> >>
>> >> >> > >> >> >>
>> >> >> > >> >> >> --
>> >> >> > >> >> >> Bruce Loehle-Conger
>> >> >> > >> >> >> MVP SQL Server Reporting Services
>> >> >> > >> >> >>
>> >> >> > >> >> >> "NAVIN.D" <NAVIND@.discussions.microsoft.com> wrote in
>> >> >> > >> >> >> message
>> >> >> > >> >> >> news:BC2630FC-F4AC-4AF5-B49B-CFECFE98724E@.microsoft.com...
>> >> >> > >> >> >> >
>> >> >> > >> >> >> > Sorry inspite of that it dont work. :-(
>> >> >> > >> >> >> >
>> >> >> > >> >> >> > "Kerrie" wrote:
>> >> >> > >> >> >> >
>> >> >> > >> >> >> >> On Feb 1, 5:08 am, NAVIN.D
>> >> >> > >> >> >> >> <NAV...@.discussions.microsoft.com>
>> >> >> > >> >> >> >> wrote:
>> >> >> > >> >> >> >> > I am trying to provide hyperlink with parameter, to
>> >> >> > >> >> >> >> > open
>> >> >> > >> >> >> >> > up in
>> >> >> > >> >> >> >> > new
>> >> >> > >> >> >> >> > window by
>> >> >> > >> >> >> >> > the following url
>> >> >> > >> >> >> >> >
>> >> >> > >> >> >> >> > ="javascript:void(window.open(
>> >> >> > >> >> >> >> > 'http://zxy/till.asp?MainID='Fields!Mark2.Value,'_blank'))"
>> >> >> > >> >> >> >> >
>> >> >> > >> >> >> >> > MArk2.value is a field from query in a dataset, I
>> >> >> > >> >> >> >> > tried
>> >> >> > >> >> >> >> > give
>> >> >> > >> >> >> >> > the
>> >> >> > >> >> >> >> > parameter
>> >> >> > >> >> >> >> > mark2.value but get errors in javascript as
>> >> >> > >> >> >> >> > expected
>> >> >> > >> >> >> >> > '('
>> >> >> > >> >> >> >> >
>> >> >> > >> >> >> >> > Can i get new window code with parameter so that i
>> >> >> > >> >> >> >> > can
>> >> >> > >> >> >> >> > implement.
>> >> >> > >> >> >> >> >
>> >> >> > >> >> >> >> > I am using it in text box advanced navigate url.
>> >> >> > >> >> >> >> >
>> >> >> > >> >> >> >> > Regards,
>> >> >> > >> >> >> >> > Navin
>> >> >> > >> >> >> >>
>> >> >> > >> >> >> >> Should your '=' be a '+' or '&'.
>> >> >> > >> >> >> >>
>> >> >> > >> >> >> >> Kerrie
>> >> >> > >> >> >> >>
>> >> >> > >> >> >> >>
>> >> >> > >> >> >>
>> >> >> > >> >> >>
>> >> >> > >> >> >>
>> >> >> > >> >>
>> >> >> > >> >>
>> >> >> > >> >>
>> >> >> > >>
>> >> >> > >>
>> >> >> > >>
>> >> >> >
>> >> >> >