Empty space when hiding many cells on table

2 Answers 111 Views
Report Designer (standalone)
son
Top achievements
Rank 1
Iron
son asked on 05 May 2023, 04:33 AM

Hi everyone,

I have a report design as the image below. I have set conditional formatting for the empty data will be hidden

But it has empty space when hiding many cells on the table

I have read many topics for this issue on the forum by using Group Explorer, Binding, and Designing the Basic Layout,.... but it does not work exactly

Hope to hear your solution

Thanks

2 Answers, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 09 May 2023, 10:47 AM

Hello Son,

Thank you for the screenshot of the problem!

This is a problem known to appear when there are a lot of hidden cells in a table/crosstab. The issue is logged on the public portal and I have cast your vote for the following two feedback items in order to increase its priority:

If it would not affect the total table values, I recommend filtering out the unwanted data instead of hiding the cells that display it. Depending on your table/crosstab grouping that may or may not affect the total sums so please proceed with caution.

If the above approach will affect your table negatively, the other thing that you may try to do is replicating your table layout with the list report item, though, the table column headers should be outside the list item, just above it. Then, hiding textboxes inserted directly in that list(basically the "cells") should work as expected.

I hope that the provided information will help, please let me know if you need further assistance. 

Regards,
Dimitar
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
0
son
Top achievements
Rank 1
Iron
answered on 11 May 2023, 02:17 AM

Hi Dimitar,

I updated my report with many changes by filtering the data in group explorer, it help me a lot to hide/show cells

Thank you for your support.

Tags
Report Designer (standalone)
Asked by
son
Top achievements
Rank 1
Iron
Answers by
Dimitar
Telerik team
son
Top achievements
Rank 1
Iron
Share this question
or