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
Loading
Iftikar HussainPosted Jul 29, 2013, 4:38 AM
Regards,
Iftikar
Ravi ShekharPosted Jul 29, 2013, 4:28 AM
Nahul AntonyPosted Jul 29, 2013, 4:21 AM
CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
DataSet ds = new DataSet();
ds = fnPrintLoan(No);
strReportPath = Application.StartupPath + "\\Reports\\LoanNo.rpt";
rpt.Load(strReportPath);
rpt.SetDataSource(ds);
rpt.Refresh();
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.RefreshReport();
crystalReportViewer1.ShowCloseButton = true;
crystalReportViewer1.DisplayGroupTree = true;
crystalReportViewer1.ShowRefreshButton = true;
crystalReportViewer1.ShowGroupTreeButton = true;
crystalReportViewer1.ShowPrintButton = true;
Iftikar HussainPosted Jul 29, 2013, 4:03 AM
Please provide more details.
Regards,
Iftikar