i wanted to hide row based on measure
i have 3 material types of ore, waste and HL and 3 measures of tons, grade, metal. i wanted to hide grade and metal row for waste material. =iif(Fields!Material_Type.value="Waste",true,false) it hides whole waste. i need to add =iif(Fields!Measure.Value="Tons",false,true) somewhere.
October 11th, 2010 6:41am

Hi, I guess you display three (measures tons, grade and metal in three columns). If you want to hide the grade and metal columns only when the material is waste, 1. the right click on the cell where you grade field value 2. select textbox properties, 3. go to visibility tab, 4. click on 'show or hide based on expression', 5. click on expression button and enter the expression as =iif(Fields!Material_Type.Value="Waste",true,false). 6. Repeat step 1 to 5; in the first step choose the cell where you display metal field value Hope this helps. If this does not address your issue, please provide details as to how you've laid the columns and rows. Regards Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2010 7:31am

all my materials and measures are displayed in the row and i have 2 different types of numbers in the column. That's why i having a trouble to hide it. Since metal and grade numbers for waste wud 0 always, i wanted to hide it. Waste ton 1000 2000 metal 0 0 grade 0 0 Ore ton 1000 400 metal 200 200 grade 0.02 so on HL ton 1000 metal 100 grade 0.01
October 11th, 2010 8:25am

Hi, Please try the below 1. Open the dataset and select filters tab 2. Click on add button and enter expression as =Fields!MaterialType.Value & "-" & Fields!Measures.Value Note : In place of the field names, choose the appropriate field name from your data set 5. Select type as Text 6. In the operation, select <> 7. In the value, enter Waste-CTDMTL Above steps concatenate the values from material type and measure field and filters them to skip the one that has value as Waste-CTDMTL. 8. Run the report and observe the result Hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2010 8:59am

I didn't know that i could connect the two conditions with AND, OR connection. this formula worked for me. =iif(Fields!Material_Type.Value="Waste" and (Fields!Measures.Value="Grade" or Fields!Measures.Value="Metal" ),true,false)
October 11th, 2010 9:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics