One and One-half Columns and Grand Total on Same Page (?)

[croy]

A report is set for two columns (down, then across). A text
box for a grand total for a field in the detail section is
working well, except...

The first column takes all the height available for the
detail section, forcing the grand total control in the
Report Footer section to print on the next page.

Is there a way to get the columns to balance, so that when
there could be room for the grand total on the same page, it
will do it that way?

 

[Jeff Boyce]

Croy

Are you sure you're working in Access? What you describe sounds
suspiciously like a spreadsheet.

Access is a relational database. You do things differently in Access than
in Excel.

In Access, it all starts with the data ... where is your data coming from?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[croy]

Croy

Are you sure you're working in Access? What you describe sounds
suspiciously like a spreadsheet.

Thanks for the reply, Jeff. 'tis MS Access 2002.

... where is your data coming from?

It's coming from a query. It's all working great, until
there's enough detail data to fill, or nearly fill, the
first column--then the grand total control from the Report
Footer section gets forced to the next page, even tho there
would be plenty room on the first page if the second column
could take more of the first column's data.

I guess what I need is a technique for "column-balancing"
;-)

 

[Marshall Barton]

A report is set for two columns (down, then across). A text
box for a grand total for a field in the detail section is
working well, except...

The first column takes all the height available for the
detail section, forcing the grand total control in the
Report Footer section to print on the next page.

Is there a way to get the columns to balance, so that when
there could be room for the grand total on the same page, it
will do it that way?

You shoul seriously think about using Across then Down that
always balances the columns.

If you must use Down then Across, then the first thing I
suggest is to put the grand totals in a top level group
footer based on a constant expression such as ="Grand
Totals". This will put the totals in a column instead of
across the whole page.

If that is also unacceptable, then you MUST use Across then
Down, but with a query that sorts the records in such a way
that they appear to be down then across even though they are
not.

 

[croy]

You shoul seriously think about using Across then Down that
always balances the columns.

If you must use Down then Across, then the first thing I
suggest is to put the grand totals in a top level group
footer based on a constant expression such as ="Grand
Totals". This will put the totals in a column instead of
across the whole page.

Thanks Marshall. I think that will be acceptable (if not
even preferable to what I was trying for...).

If that is also unacceptable, then you MUST use Across then
Down, but with a query that sorts the records in such a way
that they appear to be down then across even though they are
not.

Hmmm. Interesting--I'll have to put that on my list of
possibilities.

 

[Marshall Barton]

Thanks Marshall. I think that will be acceptable (if not
even preferable to what I was trying for...).


Hmmm. Interesting--I'll have to put that on my list of
possibilities.

One more highly restricted way to do it is IF the subreport
will always fit on a single page. Then you can set the
subreport control's CanGrow to No. The columns won't be
balanced, but at least you can set it so there wii be room
for the footer totals.