Crystal Report not displaying data

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using CrystalDecisions.Shared;

using CrystalDecisions.CrystalReports.Engine;

using SiMYAPetro.Company.Report.Financial.CreditSale;

namespace SiMYAPetro.Company.Report_Views.Financial.CreditSale

{

public partial class rptfrmCustomerReceiptReport : Form

{

public rptfrmCustomerReceiptReport()

{

InitializeComponent();

}

static int Mcode;

//ReportDocument cryRpt;

#region Constructor

public rptfrmCustomerReceiptReport(int code)

{

InitializeComponent();

Mcode = code;

}

#endregion

#region Form Load

private void rptfrmCustomerReceiptReport_Load(object sender, EventArgs e)

{

try

{

CommonClasses.objcon.FillCombo("CR_CODE", "CR_NO", "SELECT CR_CODE,CR_NO FROM CUSTOMER_RECEIPT WHERE ES_DELETE=0 AND CR_CM_CODE='" + frmLogin1.COMPYEARID + "'", cmbFrom);

CommonClasses.objcon.FillCombo("CR_CODE", "CR_NO", "SELECT CR_CODE,CR_NO FROM CUSTOMER_RECEIPT WHERE ES_DELETE=0 AND CR_CM_CODE='" + frmLogin1.COMPYEARID + "'", cmbTo);

cmbFrom.SelectedValue = Mcode;

cmbTo.SelectedValue = Mcode;

}

catch (Exception Ex)

{

CommonClasses.objcon.WriteLog("Customer Receipt", "From Load", Ex);

}

}

#endregion

#region btnShow_Click

//Author: Sushant

//Date:27-02-2018

//This Event is used to show report of Customer Receipt.

private void btnShow_Click(object sender, EventArgs e)

{

string query = string.Empty;

DataSet dtCustomerReceipt1 = new DataSet();

try

{

rptCustomerReceiptReport objrptCustomerReceiptReport = new rptCustomerReceiptReport();

query = "Select COMPANY_MASTER.CM_IMAGE AS CM_IMAGE, " +

"CUSTOMER_RECEIPT.CR_CODE AS CR_CODE," +

"CUSTOMER_RECEIPT.CR_DATE AS CR_DATE," +

"CUSTOMER_RECEIPT.CR_NO AS CR_NO," +

"CUSTOMER_RECEIPT.CR_NARRATION AS CR_NARRATION," +

"LEDGER_MASTER.LM_NAME AS LM_NAME," +

"LM.LM_NAME AS RECEIVED_IN," +

"CUSTOMER_RECEIPT.CR_AMT AS CR_AMT " +

"from CUSTOMER_RECEIPT " +

"Inner Join COMPANY_MASTER on CUSTOMER_RECEIPT.CR_CM_COMP_ID= COMPANY_MASTER.CM_CODE " +

"Inner Join LEDGER_MASTER on CUSTOMER_RECEIPT.CR_LM_CODE=LEDGER_MASTER.LM_CODE " +

"Inner Join LEDGER_MASTER LM on CUSTOMER_RECEIPT.CR_LM_RECEIVED_IN=LM.LM_CODE " +

"Where CUSTOMER_RECEIPT.ES_DELETE=0 " +

"And COMPANY_MASTER.CM_CODE='" + frmLogin1.COMPYEARID + "'";

if (cmbFrom.SelectedIndex == -1 || cmbTo.SelectedIndex == -1)

{

MessageBox.Show("Please Select Receipt", "Simya");

return;

}

else

{

query = query + " And CUSTOMER_RECEIPT.CR_CODE Between " + cmbFrom.SelectedValue + " AND " + cmbTo.SelectedValue + " ";

}

dtCustomerReceipt1 = CommonClasses.objcon.GetDS(query + " AND CUSTOMER_RECEIPT.CR_CM_CODE ='" + frmLogin1.COMPYEARID + "' ORDER BY CR_DATE", "dtCustomer_Invoice_Format");

if (dtCustomerReceipt1.Tables[0].Rows.Count == 0)

{

MessageBox.Show("No data Found");

return;

}

DataTable dtCompanyDetails = CommonClasses.objcon.GetTable("select CM_VATNO,CM_CSTNO,CM_EMAIL_ADDRESS," +

"CST_AUTHO_SIGNATORY,CM_GSTIN " +

"from COMPANY_MASTER,COMPANY_SETTINGS where CM_COMP_ID=" + frmLogin1.COMPID + " " +

"and CM_CODE=" + frmLogin1.COMPYEARID + "");

if (dtCompanyDetails.Rows.Count == 0)

{

MessageBox.Show("Data Not Found");

return;

}

objrptCustomerReceiptReport.SetDataSource(dtCustomerReceipt1);

rptReportView objreportview = new rptReportView();

objreportview.Show();

objrptCustomerReceiptReport.SetParameterValue("txtCompName", frmLogin1.COMPNAME);

objrptCustomerReceiptReport.SetParameterValue("txtTitle", frmLogin1.CM_ADD);

if (dtCompanyDetails.Rows[0]["CM_EMAIL_ADDRESS"] != DBNull.Value)

{

objrptCustomerReceiptReport.SetParameterValue("txtPhone", " Ph.No:" + frmLogin1.CM_PHONE + " Email:" + dtCompanyDetails.Rows[0]["CM_EMAIL_ADDRESS"].ToString());

}

else

{

objrptCustomerReceiptReport.SetParameterValue("txtPhone", " Ph.No:" + frmLogin1.CM_PHONE + " Email:" + " ");

}

//if (dtCompanyDetails.Rows[0]["CM_VATNO"] != DBNull.Value)

//{

// objrptCustomerReceiptReport.SetParameterValue("txtvat", dtCompanyDetails.Rows[0]["CM_VATNO"].ToString());

//}

//else

//{

// objrptCustomerReceiptReport.SetParameterValue("txtvat", " ");

//}

//if (dtCompanyDetails.Rows[0]["CM_CSTNO"] != DBNull.Value)

//{

// objrptCustomerReceiptReport.SetParameterValue("txttin", dtCompanyDetails.Rows[0]["CM_CSTNO"].ToString());

//}

//else

//{

// objrptCustomerReceiptReport.SetParameterValue("txttin","");

//}

//if (dtCompanyDetails.Rows[0]["CST_AUTHO_SIGNATORY"] != DBNull.Value)

//{

// objrptCustomerReceiptReport.SetParameterValue("txtAuthoSignatory", dtCompanyDetails.Rows[0]["CST_AUTHO_SIGNATORY"].ToString());

//}

//else

//{

// objrptCustomerReceiptReport.SetParameterValue("txtAuthoSignatory", "");

//}

//if (dtCompanyDetails.Rows[0]["CM_GSTIN"] != DBNull.Value)

//{

// objrptCustomerReceiptReport.SetParameterValue("txtGSTIN", dtCompanyDetails.Rows[0]["CM_GSTIN"].ToString());

//}

//else

//{

// objrptCustomerReceiptReport.SetParameterValue("txtGSTIN", "");

//}

objreportview.crystalReportViewer1.Refresh();

objreportview.Activate();

objreportview.WindowState = FormWindowState.Maximized;

objreportview.Text = "Customer Receipt Report";

objreportview.crystalReportViewer1.ReportSource = objrptCustomerReceiptReport;

objrptCustomerReceiptReport.Refresh();

}

catch (Exception Ex)

{

CommonClasses.objcon.WriteLog("Customer Receipt", "btnShow_Click", Ex);

}

}

#endregion

#region TabPage Paint

private void mainPanel_Paint(object sender, PaintEventArgs e)

{

CommonClasses.tabpagepaint(this, e);

}

#endregion

private void btnExit_Click(object sender, EventArgs e)

{

this.Close();

}

}

}