Combo box..

Hi..

Am using vb6.0, crystal report 8.5 and sql 2000 server in my project.. I want to create one combo box in report form in which i ve to display some person names from database..

I did it for date, when we select any date, report displays corresponding information. I had used stored procedure for dis.. Bellow code shows this stored procedure to display info based on date.. But am not getting coding for combo box..

Plz help me in coding..

Code:

---

CREATE PROCEDURE usp_CONTRIBUTION(@StDt Char(10),@EnDt Char(10)) AS     
BEGIN     
     
 Declare  @numrows int,@errno int,@errmsg varchar(255),@error int,     
          @sDt Datetime,@eDt DateTime     
     
  SET NOCOUNT ON       
  SET DATEFORMAT MDy       
  set @sDt=@StDt     
  set @eDt=@EnDt     
     
 /* finding landed cost of each tool from bincards*/     
 SELECT BcTpSlNo,AVG(BcBprice) AS LC,TpSku AS ToolId     
 Into #LC1 
 FROM Bincards,ToProdut 
 WHERE BcTpSlNo=TpSlNo     
 GROUP BY BcTpSlNo,TpSKU   
 ORDER BY BcTpSlNo     
   
 /* finding landed cost of invoiced tools*/     
 SELECT ItIhSlno,ItQty,LC,(LC * ItQty) AS  TLC  INTO #LC2     
 FROM  InvoicTo,#LC1 
 WHERE  BcTpSlNo=ItTpSlNo   

 SELECT ItIhSlNo,SUM(ItQty) as Qty,SUM(LC) as LC,SUM(TLC) as TLC INTO #LC3 FROM #LC2
 GROUP BY ItIhSLNo ORDER By ItIhSlNo

 SELECT  Qty,LC,IhSKU,IhSubtotal as Discounts,IhItemTotal as ItemTotal,
        TLC,(IhItemTotal-IhSubTotal) as AmtAftDis,   
        AdOrganization,AdCity,AdState,Adzone,RtSKU       
 FROM  InvoicHe,#LC3,AddresMt,RatingMt     
 WHERE ItIhSlno=IhSlno     
 AND  IhAdSlno=AdSlno     
 AND  AdRtSlno=RtSlNo     
 AND  Ihdate BETWEEN @SDt AND @EDt
 ORDER BY Ihsku     
   
END
GO

---