question

RajeevRanjan-5183 avatar image
0 Votes"
RajeevRanjan-5183 asked RajeevRanjan-5183 answered

SSRS Expression to show data as per condition

In a text box, I need to show value as per the label name.

116820-data.png



In one text box, I need to show value for Overdue label name, which is 1.
In another text box, I need to show value for next1, which is 2.

I tried below expression but it is only working for the first condition.

=iif(First(Fields!Label_name.Value, "DataSet1") = "Overdue", First(Fields!Label_value.Value, "DataSet1"), 0)

Please help.

sql-server-reporting-services
data.png (2.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

RajeevRanjan-5183 avatar image
0 Votes"
RajeevRanjan-5183 answered

This expression served my requirement.

=Lookup("Overdue", Fields!Label_name.Value, Fields!Label_value.Value, "DataSet1")

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.