April 24, 2008 at 9:30 am
I have a report which have Sales, Cost, freight, Gross profit, Adjusted GP, .....
I need to supress the rows which don't have values for any of these fields, but should print if atleast one of'em have a value. So I added an expression which can check for these fields. But Iam not able to run the report. Is there any limit for the number of fields to be included in the expression. Or is there any other way to include the Logical Operators .Can any one suggest !
=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))
Thanks
April 24, 2008 at 11:27 am
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
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
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply