I have a report which works fine but if there is no data it is totally blank. How do show even if the table/ tablix has no data?

Question

THIS BELOW IS it. But if no data it shows another

Answer 1

Hi @PhillipO ，

(1) If you want to keep the structure of the Tablix when there is no data, You can add a row outside of the outermost group right under the tablix header row.
Set the row visibility to Show or hide based on an expression. The expression would like like:

=IIf(CountRows("DataSetName") > 0, True, False)  

When there is no data, the table will show the headers and empty row.
When there is data, the empty row will be hidden.

(2) If you want to specify text to show in the rendered report in place of a data region that has no data, set the NoRowsMessage property for a table, matrix, or list data region, the NoDataMessage for a chart data region, and the NoDataText for the color scale for a map. See more: Set a No Data Message for a Data Region (Report Builder and SSRS).

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 2

I'm not sure what part of your report is disappearing but if you are using a tablix or any of the grid-level controls and there is no data then of course it won't show the data rows. But any non-data bound controls like report and table headers should still be shown. If you aren't seeing anything then I'd wager you have a condition that is hiding the control if there is no data.

If you want to show a message instead of an empty table then you can do that. Bring up the Properties window using F4. Then select the table. Under the No Rows properties is the NoRowsMessage. Set this to whatever text you want (e.g. No data found) and it will be shown in lieu of an empty table.

Can you be more specific about what parts of the report aren't showing up?

Answer 3

I just did it but still it does not show. this report is basically a table and then I expand the table, add a list at the top if uou see the Report Ending Date... that one has a list on the table so I can add text boxes. Below in blue is the same thing but I add top and I tried to use the code on the small circle blue and the larger blue one but still the whole report is blank when no data