Hide Toggle symbol While no data to expand (Hide row if no data) ssrs report

Question

I am trying to hide a toggle some fields in my report . it works but also I want to hide rows if don't have data and hide toggle symbol .

I tried to add expression in row visibility and details group visibility but doesn't work , it hide row but still I can toggle

Answer 1

Hi @Menna Alah Ahmed You mean you want to hide the rows, and you don't need to toggle, do you? Then you can uncheck "Display can be toggled by this report item" under Visibility. I did a simple test to add an expression in details group visibility that doesn't show a line change when the Units value is empty.

Preview:

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know. Best regards, Aniya

Answer 2

If you can tell me steps to toggle row from project id only if row has data and hide this toggle symbol and hide row if doesn't has data I didn't put toggle on text box I put toggle on details group

Answer 3

Hi @Menna Alah Ahmed I seem to understand what you mean, you want to hide directly when there is no data, but you want to display it according to the switch when there is data, right? Then I think you can directly use the filter, filter out the rows that don't show data, and then use the row visibility normally to use the toggle. I did a simple test.

Preview:

Best regards, Aniya