One last time... Sub summaries, variable lists, and whatnot...

I am still having issues with this problem.. Many of you all have
helped me so much, and what I've learned I've been able to apply
elsewhere, but this is a true monkey on my back. Please help, or ask
for clarification if somethings doesn't make sense.

Using Filemaker v6.04

Part setup (top to bottom)
--> Leading Grand Summary
--> Sub-summary b Project Name (leading)
--> Sub-summary by SiteID (leading)
--> Body
--> Sub-summary by Total # of calls (trailing)
--> Sub-summary by total minutes
--> Sub-summary by PROJ_SITE******* <<-this is the one I think is the
troublemaker
--> Sub-summary by Project Name (Trailing)

Image of Report (as best as I can do it in ascii) when completed
======================================================

Monthly Site Report
------------------------------

PROJECT NAME: MICKEY
SITEID: ABC

Control # Site ID Date Proj Name Total calls
Total Minutes
-------------- -------------- --------------
-------------- -------------- --------------
12345 ABC 08-13-07 MICKEY 1
00:12
23456 ABC 08-13-07 MICKEY 2
00:20

SITE: DEF

Control # Site ID Date Proj Name Total calls
Total Minutes
-------------- -------------- --------------
-------------- -------------- --------------
34567 DEF 08-01-07 MICKEY 3
00:20

SITE: GHI

Control # Site ID Date Proj Name Total calls
Total Minutes
-------------- -------------- --------------
-------------- -------------- --------------
34567 GHI 08-06-07 MICKEY
6 01:05

----------------------------------------------------------------------------------------------------------
Total Control #: 6
Total # of Sites: ???
Total # of Calls: 16
Total # of Time: 02:15
======================================================

Now, also on the report are other project summaries. What our people
are tracking is the number of calls related to a particular Control #,
how long the sum of the calls are, and of course, what sites are
calling in for help on any particular project.

All of the sub-summaries are set up so that at the end of every
Project Grouping, I also get a summary of Total # of Control # log
entries made, Total # of calls made on this project, Total number of
Minutes of assistance given on this project, and total # of Sites
calling in.

My issue is that no matter what I do, I cannot make the Total # of
Sites calculation come up correct. Everything else calculates fine
and gives me summaries for all the projects as expected.

If anyone thinks they can be of assistance on this problem, I'd be
happy to send them a clone with sample information in it, or screen
shots of how I have my layout made out.

I know I probably need to use variable lists, but I just cannot get my
head wrapped around how to calculate totals using them. I feel so
completely out of my league on this problem. Help!

- Teresa K.

.

Relevant Pages

  • RE: Errors in Report total fields
    ... subtotal control ... Are PaymentTotal and ExpenseTotal in the REPORT footer of each subreport? ... reports to get their totals data from the fields of the report which come ...
    (microsoft.public.access.reports)
  • Re: Query Help
    ... Make a copy og that Report so ... Name of a control MUST be different from the ControlSource. ... of the control in the detail band and NOT it's ControlSource. ... you will get 22 bands displaying totals. ...
    (microsoft.public.access.forms)
  • RE: Errors in Report total fields
    ... A main report can have controls on it. ... One type of control you can add to a report ... The subreport CONTROL has a couple important ... reports to get their totals data from the fields of the report which come ...
    (microsoft.public.access.reports)
  • RE: Errors in Report total fields
    ... The name I gave you is the name of the control. ... open the properties for the subreport, the name line of the Other Tab says ... are all in the same detail section of the main report. ... reports to get their totals data from the fields of the report which come ...
    (microsoft.public.access.reports)
  • Still Hoping for help with a Query problem
    ... Brett, ... I already have a report that shows this data ... > Name of a control MUST be different from the ControlSource. ... you will get 22 bands displaying totals. ...
    (microsoft.public.access.forms)