Order on record count

[Frank336]

Hi,

Im using VB 6, RDC, Access 2000.

I have that structure.

ID Data
1 A
2 B
1 D
3 A
2 V
2 Z
...


I have a groupheader on ID. I would like to order my ID based on the number of "Data" in a report that would look like this :

---
ID
2

Data
B
V
Z

---
ID
1

Data
A
D

---
ID
3

Data
A


How can I do that ?


Thanks,
Christian

 

[IdoMillet]

Create a summary returning the count:
Count({some_not_null_field, {ID})

Then use the TopN/Sort Group expert (under the Report menu)
to sort the groups by that count.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Frank336]

Thank you so much !