Home > Archive > MS SQL Server Reporting Services > July 2005 > Action - Jump To URL - Expression Does Not Seem To Evaluate









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Action - Jump To URL - Expression Does Not Seem To Evaluate
etm99

2005-07-19, 9:23 am

I'm working on a report that uses one field to contain a hyperlink. The
hyperlink links to a web page.


From the Action window, I selected the option Jump to URL.

I entered the URL:
Example:
http:\\mywebserver\m
yreport.asp?id=Field!FieldName.Value

So far so good.

The problem is when I run the report, the hyperlink does open a new window
loading the webpage; however, the value is not being substituted in the links
when the link is created on the report. Instead, the physical word of the
expression are passed ( Field!FieldName.Value ).

I'm not sure what I'm doing wrong here and I'm having a hard time believing
this is that obtuse. I've looked at the online help books and the hyperlink
discussion is quite sparse.

Any ideas of what I am missing or why the value of the expression is not
being substituted on the web page inside the hyperlink?




I then added the field value. So now the link looks like this in the Jump
To URL Textbox.

http:\\mywebserver\m
yreport.asp?id=Field!


--
Life's Too Short To Maintain Code.
etm99

2005-07-19, 9:23 am

I wanted to add the other troubleshooting that I've done:

- in the expression box:

=" http:\\mywebserver\m
yreport.asp?id="&Field!FieldName.Value

- tried using single quotes above instead of '

- Went back to the view the sql was created from and cast the field from
integer
to varchar.


etm99

2005-07-19, 11:23 am

I'm also getting this message when I attempt to use the expression:

An unexpected error occurred while compling expressions. Native compiler
return value:
'& #91;BC30260]'EH_Fiel
dName' is already declared as 'Class EH_FieldName' in this
class.'.
Paul

2005-07-19, 11:23 am

this is what i have an works fine:

= "https://localhost/Staff/action/directPage.asp?applicantID=" &
Fields!applicantID.Value & "&url=../../Assessment.asp"


hth Paul


"etm99" wrote:

> I'm working on a report that uses one field to contain a hyperlink. The
> hyperlink links to a web page.
>
>
> From the Action window, I selected the option Jump to URL.
>
> I entered the URL:
> Example:
> http:\\mywebserver\m
yreport.asp?id=Field!FieldName.Value
>
> So far so good.
>
> The problem is when I run the report, the hyperlink does open a new window
> loading the webpage; however, the value is not being substituted in the links
> when the link is created on the report. Instead, the physical word of the
> expression are passed ( Field!FieldName.Value ).
>
> I'm not sure what I'm doing wrong here and I'm having a hard time believing
> this is that obtuse. I've looked at the online help books and the hyperlink
> discussion is quite sparse.
>
> Any ideas of what I am missing or why the value of the expression is not
> being substituted on the web page inside the hyperlink?
>
>
>
>
> I then added the field value. So now the link looks like this in the Jump
> To URL Textbox.
>
> http:\\mywebserver\m
yreport.asp?id=Field!
>
>
> --
> Life's Too Short To Maintain Code.

Robert Bruckner [MSFT]

2005-07-29, 3:24 am

Most likely you are running RS 2000 and you have a report parameter or a
dataset field called "FieldName" and a reportitem (e.g. textbox) named
"FieldName" in the report.
Just rename the textbox and it should work.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

"etm99" <etm99@discussions.microsoft.com> wrote in message
news:385584A6-B210-4559-A361- CC42F64D9A0F@microso
ft.com...
> I'm also getting this message when I attempt to use the expression:
>
> An unexpected error occurred while compling expressions. Native compiler
> return value:
> '& #91;BC30260]'EH_Fiel
dName' is already declared as 'Class EH_FieldName' in
> this
> class.'.



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com