Hi Jean, 

We create variables in our reports.  They can store all kinds of data including values and bring them into your Main Report.  They also don't slow down run time with your reports which linking on formulas can sometimes do.  

Here is an example:
In your Subreport create a formula called Set Total Value:
Shared NumberVar TV := SUM({OBJINSURANCE.VALUE});
TV is a randomly assigned setting which to me means Total Value.  

Then in your Main Report create a formula called Get Total Value:
Shared NumberVar TV;
Make sure your Subreport is located in a section that comes before you use the value you assign in the Main Report.  So if your Subreport pulls in values from the Detail section and you want your total to appear in the GroupHeader instead of the GroupFooter it will not work.  

Also, I would recommend resetting your variable.  Then in your Main Report create a formula called Reset Total Value:
Shared NumberVar TV := 0;
This formula is created and placed in the Main Report in an area that comes after you have printed the TV value.  This will reset the value back to 0.  If you don't and the next loop comes up with a null the value will stay the same value as the previous value.

Let me know if you have any questions.

Thanks.
Carole.
-- 

Carole Campbell
Registrar for Collections Management
J. Paul Getty Museum
1200 Getty Center Drive, Suite 1000
Los Angeles, CA 90049
[log in to unmask]

>>> On Friday, February 02, 2007 at 8:45 AM, Jean Libert <[log in to unmask]> wrote:
> Does anyone know how to sum up a list of values from a subreport onto the
> linked main report?
> 
> Any assistance would be appreciated.
> 
> Best,
> Jean Libert
> 
> 
> 
> 
> CONFIDENTIALITY NOTICE:
> This email and any attachments thereto are intended solely for use by the
> recipients named above and may contain confidential information.  If you
> are not an intended recipient of this e-mail or if you otherwise received
> this email in error, you are hereby notified that any disclosure, copying,
> distribution or use of this e-mail or any attachment is strictly
> prohibited.  Please notify us immediately by returning it to the sender and
> permanently delete this message and any attachments from your system.  You
> should not retain this e-mail, nor should you disclose all or any part of
> the contents to any other person.  Thank you for your cooperation.