Multiple sub summaries with calculated results

[shierkev]

Hi,

I have a situation on Reporting that needs to be solved.

I records in a database that have three classifications.

Type

Area

Name

Each of these records has data in it that must be calculated ie

Amount (input directly)

Date (Input directly)

Ownership (input directly) (amount out of 100)

On my report, I need to have it print and sort in this order, with the following data at each of these levels.

I don't have any body details as this is a completely summary report.

Basically, what I want is to have the report show each Name summarized with all relevant totals, and then each AREA summarized (which contain many of the names) and then each TYPE summarized. I can get the Name and Type summarized properly, but the AREA calculations that I need don't work right.

Type (subsummary part)

Name (subsummary Part) - Fields - sum(Amount), Sum(Amount)/7, sum(Amount)*Ownership/100

Area (subsummary part) - Fields)- sum(Amount), Sum(Amount)/7, sum (amount) * Ownership/100

Here is the problem. On the sub-summary part for Name, no problems.

On the sub summary part for Area, I want to add up each of the sum(amount)*Ownership/100 fields, so that I have a total of amount*Ownership with each one calculated by name prior to adding them together, but displayed in the summary part for Area. What I get is that it calculates each one based on the last Ownership field it finds, which is not correct. I want it to calculate each records ownership and THEN add it together. I seem to be stuck in a mind trap on this one.

[Kurt Knippel]

quote:

---

Originally posted by shierkev:

Type

Area

Name

Type (subsummary part)

Name (subsummary Part) - Fields - sum(Amount), Sum(Amount)/7, sum(Amount)*Ownership/100

Area (subsummary part) - Fields)- sum(Amount), Sum(Amount)/7, sum (amount) * Ownership/100

---

Ok, first off you have the sort order and part order in conflict. You should have them in the same pattern. Type, then Area, then Name.

That alone is likely to be the problem.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[shierkev]

Thanks, but I have that set right,

Any other suggestions?

[shierkev]

Thanks, I found the fix. I was missing a field that would normally go in the body but because I didn't have a body, I hadn't created that field yet.

Sorry for the inconvienience.