Creating reports and dashboards | Stimulsoft community forum

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!

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

Hello,

Thank you for the information.

Also, please check the following article:
https://www.stimulsoft.com/en/documenta ... export.htm

Thank you.

this is very helpful.

thanks a lot!

Hello,

You are welcome.