Count Region only once

G

Guest

My report is separated into Regions where the Region name is the header for
that section. There could be multiple entries for that region but it will
only show the name once on the report then the other info are line items
below. I would like a count of the total regions listed on the report but
what I am getting is the total count of each line item. I assume it is
trying to count as if each region was listed with each line item. How can I
get it to count the region only 1 time?
 
G

Guest

In the section where the region is create another text box, and set this
properties

ControlSource = "=1"
Running Sum = Yes
Visible = False

In the Report footer create another text field and in the ControlSource write
=[FieldNameCreatedAbove]
 
G

Guest

this doesn't seem to work exactly right. I have a total of 6 regions in my
example however when I put the field in the group footer to equal my field
name it returns 23. Any ideas?

Ofer Cohen said:
In the section where the region is create another text box, and set this
properties

ControlSource = "=1"
Running Sum = Yes
Visible = False

In the Report footer create another text field and in the ControlSource write
=[FieldNameCreatedAbove]

--
Good Luck
BS"D


Todd said:
My report is separated into Regions where the Region name is the header for
that section. There could be multiple entries for that region but it will
only show the name once on the report then the other info are line items
below. I would like a count of the total regions listed on the report but
what I am getting is the total count of each line item. I assume it is
trying to count as if each region was listed with each line item. How can I
get it to count the region only 1 time?
 
G

Guest

Disregard the last post. I was naming my field Count and apparently that was
throwing it off. I renamed the field and it works.

Ofer Cohen said:
In the section where the region is create another text box, and set this
properties

ControlSource = "=1"
Running Sum = Yes
Visible = False

In the Report footer create another text field and in the ControlSource write
=[FieldNameCreatedAbove]

--
Good Luck
BS"D


Todd said:
My report is separated into Regions where the Region name is the header for
that section. There could be multiple entries for that region but it will
only show the name once on the report then the other info are line items
below. I would like a count of the total regions listed on the report but
what I am getting is the total count of each line item. I assume it is
trying to count as if each region was listed with each line item. How can I
get it to count the region only 1 time?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top