4 Replies Latest reply on Dec 13, 2011 1:35 PM by MikeF

    Report summary fields

    MikeF

      Title

      Report summary fields

      Post

       

      Constructing a report based on Events table, that has the Project info in the header, and all the Events listed below that are related to the Project [by Event::__kf_ProjectID].

      Using portals for the Events>Revenue and Events>Expenses tables that are working fine.  These are in the body of the report.

      But in the header, or somewhere above all the event listings, need to have the *aggregate* Revenue and Expenses for each project, which are based on Summary fields in the Events>Revenue and Events>Expenses tables.

      How can I get both in there?

      Thanks,

        Mike

       

       

        • 1. Re: Report summary fields
          philmodjunk

          Just add the summary fields defined in Revenue and Expenses to the header of your layout. The relationship will limit the totals returned to just those from the related records in each table.

          • 2. Re: Report summary fields
            MikeF

            That's the first thing I did, doesn't work.

            Say there are ten events with revenue of $1000 each.  Since the layout is based on Events, the $1000 for each event is fine in the body.

            But when I put that Summary field in the header, still get $1,000 --- not $10,000.

            • 3. Re: Report summary fields
              philmodjunk

              I may be assuming a different relationship here.

              What relationships have you defined for the expenses and revenue portals?

              What I am describing would report a total of all the entries in one of these portals.

              If you have one portal for each event record, then a different approach is needed.

              Define a calculation field, cExpenseTotal and put the summary field from Expenses as the sole term for your calculaiton. Then define a summary field in Events, sTotalExpenseTotal as the total of cExpenseTotal.

              • 4. Re: Report summary fields
                MikeF

                 

                I did something like that by putting the Summary field[s] from Revenue and Expenses as calculated fields in Projects.

                Was trying to avoid that, but it had to be done and all is working.

                Thanks Phil.

                  Mike