Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : How do I combine Fields!res_dealCompanyid.Value into my expression


Hotwheels
6/30/2006 1:09:02 PM
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.

This URL works
="javascript:void(window.open('http://sandbox:82/EE2/DealCompany.aspx?id={535d58cc-a1b3-da11-9864-001320020c86}','_blank'))"

when I try to add "Fields!res_dealCompanyid.Value" I get Page cannot be
displayed
="javascript:void(window.open('http://sandbox:82/EE2/DealCompany.aspx?id={'
& Fields!res_dealCompanyid.Value & '}','_blank'))"

How do I combine Fields!res_dealCompanyid.Value which holds the id in my url?

Mike


Amarnath
7/1/2006 1:21:02 AM
When IE opens, Just see the link on the top whether ID= as got any value,
what I mean is that whether the field!... is substituted with the value.

Amarnath

[quoted text, click to view]
Raghu
7/2/2006 7:35:06 AM

="javascript:void(window.open('http://sandbox:82/EE2/DealCompany.aspx?id={'
& Fields!res_dealCompanyid.Value & '}','_blank'))"

should be


="javascript:void(window.open('http://sandbox:82/EE2/DealCompany.aspx?id={'"
& Fields!res_dealCompanyid.Value & "'}','_blank'))"




[quoted text, click to view]
Hotwheels
8/28/2006 8:58: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]
AddThis Social Bookmark Button