Hi devs,
I would like to know how to remove gaps when exporting to excel,
I have attached an image of my report layout and exported excel with gaps.
The culprit was the CrossHeaderBand, it causes the gap BUT I can't remove it because that will hold the two CrossDataBands on its place.
What causes the CrossHeaderBand to produce a gap when the page restarts? That gap is on top of Page 2, next 3 and so on and so forth..
I attached my report for your review.
Thanks!
remove gaps when exporting to excel
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
remove gaps when exporting to excel
- Attachments
-
- Revisions Report (Final).mrt
- (62.58 KiB) Downloaded 74 times
-
- gaps.png (104.86 KiB) Viewed 545 times
-
- report layout.png (72.82 KiB) Viewed 545 times
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: remove gaps when exporting to excel
Hi devs,
I am about to delete this post coz I had it solved already BUT I was thinking twice because it might be prohibited.
I solved the gaps issue by redrawing the components: Headerband, Databand, CrossHeaderBand, CrossDataBand and Text Components and aligning them to grid.
I have attached a sample excel export of my report.
You guys are awesome!
Great, thanks
I am about to delete this post coz I had it solved already BUT I was thinking twice because it might be prohibited.
I solved the gaps issue by redrawing the components: Headerband, Databand, CrossHeaderBand, CrossDataBand and Text Components and aligning them to grid.
I have attached a sample excel export of my report.
You guys are awesome!
Great, thanks
- Attachments
-
- Drawings and Revisions (solved).xls
- (135 KiB) Downloaded 71 times
-
- gap resolved.png (23.16 KiB) Viewed 539 times
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: remove gaps when exporting to excel
Hello,
Thank you for the information.
Also, please check the following article:
https://www.stimulsoft.com/en/documenta ... export.htm
Thank you.
Thank you for the information.
Also, please check the following article:
https://www.stimulsoft.com/en/documenta ... export.htm
Thank you.
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: remove gaps when exporting to excel
this is very helpful.
thanks a lot!
thanks a lot!
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: remove gaps when exporting to excel
Hello,
You are welcome.
You are welcome.