Hide Empty data Column or Row

[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

[Lech Kulikowski]

Hello,

You can use the DockStyle=Left and Enabled properties.

Thank you.

[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

[Lech Kulikowski]

Hello,

Do you check the provided sample report?

Thank you.

[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]

Hello,

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

Thank you.

[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]

Hello,

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

Thank you.

[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

[Lech Kulikowski]

Hello,

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

Thank you.