Record Count by group in report

G

Guest

Hi,
Please advise simple way to count group record , I am trying to use "=
count([fieldname]) with running sum = Over group in detail section and then
trying to get results in group footer section.

Its showing 132 records first group and then keep adding record count not
showing individual count which is wrong.

Thanks for your help in advance .

Prince
 
J

Jeff L

You want the running sum to be No. With your setting the way it is
now, you are saying you want to add all the counts together, which
(suprise, suprise!) it is doing.

Hope that helps!
 
G

Guest

Hi Jeff,
My appologize, To be very frank I could not understand your reply, yes! I
simply need sum of records in a group (which is group by date) which should
print @ group footer - thanks.

Jeff L said:
You want the running sum to be No. With your setting the way it is
now, you are saying you want to add all the counts together, which
(suprise, suprise!) it is doing.

Hope that helps!

Hi,
Please advise simple way to count group record , I am trying to use "=
count([fieldname]) with running sum = Over group in detail section and then
trying to get results in group footer section.

Its showing 132 records first group and then keep adding record count not
showing individual count which is wrong.

Thanks for your help in advance .

Prince
 
J

Jeff L

You said "I am trying to use =count([fieldname]) with running sum =
Over group in detail section". I am saying to change the running sum
to No. Your setting the way it is, is telling your report to add all
the counts together, which from your description is not what you
wanted. Change the running sum setting to No and that should fix your
problem.

Hi Jeff,
My appologize, To be very frank I could not understand your reply, yes! I
simply need sum of records in a group (which is group by date) which should
print @ group footer - thanks.

Jeff L said:
You want the running sum to be No. With your setting the way it is
now, you are saying you want to add all the counts together, which
(suprise, suprise!) it is doing.

Hope that helps!

Hi,
Please advise simple way to count group record , I am trying to use "=
count([fieldname]) with running sum = Over group in detail section and then
trying to get results in group footer section.

Its showing 132 records first group and then keep adding record count not
showing individual count which is wrong.

Thanks for your help in advance .

Prince
 

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