Record Count by group in report

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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 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
Click to expand...
Click to expand...
 
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top