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 typo in the managed newsgroup URL

in MSDN managed newsgroup list:
http://msdn.microsoft.com/subscriptions/managednewsgroups/list.aspx
There is a typo in the URL for Reporting services Browser view.
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=micrsoft.public.sqlserver.reportingsvcs
Instead of microsoft, it's micrsoft. Thus results in a broken link.
Please fix it.
MichaelHi Michael,
Thanks for your kindly figuring this out and I have reported this typo and
hope it will be fixed soon :)
Thanks so much, once more.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
Just keep you update that it was fixed :-) and thanks again for your kindly
point it out.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

A SQL / STored procedure question.

I have following two tables.

Table1 (Columns: ID, SessionID, URL) Note: URL Column currently is empty. Table1 has one record per SessionID.

Table2 (Columns: ID, SessionID, fromURL) Note: Table 2 has multiple records per Session ID.

So in essence, for one SessionID in Table1 there are multiple records in Table2.

Also the value in fromURL column in Table2 is unique for a SessionID.

What I want to do:

1). Select Table2.fromURL where Table1.SessionID = Table2.SessionID with DISTINCT Table2.fromURL.(I will get lot of records from the above statement)

2). For each record in step 1,Insert value from Table2.fromURL into Table1.URL where Table2.SessionID = Table1.SessionID

Phew.. difficult to explain.. i am sure.. easy to implement.Any help would be appreciated. Regards.

UPDATE Table1 SET URL = fromURL FROM Table2 WHERE Table2.SessionID = Table1.SessionID

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