Hide Empty data Column or Row
Hide Empty data Column or Row
Hello,
how can I hide empty columns in "Stimulsoft Report Designer"?
Furthermore, there must not be any gaps between the other columns.
thanks
Steff23
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 (51.42 KiB) Viewed 2493 times
-
- Posts: 6636
- Joined: Tue Mar 20, 2018 5:34 am
Re: Hide Empty data Column or Row
Hello,
You can use the DockStyle=Left and Enabled properties.
Thank you.
You can use the DockStyle=Left and Enabled properties.
Thank you.
- Attachments
-
- SelectingColumnsList.mrt
- (791.1 KiB) Downloaded 159 times
Re: Hide Empty data Column or Row
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
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_Layout.jpg (83.18 KiB) Viewed 2471 times
-
- Figure 1.
- Report.jpg (184.25 KiB) Viewed 2471 times
-
- Posts: 6636
- Joined: Tue Mar 20, 2018 5:34 am
Re: Hide Empty data Column or Row
Hello,
Do you check the provided sample report?
Thank you.
Do you check the provided sample report?
Thank you.
- Attachments
-
- Screenshot 2024-04-24 120209.png (141.26 KiB) Viewed 2467 times
Re: Hide Empty data Column or Row
Thanks for the attachment - it solved the problem.
The data fields have headings.
Does this also work for headings that are in the “HeaderBand”?
![Smile :)](./images/smilies/icon_e_smile.gif)
The data fields have headings.
Does this also work for headings that are in the “HeaderBand”?
-
- Posts: 6636
- Joined: Tue Mar 20, 2018 5:34 am
Re: Hide Empty data Column or Row
Hello,
You can use the same expression for the Enabled property and the DockStyle as for components on the databand.
Thank you.
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
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
“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
-
- Posts: 6636
- Joined: Tue Mar 20, 2018 5:34 am
Re: Hide Empty data Column or Row
Hello,
Sorry, we did not exactly understand your question. Could you explain your issue in more detail?
Thank you.
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
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
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 (72.57 KiB) Viewed 2379 times
-
- Cross_Band.jpg (75.66 KiB) Viewed 2379 times
-
- Cross_tab_Report.jpg (187.64 KiB) Viewed 2379 times
-
- Cross_tab.jpg (221.01 KiB) Viewed 2379 times
-
- Posts: 6636
- Joined: Tue Mar 20, 2018 5:34 am
Re: Hide Empty data Column or Row
Hello,
You can add a filter for your Cross-Tab component.
Thank you.
You can add a filter for your Cross-Tab component.
Thank you.
- Attachments
-
- CrossTabEmpty.mrt
- (35.63 KiB) Downloaded 145 times
-
- Screenshot 2024-05-01 113027.png (146.67 KiB) Viewed 2334 times