PWA Report - hyperlink to workspace does not work

[Lee Wex]

I modified a report in the "Project 2007 Report Pack" using Visual Studio
2005 to include a field that will jump to the project workspace url. The
value in the "Hyperlink action - jumpt to url" field is

="http://qflprojectman/PWA/"&Fields!ProjectName.Value &"/default.aspx"

When I include the report in a "SQL Server Reporting Services Report Viewer"
web part on the PWA home page the report runs but the hyperlink does not work.

Using Project Sever 2007 and WSS.

 

[.jussi]

Hi Lee,

I had a similar problem. I had to parse the URL completely in the query to
make it work. This is what I use in my report (this opens a new window, of
course - which is what I wanted but may not be preferable to you):

="javascript:void(window.open( '" & Fields!task_url.value.toString & "',
'_blank'))"

Hope that helps,
- Jussi

 

[Jonathan Sofer [MVP]]

Are you using SQL Reporting Services in SharePoint integrated mode? If so,
I don't think hyperlinks like the one you created work in that mode. So
when you say it doesn't work what do you mean exactly? Do you mean there is
no hyperlink or the link doesn't respond or the link takes you to an error
page? Let us know.

Jonathan

 

[Lee Wex]

It worked. The below opens the project workspace. Thank you.

="javascript:void(window.open('http://qflprojectman/PWA/" &
Fields!ProjectName.Value.toString & "/default.aspx','_blank'))"

 

[.jussi]

You are very welcome.

- Jussi

It worked. The below opens the project workspace. Thank you.

="javascript:void(window.open('http://qflprojectman/PWA/" &
Fields!ProjectName.Value.toString & "/default.aspx','_blank'))"

 

[.jussi]

Hi Jonathan,

Yes I am - and it seems that Lee is as well. The problem I was having was
that the link did not respond. Through the html source I discovered that the
URL was coming through as blank, but when I parsed it fully in the SQL query
it started to work.

Do you have more insight to why the RS in sharepoint integrated mode has
issues with hyperlinks? My solution below does work, but I would like to
understand why I had to invent a workaround?

- Jussi

 

[Jonathan Sofer [MVP]]

I do not know why RS in SP mode has issues with hyperlinks. It was an
observation that I never dug into. Sorry I can''t provide any insight into
this issue.

Jonathan

Hi Jonathan,

Yes I am - and it seems that Lee is as well. The problem I was having was
that the link did not respond. Through the html source I discovered that
the
URL was coming through as blank, but when I parsed it fully in the SQL
query
it started to work.

Do you have more insight to why the RS in sharepoint integrated mode has
issues with hyperlinks? My solution below does work, but I would like to
understand why I had to invent a workaround?

- Jussi