A Jump to URL expression Question for a table control

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.
MikeClick 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
"Hotwheels" wrote:
> 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
>|||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'))"
"Amarnath" wrote:
> 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
>
> "Hotwheels" wrote:
> > 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
> >
> >