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?

this image

  1. right click rectangle , go insert | indicator
  2. when indicator window opens, select middle option in "symbols" section (has cross, exclamation , tick)
  3. press ok, right click indicator , click indicator properties
  4. go value , states. in list of states @ bottom, delete x , exclamation. set tick have start = 1 , end = 1
  5. in value field enter =iif(fields!<<fieldname>>.value = true, 1, 0) (obviously replace <> name of field
  6. in states measurement unit field, select "numeric"

here's snap of how it:

here's 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

Popular posts from this blog

c++ - QTextObjectInterface with Qml TextEdit (QQuickTextEdit) -

javascript - angular ng-required radio button not toggling required off in firefox 33, OK in chrome -

xcode - Swift Playground - Files are not readable -