subtotal of a calculated field

[Jacqueline]

I have setup a sum calculation for the number of students that use a study
room in the footer for each group. (grouped by room)

Next I would like to have a grand total of student for all rooms at the end
of the report. Is there a way to subtotal the calculated text fields I setup
for each room?

Thanks

 

[Golfinray]

Use the REPORT footer (you will probably have to go to the bottom and pull it
out.)
Use =sum([whatever])

 

[Marshall Barton]

I have setup a sum calculation for the number of students that use a study
room in the footer for each group. (grouped by room)

Next I would like to have a grand total of student for all rooms at the end
of the report. Is there a way to subtotal the calculated text fields I setup
for each room?

You can use a hidden text box (named txtRunTotal), Set its
expression to =[the calculated text box]
and its RunningSum property to Over All

Then the grand total text box in the report footer would use
the expression =txtRunTotal

 

[Jacqueline]

That is what I tried and it did not work.
--
Jacqueline

Use the REPORT footer (you will probably have to go to the bottom and pull it
out.)
Use =sum([whatever])

I have setup a sum calculation for the number of students that use a study
room in the footer for each group. (grouped by room)

Next I would like to have a grand total of student for all rooms at the end
of the report. Is there a way to subtotal the calculated text fields I setup
for each room?

Thanks

 

[Jacqueline]

Marsh,
This got me part way there, however it only totaled the last room useage, it
did not give me a total for all the rooms on the report. I tried setting it
for the entire group as well as over-all neither worked. Ideas?
Thanks much for your help
--
Jacqueline

I have setup a sum calculation for the number of students that use a study
room in the footer for each group. (grouped by room)

Next I would like to have a grand total of student for all rooms at the end
of the report. Is there a way to subtotal the calculated text fields I setup
for each room?

You can use a hidden text box (named txtRunTotal), Set its
expression to =[the calculated text box]
and its RunningSum property to Over All

Then the grand total text box in the report footer would use
the expression =txtRunTotal

 

[Jacqueline]

Marsh,
I figured out what I was doing wrong. I located the grand total in the
report footer, once I moved it to the group footer it worked. Thanks
--
Jacqueline

I have setup a sum calculation for the number of students that use a study
room in the footer for each group. (grouped by room)

Next I would like to have a grand total of student for all rooms at the end
of the report. Is there a way to subtotal the calculated text fields I setup
for each room?

You can use a hidden text box (named txtRunTotal), Set its
expression to =[the calculated text box]
and its RunningSum property to Over All

Then the grand total text box in the report footer would use
the expression =txtRunTotal