all groups > sql server reporting services > august 2005 >
You're in the

sql server reporting services

group:

Navigation: Jump to URL


Navigation: Jump to URL Jeffrey Jones
8/19/2005 3:34:37 PM
sql server reporting services:
Hello,

I have been trying for a while to get one field in my report to link to
a page on my local server. I have looked in the older post as well as on
the internet and have found so examples that just don't work for me. I
am running SRS SP2 and using an MSCRM database as my source. The code I
am using is as follows: =
"javascript:void(window.open('http://crm/SFA/leads/edit.aspx?id={' &
Fields!leadid.Value.ToString & '}'))". I am incredibly new to javascript
and sort of know what this code does but I don't know if I am using the
function correctly and if this function will even work. When I use the
hyperlinked field, my screen flickers and nothing happens. So any help
you can offer will be greatly appreciated.

Regards,
Re: Navigation: Jump to URL Bruce L-C [MVP]
8/19/2005 4:03:23 PM
You are assembling a string here. Change it to this:
= "javascript:void(window.open('http://crm/SFA/leads/edit.aspx?id={'" &
Fields!leadid.Value.ToString & "'}'))".

You need the additional double quotes.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services



[quoted text, click to view]

Re: Navigation: Jump to URL Jeffrey Jones
8/22/2005 1:49:47 PM
[quoted text, click to view]
Thank you for pointing that out. Though, after I change my syntax, I
still can't get the code to work. Could this be an explorer setting? I
have tried this same code but with google.com replaced with my crm url.
My screen flashes and windows makes a 'ding' sound and then nothing.
Looked in the event logs. Nothing. Looked at the task manager as I was
firing the link. Nothing. I don't really know what is happening with
this. Any other suggestions would be helpful.
Thanks,
Re: Navigation: Jump to URL Bruce L-C [MVP]
8/22/2005 2:35:53 PM
Here is a working one for me. Take the following line and cut and paste it
into the jump to url.

= "javascript:void(window.open('http://www.google.com','_blank'))"

Note that you have to have SP1 or SP2 installed for this to work.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Navigation: Jump to URL Jeffrey Jones
8/22/2005 3:02:37 PM
[quoted text, click to view]
I have learned that spacing matters with this particular section of the
program. The syntax of the day is: =
"javascript:void(window.open('http://crm/SFA/leads/edit.aspx?id={"&
Fields!leadid.Value &"}'))". There is a space between the amperstands
and the Fields name. Any thing less than this exact syntax will not
work. Also the link will not work in the VS dev. env. The report needs
to be deployed before it will work worth a darn. Since leadid is a GUID
and SRS does not play nice with GUIDs, you need to use <CAST(Lead.LeadId
as nvarchar(80)) as leadid> when creating your dataset. Follow all of
this and you will have a nice day.

Regards,
AddThis Social Bookmark Button