SSRS Hide row based on condtion

moondaddy 911 Reputation points
2021-08-04T11:56:43.053+00:00

I have seen similar posts with similar titles but they did not answer this question.

Using SSRS 2019, I have a tablix and set a row's visibility property based on a condition. The logic works and it makes the row's content disappear. However, the row still has he same height which creates a big gap of empty white space in the report.

When I set the row's visibility to False, I need the row's height to be zero also.

Thanks.

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,824 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-08-05T02:08:29.897+00:00

    Hi @moondaddy ,
    I did a test locally and everything worked well:
    120536-01.jpg
    120590-02.jpg
    Preview:
    120537-03.jpg
    When I exported the report to PDF format, the problem you described still did not appear.
    Did I misunderstand what you mean?
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Joyzhao-MSFT 15,566 Reputation points
    2021-09-08T02:05:28.117+00:00

    Good morning @moondaddy ,
    Has your issue been resolved? if you have any questions, please feel free to let me know.
    Best Regards,
    Joy

    0 comments No comments

  3. Davis, Joe 0 Reputation points
    2024-03-06T14:27:12.63+00:00

    I had the same issue. I found that if you tried to add a condition to hide the row in the [Visibility][Hidden] item of the property panel (Pic 1), it would hide the row but would keep the height when you run the report. However, if you right-click the row (Pic 2) to see its properties in the table or matrix (Pic 3) and add the conditional code there instead, it will remove the row completely from the report.SSRS

    0 comments No comments