I dont see Server Management Studio on the XP with the Standard version

I have installed SQL 2005 Standard Edition on my Window XP many times and I dont see Server Management Studio.

Did I do something wrong?

Thanks.

you need to have Windows XP professional edition with SP2........refer the link,

http://support.microsoft.com/kb/910228 and if you have the necessary system requirements just go to tools folder and manually run the sqlrun_tools..........it will get installed........

|||

I didnt have to run as a separate step when I install the SQL Developer on XP SP2.

I do have XP SP2 on my PC and when I run the SQL 2005 Standard Edition, I didnt see the Server Management Studio.

So it is a separate step after a normal install?

Is it Performance Tool? Or a tool folder on the SQL 2005 STD Edition CD?

|||

there will be a tool folder may be you can insert the disk 2 and check it.....generally there will 2 folders in sql 2005 one is server and other is tool.........

|||

The default install ONLY installs the Server and network connections support.

To install SSMS, you need to put the media in again, and this time choose 'Client Tools' from the installation menu.

|||Management studio is not a performance tool, its just an replacement for Enterprise Manger

I cant deploy

Hello, I just did a report and it compiles ok, when I try to deploy then popups a window asking username and password, I put my username and password of active directory and it asks again and again, I am supposed to be an administrator on the report server.

What can I do?

When I try to connecto from sql management studio to reporting service Instance I got this error

TITLE: Connect to Server

Cannot connect to agamenon.

ADDITIONAL INFORMATION:

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

OK

but the strange thing is that I can see the report manager

|||

Do I have to change something on the config file? or in IIS?

Here it is the config file

<ConnectionType>Default</ConnectionType>
<LogonUser></LogonUser>
<LogonDomain></LogonDomain>
<LogonCred></LogonCred>
<InstanceId>MSSQL.3</InstanceId>
<InstallationID>{fece13ec-acc5-4ebd-84bf-2534c30f2f7f}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Add Key="WebServiceUseFileShareStorage" Value="false"/>
<!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
<!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
<!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
<Add Key="WatsonFlags" Value="0x0428"/>
<Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException"/>
<Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://agamenon:90/reportserver</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
<IsWebServiceEnabled>True</IsWebServiceEnabled>
<FileShareStorageLocation>
<Path></Path>
</FileShareStorageLocation>
</Service>

|||Somebody from Microsoft that can answer me please? I havent been able to deploy a report.|||I just sawy IIS virtual directory configs and both have windows integrated authentication.

Hypertext link in a report.

hello :

On a hypertext link in a report, how to open the link in a new window IE. ?

Thank's.

user the following as your URL

javascript:window.open(.........

the full syntax and example of window.open can be found here http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/methods/open_0.asp

|||

Thank's for your answer ; but Where what is that I have to put that ?

I can't use the file .config ?

|||

Not too sure what you mean by referring to the .config file.

You would use this as you would with any other HTML hyperlink e.g.

normal link
<a href="test.htm">link text </a>

new window
<a href=window.open('test.htm')">link etxt </a>

When defining hyperlinks in a report you are essentially providing the contents of the href attribute in the above example.

How do you currently define your hyperlink?

|||

Thank's: but :

I I use the properties of a zone of text, and I put in anglet Navigation towards another report(relationship). Thus I do not know or I put your code.

|||

You'll need to use the "Jump to URL" option instead of the "Jump to report" option and construct the URL using an expression e.g.

="window.open('" & Globals!ReportServerUrl & "target report name" & "')"

|||

Thank you very mutch.

|||

hi,I am using SQL Reporting 2005 and javascript doesn't work on my report.Can you tell me how you made javascript working on Jump to URL|||

Hi,

JavaScript work only in browser.It will not work in the report designer.Try to run the report in browser.

Hope this helps

|||Thanks mate, I have deployed the report to the server and view it on the browser, the link disappeared I put ="java script:void(window.open('http://nww.risklog.surreyhis.nhs.uk/aspx/addrisk.aspx?fromSearch=true&riskid=" & Fields!Risk_ID.Value & "','_blank','toolbar=false'))"|||

Hi,

Think in the Report Server also you can't get that link.You can do one think in the Web application,Drag ReportViewr control and put the report in the ReportViewr.Run that web application.Then you can get the link.

Hope this helps

|||

Im trying this in my report that returns a field in the URL - I keep getting the URI scheme is not valid error. Can anyone help? My report has no globals listed, and this is confusing me since I have tried HTML as well as JAVA to get this report to jump to an open window with no luck (obviously!) - can anyone help a newbie?

Ever Gracious for your help

Gina

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 open new window

I have a link on my report which open new window. The code i have in advance properties of that field is :

="javascriptt:void(window.open('http://www.msn.com','_blank'))" (note: the extra "t" is intentionally added in the code, coz website block the keyword "java.....t")

It works great on testing server but it doesn't work on production server. Both testing and production servers run windows 2003 server and service pack 2 for reporting services.

Reports accessing form production server, when i click on report it opens up new window with address in address bar :

javascript:void(window.open('http://www.msn.com','_blank')) with "The page cannot be displayed" message. But if i open a new internet explorer window and copy past the same address in address bar then its open up www.msn.com. To test the production server behavior I created a test web page test.htm and added the java script to open new window, it works fine.

Any help would be much appreciated.

Ive had problems with this too!
I found it only works when you access the report via a URL such as
http://reportserver/reportserver?report
Rather than through the Report Manager:
http://reportserver/reports
Through the Report Manager I saw the same behaiviour "The page cannot be displayed" message but copying and pasting worked :S
Although Im not surew this is your problem as it works on your tst server, but not prod
Hope this helps
Al

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