SSRS Error: 'Value' is not a member of 'ReportExprHostImpl...Action0_ActionExprHost'

0
votes

I'm trying to set up a rule in SSRS to where if a user clicks on a PDF filename 'Document.pdf', the user is taken to a URL ex. 'www.website.com/Document.pdf'.

To do so, I'm using an expression under Placeholder Properties > Action > Go To URL:

=IIf(Fields!ID.Value = "Document.pdf", "www.website.com/Document.pdf", "false")

enter image description here

Upon running the report, I receive the error:

The ActionInfo.Action.Hyperlink expression for the text box ‘ID’ contains an error: [BC30456] 'Value' is not a member of 'ReportExprHostImpl.ID_TextBoxExprHost.ActionInfo_ActionInfoExprHost.Action0_ActionExprHost'.

I receive the same error in using Me.Value, rather than Fields!ID.Value.

I haven't encountered this problem in the past, so I'm curious as to whether this is specific to report builder actions.

1
sqlvbareporting-servicesssrs-2012
Are you sure that there's not another action on the text box (not placeholder as shown) that is using Me.value? – Hannover Fist

1 Answers

0
votes

Try using:

=IIf(Fields!ID.Value = "Document.pdf", "http://www.website.com/Document.pdf", nothing)

Note the VS warning message:

The value ‘www.website.com/Document.pdf’ of the Hyperlink property of the text box ‘Textbox18’ has an invalid schema. URLs in reports may only use http://, https://, ftp://, mailto:

Let me know if this helps.