In crystal reports data not displaying for C# windows application

See more:

SQL-Server-2008

C#3.5

Hi,

In crystal reports i have used xml file to display the data. the fields are displaying but data is not displayed and parameter filter is also not working.

below is the code:

private void _Toolbar1_Button13_Click(object sender, EventArgs e)
       {
           count = 0;
           DataSet ds = new DataSet();
           DataTable dt = new DataTable();

           SiimsReports.ReportForms.FormReportDisplay frmRpt = new FormReportDisplay();
           SiimsReports.Reports.ServiceRpt objservice = new SIIMS.SiimsReports.Reports.ServiceRpt();

           foreach (string cust in lstCustName .SelectedItems )
           {
               foreach (string reg in lstRegion.SelectedItems )
               {
                   {
                       foreach (string sys in lstSysName.SelectedItems )
                       {
                         string strsql = "select custname,regname ,location ,sysnames ,sysmake ,servicedate ,district,"
                           + " (pendingpoints+'.' +remarks) pendingpoints,batteryreplacedon,servicetype from Leo_ServiceOrder where custname='" + cust + "' "
                           + " and regname='" + reg + "' and  sysnames='" + sys + "' and servicedate between '" + dtpFromDt.Value.ToString("yyyy-MM-dd") + "' and "
                           + "'" + dtpToDt.Value.ToString("yyyy-MM-dd") + "'";

                         dt = objSO.ServiceReport(strsql);

                         if (dt.Rows.Count > 0)
                         {
                             for (int i = 0; i < dt.Rows.Count; i++)
                             {
                                 objSO.custname = dt.Rows[i]["custname"].ToString();
                                 objSO.regname = dt.Rows[i]["regname"].ToString();
                                 objSO.location = dt.Rows[i]["location"].ToString();
                                 objSO.sysnames = dt.Rows[i]["sysnames"].ToString();
                                 objSO.sysmake = dt.Rows[i]["sysmake"].ToString();
                                 objSO.pendingpoints = dt.Rows[i]["pendingpoints"].ToString();
                                // objSO.remarks = dt.Rows[i][""].ToString();
                                 objSO.serviceorderdate = dt.Rows[i]["servicedate"].ToString();
                                 objSO.district = dt.Rows[i]["district"].ToString();
                                 objSO.batteryreplaced = dt.Rows[i]["batteryreplacedon"].ToString();
                                 objSO.servicetype = dt.Rows[i]["servicetype"].ToString();

                                 objSO.InsertServiceRpt();
                             }
                         }

                       }
                   }
               }

           }

           string strqry = "select * from Leo_TempServiceOrder";
           ds = objSO.getServiceReport(strqry);
           string spath = Application.StartupPath;
           string newpath = "C:\\Program Files\\Default Company Name\\LeoSetup\\";
           newpath = newpath + "SiimsReports\\Reports\\ServiceReports.rpt";

           CrystalDecisions.CrystalReports.Engine.ReportDocument myrpt = new ReportDocument();
           myrpt.Load(newpath);
           myrpt.SetDatabaseLogon("sa", "prerana123", @"DISHU-PC\SQLEXPRESS", "LeoNew");

           myrpt.SetDataSource(ds);
           // myrpt.SetParameterValue("SystemName", cmbSystem.Text);
           // myrpt.SetParameterValue("region",cmbregion.Text);
           frmRpt.crViewer.ReportSource = myrpt;
           frmRpt.Show();

}

your help is greatly appriciated.
thanks

What I have tried:

private void _Toolbar1_Button13_Click(object sender, EventArgs e)
{
count = 0;
DataSet ds = new DataSet();
DataTable dt = new DataTable();

SiimsReports.ReportForms.FormReportDisplay frmRpt = new FormReportDisplay();
SiimsReports.Reports.ServiceRpt objservice = new SIIMS.SiimsReports.Reports.ServiceRpt();

foreach (string cust in lstCustName .SelectedItems )
{
foreach (string reg in lstRegion.SelectedItems )
{
{
foreach (string sys in lstSysName.SelectedItems )
{
string strsql = "select custname,regname ,location ,sysnames ,sysmake ,servicedate ,district,"
+ " (pendingpoints+'.' +remarks) pendingpoints,batteryreplacedon,servicetype from Leo_ServiceOrder where custname='" + cust + "' "
+ " and regname='" + reg + "' and sysnames='" + sys + "' and servicedate between '" + dtpFromDt.Value.ToString("yyyy-MM-dd") + "' and "
+ "'" + dtpToDt.Value.ToString("yyyy-MM-dd") + "'";

dt = objSO.ServiceReport(strsql);

if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
objSO.custname = dt.Rows[i]["custname"].ToString();
objSO.regname = dt.Rows[i]["regname"].ToString();
objSO.location = dt.Rows[i]["location"].ToString();
objSO.sysnames = dt.Rows[i]["sysnames"].ToString();
objSO.sysmake = dt.Rows[i]["sysmake"].ToString();
objSO.pendingpoints = dt.Rows[i]["pendingpoints"].ToString();
// objSO.remarks = dt.Rows[i][""].ToString();
objSO.serviceorderdate = dt.Rows[i]["servicedate"].ToString();
objSO.district = dt.Rows[i]["district"].ToString();
objSO.batteryreplaced = dt.Rows[i]["batteryreplacedon"].ToString();
objSO.servicetype = dt.Rows[i]["servicetype"].ToString();

objSO.InsertServiceRpt();
}
}

}
}
}

}

string strqry = "select * from Leo_TempServiceOrder";
ds = objSO.getServiceReport(strqry);
string spath = Application.StartupPath;
string newpath = "C:\\Program Files\\Default Company Name\\LeoSetup\\";
newpath = newpath + "SiimsReports\\Reports\\ServiceReports.rpt";

CrystalDecisions.CrystalReports.Engine.ReportDocument myrpt = new ReportDocument();
myrpt.Load(newpath);
myrpt.SetDatabaseLogon("sa", "prerana123", @"DISHU-PC\SQLEXPRESS", "LeoNew");

myrpt.SetDataSource(ds);
// myrpt.SetParameterValue("SystemName", cmbSystem.Text);
// myrpt.SetParameterValue("region",cmbregion.Text);
frmRpt.crViewer.ReportSource = myrpt;
frmRpt.Show();
}