Post reply

Checking for more than 3 fields in the report expression.

  • April 24, 2008 at 11:27 am

    #806757

    It may work to add an expression to the visibility of the row. Something like iif(nothing, true, false).

  • April 24, 2008 at 12:38 pm

    #806820

    Thank you so much.

    The expression I included is for the same visibility of the detail row. But still it's not working . When I add this expression , it gives an error saying " True part (False part)" of the expression is missing. Any suggestion ?

  • April 24, 2008 at 12:50 pm

    #806832

    The error is coming from your code? I think your IIf statement needs a final qualifier...

    =IIF(Parameters!PeriodToDate_Parameter.Value ="MTD",

    IIF(Fields!Gross_Profit_MTD.Value <> 0 Or

    Fields!Adjusted_Gross_Profit_MTD.Value <> 0 Or

    Fields!Adjusted_AGP_MTD.Value <> 0 Or

    Fields!Product_Sales_MTD.Value <> 0 Or

    Fields!Product_Cost_MTD.Value <> 0 Or

    Fields!Freight_Sales_MTD.Value) <> 0 Or

    Fields!Freight_Cost_MTD.Value) <> 0 ,False,True),False,True)

    I think without the final true/false only the inner IIf statment can be evaluated.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply