Totals to stay in Fixed Position

[Rob]

I have a Totals line in the Report Total section that I want to print
exactly 4 inches from the bottom of the page regardless of how many detail
lines are present.

Currently the position of the Totals line is dependent on how many detail
lines are printed.

I want the Totals to be at exactly the same place on the page every time.

Any thoughts ?

 

[Rick B]

Put it in your Report footer or page footer and make your footer 4 inches
tall with the totals near the top.

 

[Rob]

Thanks Rick,

Tried that, but the whole 4 inches moves up the page when only 1 detail line
is present.
I need some way to specify that the 4 inch Report Total section should
start 7 inches from the Top of the page regardless of how large the detail
section is...

I think I have done this before, just forgot how I did it. Do you set the
position in code using the On Format ?

Rob

 

[MA]

Thanks Rick,

Tried that, but the whole 4 inches moves up the page when only 1
detail line is present.
I need some way to specify that the 4 inch Report Total section
should start 7 inches from the Top of the page regardless of how
large the detail section is...

I think I have done this before, just forgot how I did it. Do you
set the position in code using the On Format ?

Rob

Probably you put it in report non page footer


--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Rob]

Hi...

I did put the Totals in the "Report Footer" - problem is that the Report
Footer "floats" up and down the page depending on the size of the detail for
that report.

 

[Rick B]

Use the Page Footer!

--
Rick B

Hi...

I did put the Totals in the "Report Footer" - problem is that the Report
Footer "floats" up and down the page depending on the size of the detail for
that report.

 

[MA]

Hi...

I did put the Totals in the "Report Footer" - problem is that the
Report Footer "floats" up and down the page depending on the size of
the detail for that report.

In fact you have to put in Page footer not report.
Page keep you setting for all pages (and the same for Head),
Report put it just bottom the body.
Try to make a report of 2 pages and put a label in Page footer and
anotherone in the report
and it will be clear the difference

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Rob]

Hi Rick,

Did that, looks like position will work OK, but now the formulas do no work
i.e. =sum(Sales) gives an error message

Thanks,
Rob

 

[fredg]

Hi Rick,

Did that, looks like position will work OK, but now the formulas do no work
i.e. =sum(Sales) gives an error message

Thanks,
Rob

You should use the Page Footer, but you cannot use your expression in
the page footer.

See Microsoft Knowledgebase article
132017 "How to sum a column of numbers in a report by page"

Use that method.