sql server reporting services: A Jump to URL expression Question for a table control -- sql server reporting services

A Jump to URL expression Question for a table control

Hotwheels
6/28/2006 2:51:01 PM

sql server reporting services: I have a report that uses the table control, the last column has id's for
dealcompanies in it. When the user clicks on any of the other Columns
in a row I would like to be able to grab the id from the last column in the
row and insert it into the expression for the Jump to url feature.

http://sandbox:82/EE2/DealCompany.aspx?id={xxxxxxxxxx}

I do I get this id from the last column into the expression.

Mike

RE: A Jump to URL expression Question for a table control

Amarnath
6/28/2006 9:35:02 PM

Click on fields in the properties and select the fields where you have the
hyperlink or Action and use something like this.

="javascript:window.navigate('http://server/pt/pt.aspx?ID= " &
Fields!ID.Value & "');"

Amarnath

[quoted text, click to view]

RE: A Jump to URL expression Question for a table control

Hotwheels
8/28/2006 8:55:02 AM

I got this to work, my problem was that the dealCompanyid value was not a
string so I had to do a Fields!res_dealcompanyid.Value.tostring() then it
worked fine.

Parameters!CRMServer.Value just holds a Server info

="javascript:void(window.open('http://" & Parameters!CRMServer.Value &
"/EE2/DealCompany.aspx?id=" & Fields!res_dealcompanyid.Value.tostring() & "',
'_blank'))"

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.