Sr. No in Reports ---- KRISH

[KRISH]

Hi Everyone,
I am desining a report with group levels as follows:
(1) HID - Hostel ID
(2) DID - Department ID
I want my Serial No should be like 1,2,3,4... on HID. I palced a textbox
control in detail section and set control source to =1 and running sum =Over
group. This restarting the no for each department. How to restarting the no
department wise so that it should continue to give serial no for students
hostel wise. Please help.

Thanks
KRISH

 

[Duane Hookom]

If you want to create a "serial number" on HID, add a text box to the HID
header section:
Control Source: =1
Running Sum: Over All

 

[KRISH]

Thanks Mr. Duane,
But your answer will not solve the problem. Because your solution will
continuing numbering for all hostels instead starting no with each hostel. I
need the output like below:

Hostel ID: H1

SL No Studetn name Dept
1 abc D1
2 xyz D1

Total in D1 : 2

3 pqr D2
4 stu D2
5 kp D2

Total in D2 : 3

--------------------------------------

Hostel ID: H2

SL No Studetn name Dept
1 def D2
2 xy D2

Total in D2 : 2

3 rst D3
4 st D3
5 kpl D3

Total in D3 : 3

 

[Duane Hookom]

You could create a sequence/ranking number in your query.