Click here to Skip to main content
15,905,781 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to view board component and capacitor Pin
Patrice T22-Mar-16 20:07
mvePatrice T22-Mar-16 20:07 
AnswerRe: How to view board component and capacitor Pin
Sascha Lefèvre22-Mar-16 23:02
professionalSascha Lefèvre22-Mar-16 23:02 
QuestionRe: How to view board component and capacitor Pin
regerteast23-Mar-16 3:01
regerteast23-Mar-16 3:01 
AnswerRe: How to view board component and capacitor Pin
Pete O'Hanlon23-Mar-16 3:08
mvePete O'Hanlon23-Mar-16 3:08 
AnswerRe: How to view board component and capacitor Pin
Matt T Heffron23-Mar-16 13:16
professionalMatt T Heffron23-Mar-16 13:16 
GeneralRe: How to view board component and capacitor Pin
regerteast24-Mar-16 20:54
regerteast24-Mar-16 20:54 
GeneralRe: How to view board component and capacitor Pin
Eddy Vluggen25-Mar-16 0:50
professionalEddy Vluggen25-Mar-16 0:50 
GeneralRe: How to view board component and capacitor Pin
regerteast25-Mar-16 4:04
regerteast25-Mar-16 4:04 
GeneralRe: How to view board component and capacitor Pin
OriginalGriff25-Mar-16 4:24
mveOriginalGriff25-Mar-16 4:24 
GeneralRe: How to view board component and capacitor Pin
regerteast25-Mar-16 5:40
regerteast25-Mar-16 5:40 
GeneralRe: How to view board component and capacitor Pin
OriginalGriff25-Mar-16 6:05
mveOriginalGriff25-Mar-16 6:05 
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 

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.