CODEWITHSUNDEEP
reporting-servicesssrs-2008
marc_s
marc_s

Reputation: 754478

Reporting Services - setting a field value dynamically based on parameter

I need to build a report that shows data in four grouped levels. The tricky part is: the actual fields to be displayed on those four levels are to be passed into the report as parameters.

My main issue right now is this: how can I tell a textbox on the report to not display the value of the parameter @X, but the value of the field by the name which is specified in parameter @X?

So if I pass in @X = 'Agent', I don't want to show 'Agent' on the report, but really 

=Fields!Agent

but how can I do that? It seems to me that those value expressions are all pretty much hardcoded - is there a way to define 

=Fields!(@X)

or something like that - show the field which corresponds to the name passed to the report in parameter @X ?

This is probably absolutely silly - but I'm hitting a brickwall right now and can't seem to find a way around it....

Upvotes: 6

Views: 8485

Answers (2)

jimconstable
jimconstable

Reputation: 2388

It is

=Fields(Parameters!X.Value).Value

as specified here

Edited to be correct: I forgot once you use an = (expression) you have to address the parameter differently.

Upvotes: 4

Ed Harper
Ed Harper

Reputation: 21505

Is the source data for the report arranged in such a way that you could define a second datasource which looks up the field values for parameters 1-4 and returns them as a single row, to which you could then refer in the report using the first syntax?

=First(Fields!Param1.Value, "Param_Lookups")

Upvotes: 0

Related Questions