error list on ledger report viewer form

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • lachu1
    New Member
    • Dec 2012
    • 1
    #1

    error list on ledger report viewer form

    i'm using this code in crystal report viewer(ledger report)



    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.CrystalReports.Engine;

namespace MK_AUTOCARE
{
    public partial class crystalReportViewer2 : Form
    {
        public crystalReportViewer2()
        {
            InitializeComponent();
        }
        private TextBox txthcode;
        private DateTime dateTime;
        private DateTime dateTime_2;

        public rptledger(DateTime dateTime,DateTime dateTime_2,TextBox txthcode)
        {
        InitializeComponent();
        // TODO: Complete member initialization
        this.dateTime = dateTime;
        this.dateTime_2 = dateTime_2;
        this.txthcode=txthcode;
        }
        dboperation db = new dboperation();

           db.DateCall(dtpto.Value);
            string s = "select * from  grouphead";
            db.exenonquery(s);
            DataTable dt1 = db.exedatatable(s);
           string s = "select * from daybook where trdate between '" + db.SDAT.ToShortDateString() + "' and '" + db.EDAT.ToShortDateString() + "'";
            DataTable dt2 = db.exedatatable(s);
            s = "select * from HEAD";
            DataTable dt3 = db.exedatatable(s);
            s = "delete from OPBALHEAD";
            db.ExecuteSQL(s);
            if (dt2.Rows.Count > 0)
            {
                for (int i = 0; i < dt2.Rows.Count; i++)
                {

                    double opbal = 0;
                    s = "select sum(credit)-sum(debit) as bal from daybook where trdate <'" + db.SDAT.ToShortDateString() + "' and HCODE='" + dt2.Rows[i]["HCODE"].ToString() + "'";
                    DataTable dt5 = db.exedatatable(s);

                    if (dt5.Rows[0][0].ToString() != "")
                    {
                        opbal = Convert.ToDouble(dt5.Rows[0][0].ToString());
                    }


                    s = "select bal from OPENING where ACYEAR='" + db.SDAT.Year + "' and HCODE='" + dt2.Rows[i]["HCODE"].ToString() + "'";
                    DataTable dt6 = db.exedatatable(s);
                    if (dt6.Rows.Count > 0)
                    {
                        opbal = opbal + Convert.ToDouble(dt6.Rows[0][0].ToString());
                    }
                    s = "insert into OPBALHEAD values('" + dt2.Rows[i]["HCODE"].ToString() + "'," + opbal + ")";
                    db.ExecuteSQL(s);
                }
            }
            s = "select * from OPBALHEAD";
            DataTable dt4 = db.exedatatable(s);
            DataSet2 ds = new DataSet2();
           // ds.GROUPHEAD.Clear();
          //  ds.GROUPHEAD.Merge(dt1);
            ds.DAYBOOK.Clear();
            ds.DAYBOOK.Merge(dt2);
            ds.HEAD.Clear();
            ds.HEAD.Merge(dt3);
            ds.OPBAL.Clear();
            ds.OPBAL.Merge(dt4);
            daybook rpt = new daybook();
            rpt.SetDataSource(ds);
            TextObject MyText;
            MyText = (TextObject)rpt.ReportDefinition.ReportObjects["Text11"];
            MyText.Text = "Day Book";

            string ss = "select * from defaults";
            string comp = "", addr = "", place = "", dist = "", state = "";
            DataTable dtss = db.exedatatable(ss);
            if (dtss.Rows.Count > 0)
            {
                comp = dtss.Rows[0]["cname"].ToString();
                addr = dtss.Rows[0]["cadd"].ToString();
                place = dtss.Rows[0]["cplace"].ToString();
                dist = dtss.Rows[0]["dist"].ToString();
                state = dtss.Rows[0]["state"].ToString();

            }

            TextObject MyText1;
            MyText1 = (TextObject)rpt.ReportDefinition.ReportObjects["Text12"];
            MyText1.Text = comp;

            TextObject MyText3;
            MyText3 = (TextObject)rpt.ReportDefinition.ReportObjects["Text14"];
            MyText3.Text = addr + " " + place + " " + dist + " " + state;

