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

Menna Alah Ahmed 0 Reputation points
2023-04-03T11:07:44.5266667+00:00

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

Screenshot (152)_LI

Screenshot (150)

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,821 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. AniyaTang-MSFT 12,326 Reputation points Microsoft Vendor
    2023-04-04T01:29:00.3333333+00:00

    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. 1

    Preview: 2

    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


  2. Menna Alah Ahmed 0 Reputation points
    2023-04-05T10:01:15.0333333+00:00

    Screenshot (158)

    Screenshot (157)

    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

    0 comments No comments

  3. AniyaTang-MSFT 12,326 Reputation points Microsoft Vendor
    2023-04-06T05:45:49.0133333+00:00

    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. 2

    3

    Preview: 4

    Best regards, Aniya