# Report Footer and Grand Totals on one page

=?Utf-8?B?Sm9obiBGb3N0ZXI=?=
Guest
Posts: n/a

 20th Dec 2005
I have a multicolumn report that I sum all the information and have place the
sum of that into the report Footer for a Grand Total. Is there anyway to put
the grand total on the same page of a multi column report instead of it
printing on a new page??

Marshall Barton
Guest
Posts: n/a

 20th Dec 2005
John Foster wrote:

>I have a multicolumn report that I sum all the information and have place the
>sum of that into the report Footer for a Grand Total. Is there anyway to put
>the grand total on the same page of a multi column report instead of it
>printing on a new page??

If the columns are Down then Across, the first column might
use the entire page height and not leave room for the report
footer. If you use Across then Down, the columns will fill
evenly and the report footer can be printed on the same page
(if there is room).

A different idea that can be used if you do not need the
entire report width for the report footer is to create a top
level group on a constant expression such as =1 and use this
group's footer instead of the report footer.

--
Marsh
MVP [MS Access]

=?Utf-8?B?Sm9obiBGb3N0ZXI=?=
Guest
Posts: n/a

 20th Dec 2005
Marshall didn't really work, for one it put the totals for each group. I
guess I should have given you more information. I am using the group footer
to sum everything first, then I put the grand totals in the report footer. I
am not using the details section at all.

"Marshall Barton" wrote:

> John Foster wrote:
>
> >I have a multicolumn report that I sum all the information and have place the
> >sum of that into the report Footer for a Grand Total. Is there anyway to put
> >the grand total on the same page of a multi column report instead of it
> >printing on a new page??

>
>
> If the columns are Down then Across, the first column might
> use the entire page height and not leave room for the report
> footer. If you use Across then Down, the columns will fill
> evenly and the report footer can be printed on the same page
> (if there is room).
>
> A different idea that can be used if you do not need the
> entire report width for the report footer is to create a top
> level group on a constant expression such as =1 and use this
> group's footer instead of the report footer.
>
> --
> Marsh
> MVP [MS Access]
>

Marshall Barton
Guest
Posts: n/a

 21st Dec 2005
Not sure which "it" didn't work. If it was the idea of
using a group footer, then it sounds like you did not create
a new top level group using the expression =1.
--
Marsh
MVP [MS Access]

John Foster wrote:
>Marshall didn't really work, for one it put the totals for each group. I
>guess I should have given you more information. I am using the group footer
>to sum everything first, then I put the grand totals in the report footer. I
>am not using the details section at all.
>
>
>> John Foster wrote:
>> >I have a multicolumn report that I sum all the information and have place the
>> >sum of that into the report Footer for a Grand Total. Is there anyway to put
>> >the grand total on the same page of a multi column report instead of it
>> >printing on a new page??

>>
>>

>"Marshall Barton" wrote:
>> If the columns are Down then Across, the first column might
>> use the entire page height and not leave room for the report
>> footer. If you use Across then Down, the columns will fill
>> evenly and the report footer can be printed on the same page
>> (if there is room).
>>
>> A different idea that can be used if you do not need the
>> entire report width for the report footer is to create a top
>> level group on a constant expression such as =1 and use this
>> group's footer instead of the report footer.

=?Utf-8?B?Sm9obiBGb3N0ZXI=?=
Guest
Posts: n/a

 21st Dec 2005
Marshall the report currently has 4 columns in it, the labels are being
hidden by code, so that I get something like this.

Lbl Data1 Data2 Data3 Data4
"" "" "" "" ""

THe columns are the length of the whole page. When I tried to group on -1
and ran the report it asked me for the value of -1(maybe I don't know what
you are asking me to do exactly) but it ran and did the following.

lbl Data1 Total Data2 Total Data3 Total Data4 Total. and
what I would like is

lbl Data1 Data2 Data3 Data4 Total

If it would help I could send you a copy of the DB and show you what it is

"Marshall Barton" wrote:

