complex report

[dott]

I have a report which is laid out as follows:

it breaks each service down by location and then says the service name, the quantity, and the cost:

LOCATION SERVICE QUANTITY COST
Sydney
PATCH 55 12,000
SPREAD 45 18,000
DUMP 890 123,000
Antigonish
PATCH 23 12,000
SPREAD 9 11,000


The serivce can be a number of different services.

What i want to do is calculate the sum of each service for each location, that is: i want to add up all the quantities for PATCH, and SPREAD, or whatever _same service_ is offered through out the areas. so i would end up with a total quantity of patch, spread, and dump, regardless of location. (keep in mind the service names could be anything)

is this possible?

 

[jtvcs]

The way I would approach this is to add a subreport to your main report based on a summation query, that is, create a Select query, use the Totals button (on toolbar, has the Sigma symbol) then using two fields: SERVICE and QUANTITY, Group the service and Sum the Quantity. Then tie to the subreport to print at the end of your report. HTH JT

 

[dott]

sounds great ill give it a shot

thanks alot.

 

[dott]

jtvcs,

is it possible for my filter to go through to my subreport?