Creating reports and dashboards | Stimulsoft community forum

For an invoice I have 3 data sources:

- The invoice items
- The tax totals
- The payment totals

I want to print the tax totals and payment totals as the footer of the invoice items tables in a way, that this footer is never splitted by a line break. So if the footer with the list of tax totals and payments doesn't fit at the end of the page, it should be printed at the end of a new page AND the free space on the new page should be filled with the empty band.

I tried this by adding a sub report or a panel to the footer band of the item list. With a sub report the page break happens within the sub report. With a panel the footer is printed on a new page, but the empty space is not filled with the empty band.

Any suggestions?

Happy new year!

Hello Tobias,

Please look at sample report. Try to increase value of CountData property of DataBand1.

Thank you.

Thanks, but unfortunately your sample doesn't exactly do what I would like to have.

Just increase Count Data of DataBand1 to 33 and the second data band (the "footer data band") will be splitted, so that some rows end up on a second page. But what I need is, that the footer data sticks together and completely moves to a new page if it doesn't fit on the previous one as a whole.

Tobias

PS: And the empty space the "footer data band" would leave when moving on a new page shall be filled with an empty band.

Hi Tobias,

Please set Data1.PrintAtBottom = false and place the EmptyBand as in the attached file.

Thank you.

Edward wrote: Please set Data1.PrintAtBottom = false and place the EmptyBand as in the attached file.

Sorry, I think I haven't been clear enough about what I need. In Sample2 you changed the second DataBand to 33 rows, I meant the first one.

Please check this sample:

Sample3.mrt

Here DataBand2 with it's 3 items gets splitted onto the next page. But what should happen when it can't fit to the current page is, that DataBand2 completely moves to the new page and the the entire empty space on the new page is filled with the EmptyBand.

Tobias

Hi Tobias,

Please see the report in the attachment.

Thank you.

Thanks! Adding an empty group header seams to do the trick, to keep the second databand together.

Now this comes closer to what I need. For some reason the header band "invoice footer" is printed at the top of the page, even if PrintAtBottom is true. When I set PrintAtBottom for the group header, this gets fixed (this is one of the things, that I think are not very intuitive at all.)

But there's still one problem left. The empty band and the databand header are not printed on the last page. Please see the attached picture to get an idea, how the second page should look like.

And something else: How can I make the empty band continue the even/odd styling of the data band? In the attach example, the data band ends with an even row and the empty band starts with an even row, which breaks the overall even/odd row pattern.

Tobias

Hi Tobias,

Tobias wrote:For some reason the header band "invoice footer" is printed at the top of the page, even if PrintAtBottom is true. When I set PrintAtBottom for the group header, this gets fixed (this is one of the things, that I think are not very intuitive at all.)

This is correct behavior of headers which was intended, if PrintAtBottom is used, please use it for all bands in the same group.

But there's still one problem left. The empty band and the databand header are not printed on the last page. Please see the attached picture to get an idea, how the second page should look like.

This happened because there are no records of the DataBand1 in the second page. Please see the attachment. Also it is possible to add a pageheader which will be printed in the top of each page.

And something else: How can I make the empty band continue the even/odd styling of the data band? In the attach example, the data band ends with an even row and the empty band starts with an even row, which breaks the overall even/odd row pattern.

Sorry, this is not available in the current version of Stimulsoft Reports.Net. We will consider the possibility to add such an option and let you know in this topic.

Thank you.

Edward wrote:Hi Tobias,

But there's still one problem left. The empty band and the databand header are not printed on the last page. Please see the attached picture to get an idea, how the second page should look like.

This happened because there are no records of the DataBand1 in the second page. Please see the attachment. Also it is possible to add a pageheader which will be printed in the top of each page.

Ok, now I have a page header on every page, but what I need is the empty band to fill ALL remaining space, even if there are no records on a page. I should probably give up and suggest the customer to use a totally different invoice layout.

Edward wrote:

And something else: How can I make the empty band continue the even/odd styling of the data band? In the attach example, the data band ends with an even row and the empty band starts with an even row, which breaks the overall even/odd row pattern.

Sorry, this is not available in the current version of Stimulsoft Reports.Net. We will consider the possibility to add such an option and let you know in this topic.

Ok, thanks!