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.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);
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();
}