Page 1 of 2

Hide Empty data Column or Row

Posted: Tue Apr 23, 2024 9:50 am
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

Re: Hide Empty data Column or Row

Posted: Tue Apr 23, 2024 9:11 pm
by Lech Kulikowski
Hello,

You can use the DockStyle=Left and Enabled properties.

Thank you.

Re: Hide Empty data Column or Row

Posted: Wed Apr 24, 2024 9:35 am
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

Re: Hide Empty data Column or Row

Posted: Wed Apr 24, 2024 10:03 am
by Lech Kulikowski
Hello,

Do you check the provided sample report?

Thank you.

Re: Hide Empty data Column or Row

Posted: Wed Apr 24, 2024 11:53 am
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”?

Re: Hide Empty data Column or Row

Posted: Wed Apr 24, 2024 8:14 pm
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.

Re: Hide Empty data Column or Row

Posted: Mon Apr 29, 2024 10:38 am
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

Re: Hide Empty data Column or Row

Posted: Tue Apr 30, 2024 9:14 am
by Lech Kulikowski
Hello,

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

Thank you.

Re: Hide Empty data Column or Row

Posted: Tue Apr 30, 2024 12:27 pm
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

Re: Hide Empty data Column or Row

Posted: Wed May 01, 2024 9:31 am
by Lech Kulikowski
Hello,

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

Thank you.