Sum in Reports Issue

[eforce]

I have Companies A & B. Both companies have lets say fields: [one] & [two].

I know how to use the grouping feature for reports to set either a "Company A Header/Footer" or "Company B Header/Footer"

I want to have "Company A" give me a sum for its fields seperate from "Company B's" sums for it's fields.

When I group by Companies and attempt to get a sum, the report sums the entire report fields for Company A & B rather than summing Company A and then seperately giving me a total for Company B.

If anyone understands my problem please reply ASAP!

Thanks

E-Force!

 

[llkhoutx]

Use subreports to build the appropriate sums.

 

[Rich]

Put the Sum in the Company group footer

 

[HaChIrish]

I have a similar question about 2 companies, but both companies are part of the same table. I have another table called OPTIONS that has SOLD, DECLINE, REJECT, etc. as options but they are all under one column. How would I get the numbers of SOLD policies for 1 company in a report? I have a SOLD QUERY with "SOLD" as the criteria under the OPTIONS column (combo box I think). How do I get the report to list the sum of SOLD policies for just 1 company?