Printing group totals in the page or report header

C

Claire

I have a report grouped by department, with each department totaled in the
group footer, and the company total (grand total) in the report footer. All
of this is working just as desired.

However, I am trying to replicate a previous excel report (in formatting),
which has the department totals and company total repeated at the top of the
page. I could work with it in the report or page header. Is there a way to
list the group totals in the page or report header or do I need to add a new
calculated field and put in a conditional sum, depending on the departments?

Thanks for your suggestions!
 
J

Jacqueline

Claire,
The first thing that comes to mind is to build a mimic text box at the top
of your report that reflects the data in your totals at the bottom. You can
do this in the properties of the new text box at the top. I have done this in
forms and the code looks like this:

[forms]![NameOfYourForm]![NameOfTextField]

I would bet the syntax is pretty much the same for a report. Hope this helps.
Jacqueline
 
C

Claire

Jacqueline,
I like your thinking, but sadly the text boxes don't have names, just
equations, which when placed in the headers results in a #Error.

~Claire
Jacqueline said:
Claire,
The first thing that comes to mind is to build a mimic text box at the top
of your report that reflects the data in your totals at the bottom. You can
do this in the properties of the new text box at the top. I have done this in
forms and the code looks like this:

[forms]![NameOfYourForm]![NameOfTextField]

I would bet the syntax is pretty much the same for a report. Hope this helps.
Jacqueline
--
Jacqueline


Claire said:
I have a report grouped by department, with each department totaled in the
group footer, and the company total (grand total) in the report footer. All
of this is working just as desired.

However, I am trying to replicate a previous excel report (in formatting),
which has the department totals and company total repeated at the top of the
page. I could work with it in the report or page header. Is there a way to
list the group totals in the page or report header or do I need to add a new
calculated field and put in a conditional sum, depending on the departments?

Thanks for your suggestions!
 
J

Jacqueline

Claire,
Every text box has a name. Even if you did not assign the name the
application did. Click on the text box that contains the calculation then
right click and select properties.

On the All tab, the Name field should be at the top of the list. That is the
name you will use, exactly, I even copy and past that directly to make sure
I have it exact.
Let me know if this helps
--
Jacqueline


Claire said:
Jacqueline,
I like your thinking, but sadly the text boxes don't have names, just
equations, which when placed in the headers results in a #Error.

~Claire
Jacqueline said:
Claire,
The first thing that comes to mind is to build a mimic text box at the top
of your report that reflects the data in your totals at the bottom. You can
do this in the properties of the new text box at the top. I have done this in
forms and the code looks like this:

[forms]![NameOfYourForm]![NameOfTextField]

I would bet the syntax is pretty much the same for a report. Hope this helps.
Jacqueline
--
Jacqueline


Claire said:
I have a report grouped by department, with each department totaled in the
group footer, and the company total (grand total) in the report footer. All
of this is working just as desired.

However, I am trying to replicate a previous excel report (in formatting),
which has the department totals and company total repeated at the top of the
page. I could work with it in the report or page header. Is there a way to
list the group totals in the page or report header or do I need to add a new
calculated field and put in a conditional sum, depending on the departments?

Thanks for your suggestions!
 
C

Claire

Thanks for the info on that one, Jacqueline. Somehow I glossed over the
properties name. And it ALMOST works. The problem rests in the fact that
each of the group totals has the same name, so the report only shows the
value of the first group total. This will work for replicating the grand
total, but not for the breakups. So, any other brainstorms out there?

Thanks,
Claire

Jacqueline said:
Claire,
Every text box has a name. Even if you did not assign the name the
application did. Click on the text box that contains the calculation then
right click and select properties.

On the All tab, the Name field should be at the top of the list. That is the
name you will use, exactly, I even copy and past that directly to make sure
I have it exact.
Let me know if this helps
--
Jacqueline


Claire said:
Jacqueline,
I like your thinking, but sadly the text boxes don't have names, just
equations, which when placed in the headers results in a #Error.

~Claire
Jacqueline said:
Claire,
The first thing that comes to mind is to build a mimic text box at the top
of your report that reflects the data in your totals at the bottom. You can
do this in the properties of the new text box at the top. I have done this in
forms and the code looks like this:

[forms]![NameOfYourForm]![NameOfTextField]

I would bet the syntax is pretty much the same for a report. Hope this helps.
Jacqueline
--
Jacqueline


:

I have a report grouped by department, with each department totaled in the
group footer, and the company total (grand total) in the report footer. All
of this is working just as desired.

However, I am trying to replicate a previous excel report (in formatting),
which has the department totals and company total repeated at the top of the
page. I could work with it in the report or page header. Is there a way to
list the group totals in the page or report header or do I need to add a new
calculated field and put in a conditional sum, depending on the departments?

Thanks for your suggestions!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top