If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Totals
Hello,
I have created a report with a sub report. I would like to add a Total field in my main Report Footer that calculates the sum of a field in my Sub Report. I thought I could get away with: =Sum(subreport.Report!field) but it's not working. What am I doing wrong? Thanks, Helen |
#2
|
|||
|
|||
Totals
Try doing the calculation in the Sub report footer then set the text box in
the report footer to that field name. You can always hide it in the sub report if you don;t want to see it there. I don't know why it does not work the other way. HTH Sheila "Helen" wrote: Hello, I have created a report with a sub report. I would like to add a Total field in my main Report Footer that calculates the sum of a field in my Sub Report. I thought I could get away with: =Sum(subreport.Report!field) but it's not working. What am I doing wrong? Thanks, Helen |
#3
|
|||
|
|||
Totals
Hi there,
I must be doing something wrong. I created a sum field in the report footer of my subreport. It's called Text17. Then I created another sum field in the main report footer like this: =(Sum(srpt_MasterBillOfLading.Report!Text17)) but when I run the report it asks me for the Parameter Value. Any suggestions what I'm doing wrong? Thanks! Helen "Sheila D" wrote in message ... Try doing the calculation in the Sub report footer then set the text box in the report footer to that field name. You can always hide it in the sub report if you don;t want to see it there. I don't know why it does not work the other way. HTH Sheila "Helen" wrote: Hello, I have created a report with a sub report. I would like to add a Total field in my main Report Footer that calculates the sum of a field in my Sub Report. I thought I could get away with: =Sum(subreport.Report!field) but it's not working. What am I doing wrong? Thanks, Helen |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I get the sum from a column and display the sum? | jon | General Discussion | 9 | March 11th, 2005 05:22 PM |
count number of records | Joe_Access | General Discussion | 1 | January 13th, 2005 06:27 PM |
Totals by date on report footer | Brent | Setting Up & Running Reports | 1 | October 9th, 2004 03:33 AM |
Totals on a Report | GERS | Setting Up & Running Reports | 1 | September 30th, 2004 03:16 PM |
Running totals on different worksheet | Clayton | Worksheet Functions | 1 | December 15th, 2003 03:50 PM |