CODEWITHSUNDEEP
reporting-services
David Fetrow
David Fetrow

Reputation: 21

I need to look up value from dataset

I have a textbox that I use as a checkbox. I need to see if the value is in the dataset ID field. If it is, I put an "X" in the textbox. How do I do this

Upvotes: 0

Views: 22

Answers (1)

Anup Agrawal
Anup Agrawal

Reputation: 6669

It can be done by using an SSRS expression.

Right click on your textbox and go to expression and put the following expression

=IIF(isNothing(Fields!ID.Value) OR Fields!ID.Value = "", "", "X")

enter image description here

It checks If the ID field is empty or Null then put blank else put an X.

Remember SSRS is case sensitive. Fields!ID.Value is different from Fields!iD.Value

Upvotes: 1

Related Questions