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