Remove or Suppress Blank Rows in Report
Hello. I have a report that is displaying 15-20 rows of data (will never exceed 25 rows). The problem is that the report appears to default to showing 50 rows regardless of the data. As a result, in the current state, there will always be between 25 to 35 blank rows on this report. I am looking to use this report on a dashboard and would prefer that the expected 25-35 blank rows NOT be displayed (along with the resulting scroll bar). If I were to publish this report as-is, I expect to be fielding questions about these blank rows and would prefer to avoid this, if possible.
Is there a way to ONLY show rows that contain data on a report?
I have looked through the community responses but have not found anything on this topic. Quite possibly I am not using the right key word(s) to locate a solution. Hope I am missing something simple. Thanks in advance for any assistance.