Click here to Skip to main content
15,886,813 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to view board component and capacitor Pin
Eddy Vluggen25-Mar-16 4:29
professionalEddy Vluggen25-Mar-16 4:29 
GeneralRe: How to view board component and capacitor Pin
regerteast25-Mar-16 5:38
regerteast25-Mar-16 5:38 
GeneralRe: How to view board component and capacitor Pin
Eddy Vluggen25-Mar-16 7:15
professionalEddy Vluggen25-Mar-16 7:15 
AnswerRe: How to view board component and capacitor Pin
Amarnath S23-Mar-16 7:03
professionalAmarnath S23-Mar-16 7:03 
Questionhow to select all files automatically from zip file in c# Pin
Member 1237430822-Mar-16 7:00
Member 1237430822-Mar-16 7:00 
AnswerRe: how to select all files automatically from zip file in c# Pin
Richard MacCutchan22-Mar-16 7:23
mveRichard MacCutchan22-Mar-16 7:23 
AnswerRe: how to select all files automatically from zip file in c# Pin
koolprasad200322-Mar-16 18:21
professionalkoolprasad200322-Mar-16 18:21 
QuestionCrystal Reports Data not displaying Pin
prerana@200922-Mar-16 5:27
prerana@200922-Mar-16 5:27 
C#
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:

C#
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();



Please help me in resolving the above issue.

Thanks
AnswerRe: Crystal Reports Data not displaying Pin
OriginalGriff22-Mar-16 6:03
mveOriginalGriff22-Mar-16 6:03 
AnswerRepost Pin
Richard Deeming22-Mar-16 6:27
mveRichard Deeming22-Mar-16 6:27 
QuestionHandling Cross thread Pin
pradipkilledar22-Mar-16 2:09
pradipkilledar22-Mar-16 2:09 
AnswerRe: Handling Cross thread Pin
Richard Deeming22-Mar-16 2:58
mveRichard Deeming22-Mar-16 2:58 
GeneralRe: Handling Cross thread Pin
pradipkilledar27-Mar-16 22:22
pradipkilledar27-Mar-16 22:22 
GeneralRe: Handling Cross thread Pin
Richard Deeming29-Mar-16 1:45
mveRichard Deeming29-Mar-16 1:45 
QuestionGet Picture Using PictureBox Handle Pin
Django_Untaken21-Mar-16 7:29
Django_Untaken21-Mar-16 7:29 
AnswerRe: Get Picture Using PictureBox Handle Pin
User 740747021-Mar-16 8:43
User 740747021-Mar-16 8:43 
QuestionI want to generator serial numbers for rows in datagrid Pin
Engr. Yange21-Mar-16 3:06
Engr. Yange21-Mar-16 3:06 
AnswerRe: I want to generator serial numbers for rows in datagrid Pin
Eddy Vluggen22-Mar-16 7:17
professionalEddy Vluggen22-Mar-16 7:17 
QuestionUpdating the UI from a Rx background thread Pin
Kenneth Haugland20-Mar-16 23:38
mvaKenneth Haugland20-Mar-16 23:38 
AnswerRe: Updating the UI from a Rx background thread Pin
Luc Pattyn21-Mar-16 15:10
sitebuilderLuc Pattyn21-Mar-16 15:10 
GeneralRe: Updating the UI from a Rx background thread Pin
Kenneth Haugland21-Mar-16 19:16
mvaKenneth Haugland21-Mar-16 19:16 
GeneralRe: Updating the UI from a Rx background thread Pin
Luc Pattyn21-Mar-16 19:35
sitebuilderLuc Pattyn21-Mar-16 19:35 
GeneralRe: Updating the UI from a Rx background thread Pin
Kenneth Haugland21-Mar-16 20:24
mvaKenneth Haugland21-Mar-16 20:24 
AnswerRe: Updating the UI from a Rx background thread Pin
Kenneth Haugland21-Mar-16 23:07
mvaKenneth Haugland21-Mar-16 23:07 
AnswerRe: Updating the UI from a Rx background thread Pin
Kenneth Haugland22-Mar-16 23:56
mvaKenneth Haugland22-Mar-16 23:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.