Multi-column Report Total

[Bisro Solan]

I have a report that has been spread out across columns using Page Setup.
The problem is that the total number of parts (added in the Feport Footer)
always shows on a second page. The reason I set up columns was that it would
keep everything on a single sheet. How do I force the Report Footer on the
first page?

 

[Bisro Solan]

I have [order number] and [quantity]. The report is set up to have four
columns so that all the data will show on one page. There will never be a
case where it should go on to the second page. I also need the [quantity] to
be added up at the bottom of the page to create a total number of parts that
are on the orders in order to check the report against another program. I
have the Total QTY adding in the report footer. Regaurdless of whether or
not the first page is full the total qty is pushed to the second page.

 

[Jeff Boyce]

It all starts with the data ... and you haven't described that yet.

If you want something to show at the bottom of each page, use the Page
Footer, not the Report Footer.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Jeff Boyce]

I haven't run across that before.

Have you tried searching on-line for that situation?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have [order number] and [quantity]. The report is set up to have four
columns so that all the data will show on one page. There will never be a
case where it should go on to the second page. I also need the [quantity] to
be added up at the bottom of the page to create a total number of parts that
are on the orders in order to check the report against another program. I
have the Total QTY adding in the report footer. Regaurdless of whether or
not the first page is full the total qty is pushed to the second page.

It all starts with the data ... and you haven't described that yet.

If you want something to show at the bottom of each page, use the Page
Footer, not the Report Footer.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

it
would on
the

 

[Bisro Solan]

I have searched online and, not to be a jerk, I've posted on a discussion
board all about Microsoft Access.

I haven't run across that before.

Have you tried searching on-line for that situation?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have [order number] and [quantity]. The report is set up to have four
columns so that all the data will show on one page. There will never be a
case where it should go on to the second page. I also need the [quantity] to
be added up at the bottom of the page to create a total number of parts that
are on the orders in order to check the report against another program. I
have the Total QTY adding in the report footer. Regaurdless of whether or
not the first page is full the total qty is pushed to the second page.

It all starts with the data ... and you haven't described that yet.

If you want something to show at the bottom of each page, use the Page
Footer, not the Report Footer.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have a report that has been spread out across columns using Page Setup.
The problem is that the total number of parts (added in the Feport Footer)
always shows on a second page. The reason I set up columns was that it
would
keep everything on a single sheet. How do I force the Report Footer on
the
first page?

 

[Jeff Boyce]

I take it then that the discussion board and on-line searches did not pan
out (I had to ask ... your earlier description offered no ideas of what
you've already tried.)

Sometimes an object in Access can pick up some subtle corruption ... have
you also tried re-creating the report?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have searched online and, not to be a jerk, I've posted on a discussion
board all about Microsoft Access.

I haven't run across that before.

Have you tried searching on-line for that situation?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have [order number] and [quantity]. The report is set up to have four
columns so that all the data will show on one page. There will never be a
case where it should go on to the second page. I also need the

[quantity]
to

be added up at the bottom of the page to create a total number of

parts
that

are on the orders in order to check the report against another program. I
have the Total QTY adding in the report footer. Regaurdless of whether or
not the first page is full the total qty is pushed to the second page.

:

It all starts with the data ... and you haven't described that yet.

If you want something to show at the bottom of each page, use the Page
Footer, not the Report Footer.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have a report that has been spread out across columns using Page Setup.
The problem is that the total number of parts (added in the Feport Footer)
always shows on a second page. The reason I set up columns was

that
it

would
keep everything on a single sheet. How do I force the Report

Footer
on

the
first page?

 

[Jeff Boyce]

I am at a loss to understand or explain why that is happening.

If this were mine, the next thing I'd try is deleting the totals from the
Report Footer and seeing if the report fits itself on a single page without
that.

Also, I might try putting the total in the Report Header (after the previous
test) to see if that works or causes a similar problem.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have undone the colume and reimplemented them and I have deleted the report
and recreated it. Nothing has fixed the problem.

I take it then that the discussion board and on-line searches did not pan
out (I had to ask ... your earlier description offered no ideas of what
you've already tried.)

Sometimes an object in Access can pick up some subtle corruption ... have
you also tried re-creating the report?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have searched online and, not to be a jerk, I've posted on a discussion
board all about Microsoft Access.

:

I haven't run across that before.

Have you tried searching on-line for that situation?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have [order number] and [quantity]. The report is set up to

have
four

columns so that all the data will show on one page. There will

never
be a

case where it should go on to the second page. I also need the [quantity]
to
be added up at the bottom of the page to create a total number of parts
that
are on the orders in order to check the report against another program. I
have the Total QTY adding in the report footer. Regaurdless of whether or
not the first page is full the total qty is pushed to the second page.

:

It all starts with the data ... and you haven't described that yet.

If you want something to show at the bottom of each page, use

the
Page

Footer, not the Report Footer.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

I have a report that has been spread out across columns using Page
Setup.
The problem is that the total number of parts (added in the Feport
Footer)
always shows on a second page. The reason I set up columns

was
that

it
would
keep everything on a single sheet. How do I force the Report Footer
on
the
first page?

 

[cmk7471]

I'm having the same issue. I have a 2 column report. I want to put totals at
the end, so I have them in the report footer. I have the column layout set to
"down then across". What happens is that the first column is filled down to
the bottom of the page and the second column only fills part of the page.
Since the report footer goes at the end of the report and one column goes to
the bottom of the page, the report footer is pushed to the next page. Is
there a way to make the column lengths even on that last page when you use
the down-then-across layout? If you switch to across-then-down it looks how I
would like, but is hard to read.

 

[Marshall Barton]

I'm having the same issue. I have a 2 column report. I want to put totals at
the end, so I have them in the report footer. I have the column layout set to
"down then across". What happens is that the first column is filled down to
the bottom of the page and the second column only fills part of the page.
Since the report footer goes at the end of the report and one column goes to
the bottom of the page, the report footer is pushed to the next page. Is
there a way to make the column lengths even on that last page when you use
the down-then-across layout? If you switch to across-then-down it looks how I
would like, but is hard to read.

Using Across then Down columns is way easier.

You can only do Down then Across by putting all the details
in a subreport and making the subreport a fixed size
(CanGrow/Shrink set to No) that's big enough to display all
the details and small enough for the report footer on one
page. The main report's report footer text boxes will, of
course, have to reference the total text boxes in the
subreport's report footer.

OTOH, if you can live with the totals in the last column
instead of across the entire page, then create a grouplevel
at the top of the Sorting and Grouping list (View menu).
Set the Field/Expression to a constant expression like =1
and select Yes for the group footer. Then you can move the
total text boxes from the report footer to the new group
footer.

 

[cmk7471]

Your suggestion to add an extra group level works just how I want it to.
Thanks so much!