            TextObject MyText2;
            MyText2 = (TextObject)rpt.ReportDefinition.ReportObjects["Text13"];
            MyText2.Text = "" + db.SDAT.ToShortDateString() + "' to '" + db.EDAT.ToShortDateString() + "' ";


            TextObject MyText4;
            MyText4 = (TextObject)rpt.ReportDefinition.ReportObjects["Text15"];
            MyText4.Text = "" + db.SDAT.Year.ToString() + "-" + db.EDAT.Year.ToString() + "";

            crystalReportViewer1.ReportSource = rpt;
        private void crystalReportViewer1_Load(object sender, EventArgs e)
        {

        }
    }
}
    the following errors are occured

    Error 2 Method must have a return type I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 23 16 MK AUTOCARE

    Error 3 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 33 23 MK AUTOCARE

    Error 4 Invalid token ')' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 33 35 MK AUTOCARE

    Error 5 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 35 27 MK AUTOCARE

    Error 6 Invalid token ')' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 35 29 MK AUTOCARE

    Error 7 Invalid token '=' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 39 15 MK AUTOCARE

    Error 8 Invalid token '=' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 41 15 MK AUTOCARE

    Error 9 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 42 26 MK AUTOCARE

    Error 10 Invalid token ')' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 42 28 MK AUTOCARE

    Error 11 Invalid token '>' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 43 32 MK AUTOCARE

    Error 12 Invalid token ';' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 45 51 MK AUTOCARE

    Error 13 Syntax error, '>' expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 45 51 MK AUTOCARE

    Error 14 Invalid token '++' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 45 54 MK AUTOCARE

    Error 15 Invalid token '=' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 49 23 MK AUTOCARE

    Error 16 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 49 120 MK AUTOCARE
    Error 17 Invalid token '[' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 49 151 MK AUTOCARE

    Error 18 Invalid token '"HCODE"' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 49 155 MK AUTOCARE

    Error 19 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 49 155 MK AUTOCARE

    Error 20 Method must have a return type I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 49 164 MK AUTOCARE

    Error 21 ; expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 49 175 MK AUTOCARE

    Error 22 Invalid token 'if' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 52 21 MK AUTOCARE

    Error 23 Array size cannot be specified in a variable declaration (try initializing with a 'new' expression) I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 52 34 MK AUTOCARE

    Error 24 Array size cannot be specified in a variable declaration (try initializing with a 'new' expression) I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 52 37 MK AUTOCARE

    Error 25 Invalid token '.' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 52 39 MK AUTOCARE

    Error 26 Method must have a return type I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 52 40 MK AUTOCARE

    Error 27 ; expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 52 51 MK AUTOCARE

    Error 28 Invalid token '=' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 54 31 MK AUTOCARE

    Error 29 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 54 49 MK AUTOCARE

    Error 30 Array size cannot be specified in a variable declaration (try initializing with a 'new' expression) I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 54 59 MK AUTOCARE

    Error 31 Array size cannot be specified in a variable declaration (try initializing with a 'new' expression) I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 54 62 MK AUTOCARE

    Error 32 Invalid token '.' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 54 64 MK AUTOCARE

    Error 33 Method must have a return type I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 54 65 MK AUTOCARE

    Error 34 ; expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 54 75 MK AUTOCARE

    Error 35 A namespace cannot directly contain members such as fields or methods I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 58 21 MK AUTOCARE

    Error 36 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 58 113 MK AUTOCARE

    Error 37 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 62 67 MK AUTOCARE

    Error 38 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 62 70 MK AUTOCARE

    Error 39 A namespace cannot directly contain members such as fields or methods I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 64 21 MK AUTOCARE

    Error 40 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 64 72 MK AUTOCARE

    Error 41 Type or namespace definition, or end-of-file expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptled ger.cs 66 17 MK AUTOCARE
    Last edited by PsychoCoder; Dec 22 '12, 05:37 PM. Reason: Added code tags and formatted error messages
    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      1) Your method needs a return type.

      2) You prematurely end your function on line 30.

        Comment

        Previous template Next
        Working...