4
Answers

Crystal Report

Nahul Antony

Nahul Antony

11y
953
1
When Crystal Report Loading they asking discrete values and also the sql server password please help me how to solve this
SQL CODE-

CREATE Procedure prcPrintLoanNo     
(       
@vLoan_No int       
)       
AS       
BEGIN       
SELECT       
LM.iAcId as ACID,LM.vLoan_No as LoanNo,AM.vFirstName as AcName,       
AM.vPermanentAddress as Address,AM.iMobile as MobileNo,LM.dIssue_Date as IssueDate,       
LM.dDue_Date as DueDate,LD.vItem_Id as ItemName,LM.vPurity as Purity,   
LD.iNo_Items as NoofItems,LD.dcGros_Wt as GrossWt,LD.dcStone_Wt as StoneWt,   
LD.dcNet_wt as NetWt,LM.dcLoan_Amt   
from tbl_LoanMaster LM INNER JOIN          
tbl_Acc_AccountMaster AM ON LM.iAcId=AM.iAcId INNER JOIN       
tbl_LoanDetails LD ON LM.vLoan_No=LD.vLoan_No       
Where LM.vLoan_No=@vLoan_No    
       
END
Answers (4)