CODEWITHSUNDEEP
sqlreporting-servicesparametersexpressionwhere-clause
Aerobane
Aerobane

Reputation: 85

SSRS Change Parameter Values In Each Cell

In SSRS I am trying to set parameter values in each given cell. For example I have the parameters @Code, @StatusID, @AnalysisID.

The @Code is set at the beginning of the report like usual but I have sums and counts in the report where in different cells I will need to say 

Fields!fieldname.value where @StatusID = 1 and @AnalysisID =2.

The next cell would be Fields!fieldname.value where @statusID = 1 and @AnalysisID = 3 for example.

Is it even possible to change parameters through expression boxes like this? If so what is the syntax?

Upvotes: 0

Views: 406

Answers (1)

Mahesh
Mahesh

Reputation: 8892

You need to take a look at the expressions of ssrs.From what I understood you want to set the value of cell depending on the parameter values

so for the first cell expression

  = IIF(Parameters!StatusID=1 AND Parameters!AnalysisID=2, Fields!fieldname.value,Nothing)

and For the second cell expression 

  = IIF(Parameters!StatusID=1 AND Parameters!AnalysisID=3, Fields!fieldname.value,Nothing)

Upvotes: 1

Related Questions