2 Replies Latest reply on Dec 15, 2011 8:45 AM by philmodjunk

    "get" summary data

    catinthehat

      Title

      "get" summary data

      Post

      i have a report with summary fields in the subsummary part. I want to  get the values of these summary fields and set a field on a nother layout with summary data. problem is that summary fields are layout dependant. For example, i want to get the sum of the amount paid for all flagged records that are, lets say, Category 1. In the report its a simple find but lets say i want that data to appear somewhere else where the layout is different. Can i copy and paste it from the layout and set a field somewhere else? I hope I'm clear. any help would be much appreciated.

        • 1. Re: "get" summary data
          Sorbsbuster

          You can use the GetSummary function to get the summary value of the records.

          • 2. Re: "get" summary data
            philmodjunk

            Actually, summary fields are not really layout dependent though it can look that way. The value returned by a reference to a summary field depends on either:

            1) The table occurrence of the current layout. (Summary fields when accessed directly, return values determined by the current found set and sort order. Each table occurrence has it's own found set and sort order.) When you reference the value on a layout that is based on the table where it is defined, you get the grand total just as though you put it in the footer or a grand summary part. As sorbsbuster has already indicated, you can use get Summary to extract the sub total shown in a sub summary part--but one of the records in this group must be your current record.

            2) The relationship between the current record and the related table where the summary field is defined. If the summary field is defined in a related table, the value returned will be the summary value of all related records. If you define a total amount summary field in an invoice systems line items table, referring to it from an Invoices record will produce the total of all lineItems records for that one invoice.