Replies

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

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

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.

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.

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

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

Hans

They can both grow and shrink.

Hans

They can both grow and shrink.

Hans

Thank you again. I am using code triggered on the form’s Load event to set the ColumnWidth property (which is only accessible in VBA) for the controls.

Nick

Hans

Thank you again. I am using code triggered on the form’s Load event to set the ColumnWidth property (which is only accessible in VBA) for the controls.

Nick

Hans

Thanks for that. As you say, this is indeed a tricky one. What complicates it even more is that this is an Access front-end, sitting on a SQL Server database. So there are no Access tables, hence no fields, hence no Columnwidth properties to be accessed – is that right ?

I think I might just have to use the old ‘best visual fit’ method’ & hope no one can ‘spot the joins’

Nick

Hans

Thanks for that. As you say, this is indeed a tricky one. What complicates it even more is that this is an Access front-end, sitting on a SQL Server database. So there are no Access tables, hence no fields, hence no Columnwidth properties to be accessed – is that right ?

I think I might just have to use the old ‘best visual fit’ method’ & hope no one can ‘spot the joins’

Nick

Hans

Many thanks for that. It did not quite fit the bill, but I managed to find the answer in Stan Leszynski’s wonderful book ‘Access 97 Expert Solutions’. You have to set up a dummy group header section in the subreport with the column headings in, and a blank Report Header section. It then repeats the headings based on the page size, regardless of the number of records.

Every serious Access developer should either have or read this book – there is so much good information in there, IMHO.

Thanks again

Nick

Hans

Many thanks for that. It did not quite fit the bill, but I managed to find the answer in Stan Leszynski’s wonderful book ‘Access 97 Expert Solutions’. You have to set up a dummy group header section in the subreport with the column headings in, and a blank Report Header section. It then repeats the headings based on the page size, regardless of the number of records.

Every serious Access developer should either have or read this book – there is so much good information in there, IMHO.

Thanks again

Nick

Mark

That is exactly what I wanted to know – sorry for the delay in replying.

Nick