subtotal of a calculated field

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

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
 
Use the REPORT footer (you will probably have to go to the bottom and pull it
out.)
Use =sum([whatever])
 
Jacqueline said:
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?
Click to expand...


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
 
That is what I tried and it did not work. :(
--
Jacqueline


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

Jacqueline said:
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
Click to expand...
Click to expand...
 
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


Marshall Barton said:
Jacqueline said:
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?
Click to expand...


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
Click to expand...
 
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


Marshall Barton said:
Jacqueline said:
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?
Click to expand...


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
Click to expand...
 
Back
Top