A URL expression problem with a Jump to command

I have a report that uses the table control, the last column has id's for
dealcompanies in it(Fields!res_dealCompanyid.Value). 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.
this url works fin
="javascript:void(window.open('http://sandbox:82/EE2/DealCompany.aspx?id={535d58cc-a1b3-da11-9864-001320020c86}','_blank'))"
this one gives me an Error on pag
="javascript:void(window.open('http://sandbox:82/EE2/DealCompany.aspx?id={'&Fields!res_dealCompanyid.Value&'}','_blank'))"
How can I find out what is wrong
MikeI 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'))"
"Hotwheels" wrote:
> I have a report that uses the table control, the last column has id's for
> dealcompanies in it(Fields!res_dealCompanyid.Value). 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.
> this url works fine
> ="javascript:void(window.open('http://sandbox:82/EE2/DealCompany.aspx?id={535d58cc-a1b3-da11-9864-001320020c86}','_blank'))"
> this one gives me an Error on page
> ="javascript:void(window.open('http://sandbox:82/EE2/DealCompany.aspx?id={'&Fields!res_dealCompanyid.Value&'}','_blank'))"
> How can I find out what is wrong
> Mike
>

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