bishoe nb

bishoe nb

  • NA
  • 623
  • 80k

How use Stored Procedures Returning Multiple Result in crs

Aug 20 2018 12:51 AM
i use sp Returning Multiple Result
but how can use this sp in crs
 
data set Get Fitst Query From SP  but another query don't show
 
 this  proc but not full
 
  1. @IDUser int  
  2. ,  
  3. @ID_Member int  
  4. as  
  5. begin  
  6. SELECT   ID_Member, Member_Name, Birth_Date, MaleORFamle, Religion, [Address], Phone_Home, Mobile, Email, Identity_Number, Date_OF_issue, Exp_Date, Del_Flag, Profile_pic, Image_Regisrt, IDUser,   
  7. DateUserAddMember  
  8. FROM         Member_Info  
  9.   
  10.     where ID_Member = @ID_Member and  IDUser = @IDUser and Del_Flag =0  
  11.   end  
  12.     
  13.     
  14.     
  15.     
  16.   ------Untiy_Party  
  17.     
  18. SELECT     Untiy_Party.IDUnity_party, Untiy_Party.Memberof_partisanunit, Member_Info.ID_Member, Member_Info.Del_Flag, Member_Info.IDUser  
  19. FROM         Untiy_Party INNER JOIN  
  20.                       Member_Info ON Untiy_Party.IDUnity_party = Member_Info.IDUnity_party  
  21. WHERE     (Member_Info.ID_Member = @ID_Member) AND (Member_Info.IDUser = @IDUser and Member_Info.Del_Flag = 0)  
  22.    
  23. ------Citys   
  24.  begin  
  25.  SELECT     Citys.IDCity, Citys.City_Name, Member_Info.ID_Member, Member_Info.IDCity AS Expr1, Member_Info.IDUser, Member_Info.Del_Flag  
  26. FROM         Citys INNER JOIN  
  27.                       Member_Info ON Citys.IDCity = Member_Info.IDCity  
  28. where Member_Info.ID_Member = @ID_Member and Member_Info.IDUser = @IDUser and Member_Info.Del_Flag = 0  
  29. end 
procedure contains 260 line = all queries
 
 how can use sp in crystal report
 
 

Answers (5)