Field value as a parameter

• giszzmo

  SSChasing Mays

  Points: 647

  More actions

  May 1, 2014 at 12:08 pm

  #286340

  I need to create a parameter using the value of an indicator: =CInt(IIF(Fields!Passed.Value, 1, iif(Fields!Passed.Value is nothing, -1, 0)))

  The values that come from it are -1, 0, 1. I'm not sure what to do. Can anyone point me in the right direction? Thanks.

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  May 1, 2014 at 12:47 pm

  #1710192

  Not sure what you are trying to do.

  The value of indicator is defined by values from a data set.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP