public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            cryRepAccSheetCostCenter rpt = new cryRepAccSheetCostCenter();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void AccSheetWithCostCenter()
        {
            if (lstAccNo.SelectedIndex == -1)
            {
                glb_function.MsgBox("الرجاء اختيار الحساب");
                return;
            }
            cryRepAccSheetCostCenter report = new cryRepAccSheetCostCenter();
            frmReportContainer       frm    = new frmReportContainer();
            DataTable         dtReport      = new DataTable();
            ConnectionToMySQL cnn           = new ConnectionToMySQL();

            TextObject txtArTitel = (TextObject)report.ReportDefinition.ReportObjects["txtArTitel"];

            txtArTitel.Text = glb_function.strArabicTitel;
            TextObject txtEnTitel = (TextObject)report.ReportDefinition.ReportObjects["txtEnTitel"];

            txtEnTitel.Text = glb_function.strEnglishTitel;

            double dBalance = 0;
            string strDate  = "";
            string strStat  = "";

            if (ckbPosting.Checked == true)
            {
                strStat = " and h.stat in ('فعال', 'مرحل')";
            }
            else
            {
                strStat = " and h.stat in ( 'مرحل')";
            }

            strStat = strStat + " and ifnull(d.profitCenter,'') like '%" + lstCostCent.Text.Trim() + "%'";


            if (ckbSelectDate.Checked == true)
            {
                strDate = " and jour_date between str_to_date('" + dtpFrom.Value.ToString("dd/MM/yyyy") + "', '%d/%m/%Y') and str_to_date('" + dtpTo.Value.ToString("dd/MM/yyyy") + "', '%d/%m/%Y')";

                dtReport = cnn.GetDataTable("select ifnull(sum(main_value) ,0) balance " +
                                            " from journal_header h " +
                                            " join journal_details d on (h.pkid = d.header_id) " +
                                            " where d.acc_id=" + lstAccNo.SelectedValue.ToString() + " and h.created_date < str_to_date('" + dtpFrom.Value.ToString("dd/MM/yyyy") + "','%d/%m/%Y') " + strStat);

                dBalance = Convert.ToDouble(dtReport.Rows[0][0].ToString());
            }
            else
            {
                dBalance = 0;
            }

            dtReport.Clear();

            dtReport = cnn.GetDataTable("select h.pkid,h.jour_no,h.trans_no,h.trans_name,date_format(h.jour_date,'%d/%m/%Y') jour_date,h.jour_note, " +
                                        " if (d.main_value > 0,d.main_value,0) Dept,if (d.main_value < 0,d.main_value * -1,0) Credit,d.jour_details,0 Balance, 'مدين' BalStat,if(d.profitCenter='','غير محدد',ifnull(d.profitCenter,'غير محدد') ) profitCenter" +
                                        "  from journal_header h " +
                                        "  join journal_details d on(h.pkid= d.header_id)" +
                                        //    " where d.acc_id=" + lstAccNo.SelectedValue.ToString() + strStat + strDate + " order by h.jour_date,d.pkid,if(d.profitCenter='','غير محدد',ifnull(d.profitCenter,'غير محدد') )");
                                        " where d.acc_id=" + lstAccNo.SelectedValue.ToString() + strStat + strDate + " order by profitCenter,h.jour_date,d.pkid");


            for (int i = 0; i < dtReport.Rows.Count; i++)
            {
                dBalance = dBalance + Convert.ToDouble(dtReport.Rows[i]["Dept"].ToString()) - Convert.ToDouble(dtReport.Rows[i]["Credit"].ToString());

                if (dBalance < 0)
                {
                    dtReport.Rows[i]["Balance"] = dBalance * -1;
                    dtReport.Rows[i]["BalStat"] = "دائن";
                }
                else
                {
                    dtReport.Rows[i]["Balance"] = dBalance;
                    dtReport.Rows[i]["BalStat"] = "مدين";
                }

                //   dtReport.Rows[i]["Balance"]
            }



            report.SetDataSource(dtReport);
            report.SetParameterValue("From", (ckbSelectDate.Checked == false ? "" : dtpFrom.Value.ToString("dd/MM/yyyy")));
            report.SetParameterValue("To", (ckbSelectDate.Checked == false ? DateTime.Now.ToString("dd/MM/yyyy") : dtpTo.Value.ToString("dd/MM/yyyy")));
            report.SetParameterValue("AccNo", lstAccNo.Text);
            report.SetParameterValue("AccName", lstAccName.Text);

            // report.SetParameterValue("strValueAlpha", new ConvertNumbersToArabicAlphabet(txtCreditTotal.Text).GetNumberAr());
            frm.CrystalReportsViewer1.ReportSource = report;
            frm.ShowDialog();
        }