Tuesday, July 29, 2014

2008R2: Always hide detail row based on expression AND by toggle/drill down

Hi jakub,


According to your requirement, we can refer to the steps below to achieve your goal:



  1. Right-click the second row to open the Row Visibility dialog box.

  2. Select Hide option, then enable "Display can be toggled by this report item" with MasterPackageName item.

  3. Right-click the third row to open the Row Visibility dialog box.

  4. Use the expression below to control the Row Visibility:

    =iif(Fields!MasterPackageName.Value=Fields!PackageName.Value and CountRows("MasterPackageName")>1,true,false)

  5. Enable "Display can be toggled by this report item" with MasterPackageName item.


The screenshot is for your reference:



If there are any other questions, please feel free to ask.


Thanks,

Katherine Xiong




Katherine Xiong

TechNet Community Support



No comments:

Post a Comment