> Not sure which "it" didn't work. If it was the idea of
> using a group footer, then it sounds like you did not create
> a new top level group using the expression =1.
> --
> Marsh
> MVP [MS Access]
>
>
> John Foster wrote:
> >Marshall didn't really work, for one it put the totals for each group. I
> >guess I should have given you more information. I am using the group footer
> >to sum everything first, then I put the grand totals in the report footer. I
> >am not using the details section at all.
> >
> >
> >> John Foster wrote:
> >> >I have a multicolumn report that I sum all the information and have place the
> >> >sum of that into the report Footer for a Grand Total. Is there anyway to put
> >> >the grand total on the same page of a multi column report instead of it
> >> >printing on a new page??
> >>
> >>

> >"Marshall Barton" wrote:
> >> If the columns are Down then Across, the first column might
> >> use the entire page height and not leave room for the report
> >> footer. If you use Across then Down, the columns will fill
> >> evenly and the report footer can be printed on the same page
> >> (if there is room).
> >>
> >> A different idea that can be used if you do not need the
> >> entire report width for the report footer is to create a top
> >> level group on a constant expression such as =1 and use this
> >> group's footer instead of the report footer.

>
>

Marshall Barton
Guest
Posts: n/a

 21st Dec 2005
Oh boy, what you are describing now is completely different
total on the same page as the last detail. I.e. I thought

Data1 Data2 Data3 Data4
"" "" "" ""
"" "" ""
"" "" ""
"" "" ""
-----------------------------------------
Grand Total nnnn

Then I said IF it was acceptable to show the grand total in
the last data column:

Data1 Data2 Data3 Data4
"" "" "" ""
"" "" "" ----------
"" "" "" nnnn
"" "" ""

So I am completely lost as to how we got from the original
question to what you now seem to be asking for. Actually,
for what you now seem to be asking about, I not only don't
see a way to do that, I can see how it would be meaninful in
a report.

As for you being prompted for -1, it's probably because you
didn't set the Sorting and Grouping Field/Expression to =1
as I suggested.
--
Marsh
MVP [MS Access]

John Foster wrote:
>Marshall the report currently has 4 columns in it, the labels are being
>hidden by code, so that I get something like this.
>
>Lbl Data1 Data2 Data3 Data4
>"" "" "" "" ""
>
>THe columns are the length of the whole page. When I tried to group on -1
>and ran the report it asked me for the value of -1(maybe I don't know what
>you are asking me to do exactly) but it ran and did the following.
>
>lbl Data1 Total Data2 Total Data3 Total Data4 Total. and
>what I would like is
>
>lbl Data1 Data2 Data3 Data4 Total
>
>If it would help I could send you a copy of the DB and show you what it is
>
>
>"Marshall Barton" wrote:
>> Not sure which "it" didn't work. If it was the idea of
>> using a group footer, then it sounds like you did not create
>> a new top level group using the expression =1.
>>
>>
>> John Foster wrote:
>> >Marshall didn't really work, for one it put the totals for each group. I
>> >guess I should have given you more information. I am using the group footer
>> >to sum everything first, then I put the grand totals in the report footer. I
>> >am not using the details section at all.
>> >
>> >
>> >> John Foster wrote:
>> >> >I have a multicolumn report that I sum all the information and have place the
>> >> >sum of that into the report Footer for a Grand Total. Is there anyway to put
>> >> >the grand total on the same page of a multi column report instead of it
>> >> >printing on a new page??
>> >>
>> >>
>> >"Marshall Barton" wrote:
>> >> If the columns are Down then Across, the first column might
>> >> use the entire page height and not leave room for the report
>> >> footer. If you use Across then Down, the columns will fill
>> >> evenly and the report footer can be printed on the same page
>> >> (if there is room).
>> >>
>> >> A different idea that can be used if you do not need the
>> >> entire report width for the report footer is to create a top
>> >> level group on a constant expression such as =1 and use this
>> >> group's footer instead of the report footer.

>>
>>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Chiz Microsoft Access Reports 4 16th Mar 2010 04:31 PM PsyberFox Microsoft Excel Misc 1 13th Feb 2008 07:16 PM =?Utf-8?B?bGFrbmlnaHQ=?= Microsoft Access Reports 3 12th Nov 2007 07:41 PM =?Utf-8?B?Sm9obkx1dGU=?= Microsoft Access Reports 3 26th Jun 2007 07:05 PM BarbaraH. Microsoft Access Reports 2 4th Nov 2003 03:42 PM

Features