Help me in coding....

[arunvb]

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