locked
HELP ME!! RRS feed

  • Question

  • User1692641958 posted

    I want to have 2 conditions in a table within the rdlc report in the expression for visibility
    something like that:
    =
    First (Fields! DescripcionDestinoPaciente.Value <> "In Evaluation" orElse
    Fields! DescripcionDestinoPaciente.Value = "Alta")

    I do not know how to do it, if someone could help me.

    Tuesday, August 21, 2018 4:00 PM

All replies

  • User347430248 posted

    Hi RockChris,

    You had mentioned that,"I want to have 2 conditions in a table within the rdlc report in the expression for visibility"

    You can try like below.

    =IIF(First(Fields!Gender.Value,"xyz")="Female" or 
    (First(Fields!CivilStatus.Value,"abc")="Married"),false,true)

    OR

    =iif(expression=value, true, iif(expression2=value2, true, false))

    Regards

    Deepak

    Wednesday, August 22, 2018 5:59 AM
  • User1692641958 posted

    Already use your method:
    = IIF (First (Fields! DesMed.Value, "FLASHREPORT") <> "Yes" or
    (First (Fields! TraRest.Value, "FLASHREPORT") <> "Yes"))

    But I get this error:

    ReportPublishingException: The Hidden expression of object 'Rectangle3' of type rectangle has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to the name of a container group, to the name of a container data region, or to the name of a data set.

    Wednesday, August 22, 2018 1:43 PM
  • User347430248 posted

    Hi RockChris,

    It is possible that your expression is correct but you have some incorrect settings and because of that you are getting this error.

    Like try to check for error part," scope parameter must be set to a string constant that is equal to the name of a container group".

    Once you set it correctly, It should start working.

    Also check that whether you are able to run single condition in your expression or not.

    It can help us to narrow down the issue.

    Regards

    Deepak

    Thursday, August 23, 2018 2:35 AM