From my understanding, your problem could be described as "Setting No Data Message"? Am I right?
If so, there are two approaches from which you could choose one according to your scenario.
1.Hidden + extra "No Data" label
You could set hidden condition for tablix and a opposite condition for the label. When the tablix is hidden, you could find that the "No Data" message will be displayed.
Note that the label should be put in the center of the tablix so that it would not disturb the users. However, I don't suggest this since it can not align with the tablix 100%.
2.Filter + "NoRowsMessage" property of the tablix
You could use filter to hidden the unnecessary rows/data and set the "NoRowsMessage" property for the tablix.
When there is no data to display, the tablix will be replaced by
the "No Data" Message.
Below you could find a demo where I constructed two tablixs with two approaches respectively. You could set the filter/hidden condition for your own needs.
The first tablix is of type => Hidden + extra "No Data" label.
The second tablix is designed with => Filter + "NoRowsMessage" property of the tablix.
Member
1 Points
19 Posts
SSRS report: showing White pages when a tablix is hidden
Apr 06, 2020 10:48 AM|szejli|LINK
Hello,
I have a report with several tablix.
Some tablix are hidden depending on the values chosen for some parameters.
When I execute the report I get white pages when the tablix are hidden.
How can I resolve this issue ?
Thanks in advance.
Best regards.
Participant
1110 Points
299 Posts
Re: SSRS report: showing White pages when a tablix is hidden
Apr 07, 2020 05:25 AM|Sean Fang|LINK
Hi szejli,
Could you please describe the problem more concretely?
For example,
Moreover, it would be great to see the parameters and the expressions you set for the visibility and how you made them working.
Within more details, it would be much easier and more efficient to target the problem.
Best regards,
Sean
Member
1 Points
19 Posts
Re: SSRS report: showing White pages when a tablix is hidden
Apr 07, 2020 06:11 AM|szejli|LINK
Hello,
I have a whole tablix that is visible according to the value of a parameter.
When The tablix is hidden, the page where this tablix is designed appears as empty. This page shouldn't appear when the tablix is hidden.
How can I get rid of this page when the tablix is hidden ?
Having empty pages in a report is disturbing the users that are using it.
I hope that it is clear for you now!
Thanks in advance.
Best regards.
Participant
1110 Points
299 Posts
Re: SSRS report: showing White pages when a tablix is hidden
Apr 08, 2020 02:27 AM|Sean Fang|LINK
Hi szejli,
Thank you for your explanation.
From my understanding, your problem could be described as "Setting No Data Message"? Am I right?
If so, there are two approaches from which you could choose one according to your scenario.
1.Hidden + extra "No Data" label
You could set hidden condition for tablix and a opposite condition for the label. When the tablix is hidden, you could find that the "No Data" message will be displayed.
Note that the label should be put in the center of the tablix so that it would not disturb the users. However, I don't suggest this since it can not align with the tablix 100%.
2.Filter + "NoRowsMessage" property of the tablix
You could use filter to hidden the unnecessary rows/data and set the "NoRowsMessage" property for the tablix.
When there is no data to display, the tablix will be replaced by the "No Data" Message.
Below you could find a demo where I constructed two tablixs with two approaches respectively. You could set the filter/hidden condition for your own needs.
The first tablix is of type => Hidden + extra "No Data" label. The second tablix is designed with => Filter + "NoRowsMessage" property of the tablix.
Designer UI:
Preview UI:
Hope this can help you.
Best regards,
Sean