Report page setting (A97 SR2)

Topic

New Reply

I have a layout problem with a report, which I hope someone can solve.

The main report contains 2 subreports (Countries and Products), either of which may or may not appear, ie there can 0, 1 or 2 subreports. If either of them do appear I need to print a line of totals in a separate section below them. No problem so far.

What I want to ensure is that when the second subreport (Products) appears it is printed on the same page as the totals, but sometimes the totals line is forced onto a new page. I can

Reply | Quote

Replies

Do the subreports have a fixed size, or can they grow/shrink?

Reply | Quote

Hans

They can both grow and shrink.

Reply | Quote

Can you put the section containing the subreports and the section containing the totals line under a section spanning both? You could set the Keep Together property of the spanning section to Yes.

Reply | Quote

Hans

This is a good idea, but did not work when I tried it. Both subreports can grow to most of a page, and so the whole section would then cover mutliple pages, and not guarantee that the total line & Product subreport would be on the same page.

Bodders

Reply | Quote

What actually is the reason for

---

I can

Reply | Quote

What actually is the reason for

---

I can

Reply | Quote

I’m sure it’s not you Hans – more the way I explained it.

OK – the main report has some detail followed by 2 subreports, both of which are optional. If either of them have data, they appear, if not, they don’t. If either of them does appear then a totals line is needed on the main report which gives totals for the subreports. The totals line can refer to either or both subreports, depending on whether they appear or not. If there is not enough space on the page the totals line appears – on its own – on the next page. This is what I want to avoid if at all possible. What I would like is for the second subreport to go together on the second page with the totals.

I know it’s all a bit tricky – I just wanted to find out if it could be done at all.

Reply | Quote

But why does this preclude putting the totals line in the same section as the subreports? I still fail to understand that.

Reply | Quote

Hans

Thanks for bearing with me. Each subreport has its own total line which will appear if the subreport appears. If either (or both) of the subreports appear then an overall total line is needed on the main report adding up the total lines from the subreports. I don’t want this overall total line to appear on its own on a page, if it can be avoided. The overall totals line cannot go in either of the subreports because there is no guarantee that they will appear.

Bodders

Reply | Quote

I think the best you can do is to put the second subreport and the totals line in a separate section – it might be an artificial section based on a dummy expression such as =1 – with Keep Together set to Yes.

Reply | Quote

Hans

You were completely right. Sorry it took me so long to twig on. Thanks again & have a great weekend.

Bodders

Reply | Quote

Hans

You were completely right. Sorry it took me so long to twig on. Thanks again & have a great weekend.

Bodders

Reply | Quote

I think the best you can do is to put the second subreport and the totals line in a separate section – it might be an artificial section based on a dummy expression such as =1 – with Keep Together set to Yes.

Reply | Quote

Hans

Thanks for bearing with me. Each subreport has its own total line which will appear if the subreport appears. If either (or both) of the subreports appear then an overall total line is needed on the main report adding up the total lines from the subreports. I don’t want this overall total line to appear on its own on a page, if it can be avoided. The overall totals line cannot go in either of the subreports because there is no guarantee that they will appear.

Bodders

Reply | Quote

But why does this preclude putting the totals line in the same section as the subreports? I still fail to understand that.

Reply | Quote

I’m sure it’s not you Hans – more the way I explained it.

OK – the main report has some detail followed by 2 subreports, both of which are optional. If either of them have data, they appear, if not, they don’t. If either of them does appear then a totals line is needed on the main report which gives totals for the subreports. The totals line can refer to either or both subreports, depending on whether they appear or not. If there is not enough space on the page the totals line appears – on its own – on the next page. This is what I want to avoid if at all possible. What I would like is for the second subreport to go together on the second page with the totals.

I know it’s all a bit tricky – I just wanted to find out if it could be done at all.

Reply | Quote

Hans

This is a good idea, but did not work when I tried it. Both subreports can grow to most of a page, and so the whole section would then cover mutliple pages, and not guarantee that the total line & Product subreport would be on the same page.

Bodders

Reply | Quote

Can you put the section containing the subreports and the section containing the totals line under a section spanning both? You could set the Keep Together property of the spanning section to Yes.

Reply | Quote

Hans

They can both grow and shrink.

Reply | Quote

Do the subreports have a fixed size, or can they grow/shrink?

Reply | Quote