reporting services - Is CheckBox checked or not in RDL reportview -
i've 2 checkboxs(actually 2 rectangles) in report page. object database, returns boolean value. if returns yes, want checked "yes" or not, other 1 must checked.
i'm newbie in rdl reporting project. how can add expression this?
- right click rectangle , go insert | indicator
- when indicator window opens, select middle option in "symbols" section (has cross, exclamation , tick)
- press ok, right click indicator , click indicator properties
- go value , states. in list of states @ bottom, delete x , exclamation. set tick have start = 1 , end = 1
- in value field enter
=iif(fields!<<fieldname>>.value = true, 1, 0)
(obviously replace <> name of field - in states measurement unit field, select "numeric"
here's snap of how it:
what evaluate iif statement and, if field true, return 1. indicator see 1 , place green tick in rectangle.
hope helps, drop comment here if struggle.
Comments
Post a Comment