Counting Regions

[Guest]

I have a report that list the different items of a vendor and below the
individual stores that carry that item that includes which region that store
is in. I would like to creat a new report that shows just the total number
of stores for each region under each item. I created a "Text Count" text box
and changed the control source to =1 and the Running Sum over to Over Group.
I then added a text box with =Text Count in the Item footer section of the
report. When I run the report it seems that it is adding the information
from previous item(s) for my region totals on to the next item on the list.
I want my report to look like the example below.

Item 1 Description
Region 1 Total
REgion 2 Total
Region 3 Total
Region 4 Total
Grand Total for Item 1

Item 2 Description
Region 1 Total
Region 2 Total
Region 3 Total
Region 4 Total
Grand Total for Item 2

Would like the Grand Total of all the regions for each item at the end as
well, but haven't attempted to try that yet.

 

[Marshall Barton]

I have a report that list the different items of a vendor and below the
individual stores that carry that item that includes which region that store
is in. I would like to creat a new report that shows just the total number
of stores for each region under each item. I created a "Text Count" text box
and changed the control source to =1 and the Running Sum over to Over Group.
I then added a text box with =Text Count in the Item footer section of the
report. When I run the report it seems that it is adding the information
from previous item(s) for my region totals on to the next item on the list.
I want my report to look like the example below.

Item 1 Description
Region 1 Total
REgion 2 Total
Region 3 Total
Region 4 Total
Grand Total for Item 1

Item 2 Description
Region 1 Total
Region 2 Total
Region 3 Total
Region 4 Total
Grand Total for Item 2

Would like the Grand Total of all the regions for each item at the end as
well, but haven't attempted to try that yet.

You can not create a meaningful report until you create a
query the provides the proper data. In this case, I think
you might want a query like:

SELECT Item, Region, Count(*) As CountOfStores
FROM sometable
GROUP BY Item, Region

With something like that as the report's record source the
report should be very simple with grouping by Item. A text
box with the expression =Sum(CountOfStores)
can display the subtotal for each group and the grand total.