Crystal Report not displaying data

Question

Crystal Report not displaying data even when Dataset has value.Please Help me?

Francis Bastin · Answer

Hi sushant, Post your code to bind datasource to report.

sushant yejare · Answer

Here Is My Code 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(); } } }