S
Supe
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.
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.