Coding TopN in CR8 RDC /VB, Please Help!!! 1

[dotnetprogrammer]

I need to generate a report that derives its info off a database.

For the sake of simplicity, lets say, only two fields and only few hundred records. The first field contains employee numbers (Datatype: Text), and the second field contains length of employment (Datatype: numeric).

My questions are:
(1) How do I code RDC so that the report will generate (top 10, top 20, or whatever) employee list (per length of employment,) and
(2) At runtime, how do I do prompting the user to enter the top value?

I am using CR8 RDC within VB6.

Thanks in advance!!!

 

[MalcolmW]

For 1) see

http://support.seagatesoftware.com/library/kbase/articles/c2007096.asp

2) should be do-able after reading 1) - the N can be a parameter

 

[dotnetprogrammer]

Thanks a lot MalcolmW, I appreciate your response!