Hide Empty data Column or Row

Stimulsoft Ultimate discussion
Steff23
Posts: 9
Joined: Tue Apr 23, 2024 6:55 am

Hide Empty data Column or Row

Post by Steff23 »

Hello,

how can I hide empty columns in "Stimulsoft Report Designer"?

Furthermore, there must not be any gaps between the other columns.

thanks
Steff23
Attachments
Empty.JPG
Empty.JPG (51.42 KiB) Viewed 624 times
Lech Kulikowski
Posts: 6366
Joined: Tue Mar 20, 2018 5:34 am

Re: Hide Empty data Column or Row

Post by Lech Kulikowski »

Hello,

You can use the DockStyle=Left and Enabled properties.

Thank you.
Attachments
SelectingColumnsList.mrt
(791.1 KiB) Downloaded 51 times
Steff23
Posts: 9
Joined: Tue Apr 23, 2024 6:55 am

Re: Hide Empty data Column or Row

Post by Steff23 »

Thank you for the quick response.

Where are the Doc Styles?

https://www.stimulsoft.com/de/blog/arti ... dock-style -> That's the solution, but I'm not sure how to implement it. I need this for Columns and Rows !!

I'm using the "Stimulsoft Report Designer." I've created a "Test Report" with several data fields in a data band - see Figure 1. Some of the data fields are only filled with data at specific times, while others are not filled. This results in empty columns in the report because they don't contain any data. These empty columns should not appear if there is no data in them.

Furthermore, the empty data fields should not cause gaps in the report.

Thanks
Steff23
Attachments
Print
Print
Print_Layout.jpg (83.18 KiB) Viewed 602 times
Figure 1.
Figure 1.
Report.jpg (184.25 KiB) Viewed 602 times
Lech Kulikowski
Posts: 6366
Joined: Tue Mar 20, 2018 5:34 am

Re: Hide Empty data Column or Row

Post by Lech Kulikowski »

Hello,

Do you check the provided sample report?

Thank you.
Attachments
Screenshot 2024-04-24 120209.png
Screenshot 2024-04-24 120209.png (141.26 KiB) Viewed 598 times
Steff23
Posts: 9
Joined: Tue Apr 23, 2024 6:55 am

Re: Hide Empty data Column or Row

Post by Steff23 »

Thanks for the attachment - it solved the problem. :)

The data fields have headings.
Does this also work for headings that are in the “HeaderBand”?
Lech Kulikowski
Posts: 6366
Joined: Tue Mar 20, 2018 5:34 am

Re: Hide Empty data Column or Row

Post by Lech Kulikowski »

Hello,

You can use the same expression for the Enabled property and the DockStyle as for components on the databand.

Thank you.
Steff23
Posts: 9
Joined: Tue Apr 23, 2024 6:55 am

Re: Hide Empty data Column or Row

Post by Steff23 »

Hi

“How can I work without the selection box? I would like, when the report is loaded, to display only the columns that are populated. Some columns are empty, and others contain zeros. How can you automatically hide those?”

Thanks

Steff23
Lech Kulikowski
Posts: 6366
Joined: Tue Mar 20, 2018 5:34 am

Re: Hide Empty data Column or Row

Post by Lech Kulikowski »

Hello,

Sorry, we did not exactly understand your question. Could you explain your issue in more detail?

Thank you.
Steff23
Posts: 9
Joined: Tue Apr 23, 2024 6:55 am

Re: Hide Empty data Column or Row

Post by Steff23 »

Hi,

I have a Report with a Crosstab containing 18 Columns (data fields). Each columns is filled with data in specific months - for example. I ony want to display the cloumns where data is actually present, as not all data fields can fit on an A4 landscape page, and some arent´t necessary. Therefor, any columns with no values (Empty) or where the value is 0 should not be displayed.

I need this for a Crosstab and for Cross Band.

How can i hide the empty fields?

Thank you
Steff23
Attachments
Cross_Band_Print.jpg
Cross_Band_Print.jpg (72.57 KiB) Viewed 510 times
Cross_Band.jpg
Cross_Band.jpg (75.66 KiB) Viewed 510 times
Cross_tab_Report.jpg
Cross_tab_Report.jpg (187.64 KiB) Viewed 510 times
Cross_tab.jpg
Cross_tab.jpg (221.01 KiB) Viewed 510 times
Lech Kulikowski
Posts: 6366
Joined: Tue Mar 20, 2018 5:34 am

Re: Hide Empty data Column or Row

Post by Lech Kulikowski »

Hello,

You can add a filter for your Cross-Tab component.

Thank you.
Attachments
CrossTabEmpty.mrt
(35.63 KiB) Downloaded 37 times
Screenshot 2024-05-01 113027.png
Screenshot 2024-05-01 113027.png (146.67 KiB) Viewed 465 times
Post Reply