How do you reference a field in the Embedded Code of an SSRS report.

Question

Hello,

Is there a proper way to reference the fields of a ssrs report from the embedded code of an ssrs report?

When I try to use Fields!Program.Value I get the following error --

There is an error on line 3 of custom code: [BC30469] 
Reference to a non-shared member requires an object reference.

Upon googling I found you could reference the Parameters of a report by prepending Report. at the beginning. So I tried this Report.Fields.Program.Value. That results in the following error...

There is an error on line 3 of custom code: [BC30456] 'Fields' is not a member of 'Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IReportObjectModelProxyForCustomCode'.

So...in summary, is there a way to reference the fields from the embedded code. I figured out I could pass the field vals to the function itself but I would prefer to reference the fields directly.

Seth

Answer 1

You have to pass it in as a parameter.

=Code.ToUSD(Fields!StandardCost.Value)