Connecting Tech Pros Worldwide Help | Site Map

How to display record count in areport

Newbie
 
Join Date: Nov 2006
Posts: 3
#1: Nov 10 '06
hi, friends pl help me, how to display record count in a report for a grouped records
Familiar Sight
 
Join Date: Mar 2006
Location: Northampton, England
Posts: 143
#2: Nov 10 '06

re: How to display record count in areport


You will need to do this for each group. In the group header put a textbox with a control source of

=1

and set it's running sum property to Over Group. Name it txtCount. Make the textbox tiny and then make the group header 0 height. Then in your group footer, put a textbox with a control source of:

=txtCount
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,693
#3: Nov 10 '06

re: How to display record count in areport


Another way :-
In Design view of the report, select 'Report Header/Footer' from the View menu to add a Report Footer section.
In here add a TextBox field, txtCount, and set the 'Control Source' to count the number of records.
If your records have a TextBox in the detail section called txtName, for instance, try
Expand|Select|Wrap|Line Numbers
  1. =Count(txtName)
in the 'Control Source'.
Newbie
 
Join Date: Nov 2006
Posts: 3
#4: Nov 14 '06

re: How to display record count in areport


Thamks NeoPa
MY problem is ,
i have institution code, registre number of a student in a records
Now i want to group institution-wise and should display register number of each students in a serial within each group. Can you help me
Newbie
 
Join Date: Nov 2006
Posts: 3
#5: Nov 14 '06

re: How to display record count in areport


[quote=mahadevk]hi, friends pl help me,
how to display records serially in a group on a Report
institution : 100
1. 1233
2. 1234
instituion : 101
1. 2301
2.2331
Reply