private void btnSearch_Click_1(object sender, EventArgs e)
        {
            try
            {
                string DoctorName;
                int MedicalShopID;
                int ProductID;
                string StartDate;
                string EndDate;

                DoctorName = Convert.ToString(cbDoctor.Text);
                MedicalShopID = Convert.ToInt32(cbMedicalShop.SelectedValue.ToString());
                ProductID = Convert.ToInt32(cbProduct.SelectedValue.ToString());
                StartDate = Convert.ToString(dtpStartDate.Text);
                EndDate = Convert.ToString(dtpEndDate.Text);

                ReportDocument reportDocument = new ReportDocument();
                ParameterField paramField = new ParameterField();
                ParameterFields paramFields = new ParameterFields();
                ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
                string ReportPath = ConfigurationManager.AppSettings["ReportPath"];

                paramField.Name = "@DoctorName";
                paramField.Name = "@MedicalShopID";
                paramField.Name = "@ProductID";
                paramField.Name = "@StartDate";
                paramField.Name = "@EndDate";
                paramDiscreteValue.Value = 1;
                reportDocument.Load(ReportPath+"Report\\Commission_CrystalReport.rpt");

                ConnectionInfo connectionInfo = new ConnectionInfo();
                connectionInfo.DatabaseName = "DB_MedicalShop_02Sept20159PM";
                //connectionInfo.UserID = "wms";
                //connectionInfo.Password = "wms";
                connectionInfo.IntegratedSecurity = true;
                SetDBLogonForReport(connectionInfo, reportDocument);

                reportDocument.SetParameterValue("@DoctorName", DoctorName);
                reportDocument.SetParameterValue("@MedicalShopID", MedicalShopID);
                reportDocument.SetParameterValue("@ProductID", ProductID);
                reportDocument.SetParameterValue("@StartDate", StartDate);
                reportDocument.SetParameterValue("@EndDate", EndDate);
                CommissionCrystalRpt.ReportSource = reportDocument;

                CommissionCrystalRpt.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }

    /// <summary>
    /// 產生報表
    /// </summary>
    private void ConfigureCrystalReports()
    {
        try
        {
            string strDate = Session[string.Format("{0}QueryDateRange", Request["TimeStamp"].ToString())].ToString();
            if (strDate == "~") strDate = "";
            string strTime = Session[string.Format("{0}QueryTimeRange", Request["TimeStamp"].ToString())].ToString();
            if (strTime == "~") strTime = "";
            customerReport = new ReportDocument();

            //取得報表格式檔RPT
            customerReport.Load(Server.MapPath("ITM061R.rpt"));
            customerReport.SetDataSource((DataTable)Session[string.Format("{0}ITM061", Request["TimeStamp"].ToString())]);
            ParameterFields par1 = new ParameterFields();
            AddParameter("ProgramName", PageProgramName, par1);
            ParameterFields par2 = new ParameterFields();
            AddParameter("UserName", Session["UID"].ToString(), par2);
            ParameterFields par3 = new ParameterFields();
            AddParameter("QueryDateRange", strDate, par3);
            ParameterFields par4 = new ParameterFields();
            AddParameter("QueryTime", strTime, par4);
            CRV1.ParameterFieldInfo.Add(par1[0]);
            CRV1.ParameterFieldInfo.Add(par2[0]);
            CRV1.ParameterFieldInfo.Add(par3[0]);
            CRV1.ParameterFieldInfo.Add(par4[0]);
            CRV1.ReportSource = customerReport;
        }
        catch (Exception ex)
        {
            lblErrorMessage.Text = ex.Message;
        }
    }//ConfigureCrystalReports

 private void Reporte_de_Gastos_de_Inversión_Load(object sender, EventArgs e)
 {
     //Diseño de la ventana
     this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(237)))), ((int)(((byte)(228)))), ((int)(((byte)(196)))));
     this.Icon = global::Sistema_Shajobe.Properties.Resources.Caja_ICO;
     //REPORTE CRISTAL REPORT
     //PRIMER PARAMETRO
     ReportDocument reporte = new ReportDocument();
     ParameterField parametro = new ParameterField();
     ParameterFields parametros = new ParameterFields();
     ParameterDiscreteValue discretos = new ParameterDiscreteValue();
     parametro.Name = "@Apartir";
     discretos.Value = Convert.ToDateTime(_Apartir);
     parametro.CurrentValues.Add(discretos);
     parametros.Add(parametro);
     //SEGUNDO PARAMETRO
     ParameterField parametro1 = new ParameterField();
     ParameterDiscreteValue discretos1 = new ParameterDiscreteValue();
     parametro1.Name = "@Hasta";
     discretos1.Value = Convert.ToDateTime(_Hasta);
     parametro1.CurrentValues.Add(discretos1);
     parametros.Add(parametro1);
     crystalReportViewer1.ParameterFieldInfo = parametros;
     crystalReportViewer1.ReportSource = RGastosInventario1;
 }

        private void FormSupplierPayment_Print_Load(object sender, EventArgs e)
        {
            try
            {
                // int TransactionID;
                //SaleTransactionID = Convert.ToInt32(cbSupplier.SelectedValue.ToString());
                ReportDocument reportDocument = new ReportDocument();
                ParameterField paramField = new ParameterField();
                ParameterFields paramFields = new ParameterFields();
                ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
                string ReportPath = ConfigurationManager.AppSettings["ReportPath"];

                paramField.Name = "@SupplierPaymentID";

                paramDiscreteValue.Value = @SupplierPaymentID;
                reportDocument.Load(ReportPath+"SupplierPay_Print_CrystalReport.rpt");

                ConnectionInfo connectionInfo = new ConnectionInfo();
                connectionInfo.DatabaseName = "DB_MedicalShop_02Sept20159PM";
                //connectionInfo.UserID = "wms";
                //connectionInfo.Password = "wms";
                connectionInfo.IntegratedSecurity = true;
                SetDBLogonForReport(connectionInfo, reportDocument);

                reportDocument.SetParameterValue("@SupplierPaymentID", SupplierPaymentID);
                SupplierPyCrystalPrint.ReportSource = reportDocument;

                SupplierPyCrystalPrint.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            int GroupId;
            GroupId = Convert.ToInt32(cbgroupNames.SelectedValue.ToString());

            ReportDocument reportDocument = new ReportDocument();
            ParameterField paramField = new ParameterField();
            ParameterFields paramFields = new ParameterFields();
            ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
            string ReportPath = ConfigurationManager.AppSettings["ReportPath"];

            paramField.Name = "@GroupId";
            paramDiscreteValue.Value = 1;
            reportDocument.Load(ReportPath + "Reports\\GroupWise_CrystalReport.rpt");

            ConnectionInfo connectionInfo = new ConnectionInfo();
            connectionInfo.DatabaseName = "DB_LoanApplication";
            //connectionInfo.UserID = "wms";
            //connectionInfo.Password = "wms";
            connectionInfo.IntegratedSecurity = true;
            SetDBLogonForReport(connectionInfo, reportDocument);

            reportDocument.SetParameterValue("@GroupId", GroupId);
            GroupWisecrystalReport.ReportSource = reportDocument;
            GroupWisecrystalReport.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
        }

        public void InitializeReport()
        {
            ReportDocument PullOutSummaryPerCustomer;

            PullOutSummaryPerCustomer = new PullOutSummaryPerOutletRpt();

            DataBaseLogIn(PullOutSummaryPerCustomer);

            ParameterField prmCustomerNumber = new ParameterField();
            ParameterField prmDateFrom = new ParameterField();
            ParameterField prmDateTo = new ParameterField();
            ParameterFields prmList = new ParameterFields();

            prmCustomerNumber.ParameterFieldName = "customer_number";
            prmDateFrom.ParameterFieldName = "date_from";
            prmDateTo.ParameterFieldName = "date_to";

            ParameterDiscreteValue prmCustomerNumberValue = new ParameterDiscreteValue();
            ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
            ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();

            prmCustomerNumberValue.Value = Request.QueryString["CustomerNumber"];
            prmDateFromValue.Value = Request.QueryString["DateFrom"];
            prmDateToValue.Value = Request.QueryString["DateTo"];

            prmCustomerNumber.CurrentValues.Add(prmCustomerNumberValue);
            prmDateFrom.CurrentValues.Add(prmDateFromValue);
            prmDateTo.CurrentValues.Add(prmDateToValue);

            prmList.Add(prmCustomerNumber);
            prmList.Add(prmDateFrom);
            prmList.Add(prmDateTo);
            this.crViewerMonthlyPullOutSummaryPerCustomer.ParameterFieldInfo = prmList;
            crViewerMonthlyPullOutSummaryPerCustomer.ReportSource = PullOutSummaryPerCustomer;
        }

        public void InitializeReport()
        {
            ReportDocument PullOutConsolidated;

            PullOutConsolidated = new PullOutConsolidatedMonthly();
            DataBaseLogIn(PullOutConsolidated);

            ParameterField prmDateFrom = new ParameterField();
            ParameterField prmDateTo = new ParameterField();
            ParameterFields prmList = new ParameterFields();
            prmDateFrom.ParameterFieldName = "date_from";
            prmDateTo.ParameterFieldName = "date_to";

            ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
            ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();

            prmDateFromValue.Value = Request.QueryString["DateFrom"];
            prmDateToValue.Value = Request.QueryString["DateTo"];

            prmDateFrom.CurrentValues.Add(prmDateFromValue);
            prmDateTo.CurrentValues.Add(prmDateToValue);

            prmList.Add(prmDateFrom);
            prmList.Add(prmDateTo);
            this.crViewerMonthlyConsolidatedReport.ParameterFieldInfo = prmList;
            crViewerMonthlyConsolidatedReport.ReportSource = PullOutConsolidated;
        }

        private void InitializeReport()
        {
            ReportDocument REPORT_DOC = new ReportDocument();
            REPORT_DOC = new RptSummaryMonthlySOIPilferageByLocation();
            DataBaseLogIn(REPORT_DOC);

            ParameterField prmDateFrom = new ParameterField();
            ParameterField prmDateTo = new ParameterField();
            ParameterFields prmList = new ParameterFields();

            prmDateFrom.ParameterFieldName = "@DateFrom";
            prmDateTo.ParameterFieldName = "@DateTo";

            ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
            ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();

            prmDateFromValue.Value = Request.QueryString["DateFrom"];
            prmDateToValue.Value = Request.QueryString["DateTo"];

            prmDateFrom.CurrentValues.Add(prmDateFromValue);
            prmDateTo.CurrentValues.Add(prmDateToValue);

            prmList.Add(prmDateFrom);
            prmList.Add(prmDateTo);
            this.SummaryOfMonthlyPilferageByLocation.ParameterFieldInfo = prmList;
            SummaryOfMonthlyPilferageByLocation.ReportSource = REPORT_DOC;
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            int DoctorID;
            DoctorID = Convert.ToInt32(cbDoctor.SelectedValue.ToString());
            ReportDocument reportDocument = new ReportDocument();
            ParameterField paramField = new ParameterField();
            ParameterFields paramFields = new ParameterFields();
            ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
            string ReportPath = ConfigurationManager.AppSettings["ReportPath"];

            paramField.Name = "@DoctorID";

            paramDiscreteValue.Value = DoctorID;
            reportDocument.Load(ReportPath + "Report\\DoctorCrystalReport.rpt");

            ConnectionInfo connectionInfo = new ConnectionInfo();
            connectionInfo.DatabaseName = "DB_MedicalShop_02Sept20159PM";
            //connectionInfo.UserID = "wms";
            //connectionInfo.Password = "wms";
            connectionInfo.IntegratedSecurity = true;
            SetDBLogonForReport(connectionInfo, reportDocument);

            reportDocument.SetParameterValue("@DoctorID", DoctorID);
            DoctorCrystalRpt.ReportSource = reportDocument;

            DoctorCrystalRpt.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
        }

        private void InitializeReport()
        {
            ReportDocument REPORT_DOC = new ReportDocument();
            REPORT_DOC = new RptSummaryMonthlyPilferageDeptStores();
            DataBaseLogIn(REPORT_DOC);

            ParameterField prmBrand = new ParameterField();
            ParameterField prmDateFrom = new ParameterField();
            ParameterField prmDateTo = new ParameterField();
            ParameterFields prmList = new ParameterFields();

            prmBrand.ParameterFieldName = "@BRAND_NAME";
            prmDateFrom.ParameterFieldName = "@DATE_FROM";
            prmDateTo.ParameterFieldName = "@DATE_TO";

            ParameterDiscreteValue prmBrandValue = new ParameterDiscreteValue();
            ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
            ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();

            prmBrandValue.Value = Request.QueryString["Brand"];
            prmDateFromValue.Value = Request.QueryString["DateFrom"];
            prmDateToValue.Value = Request.QueryString["DateTo"];

            prmBrand.CurrentValues.Add(prmBrandValue);
            prmDateFrom.CurrentValues.Add(prmDateFromValue);
            prmDateTo.CurrentValues.Add(prmDateToValue);

            prmList.Add(prmBrand);
            prmList.Add(prmDateFrom);
            prmList.Add(prmDateTo);
            this.SummaryOfMonthlyPilferagePerDepartmentStores.ParameterFieldInfo = prmList;
            SummaryOfMonthlyPilferagePerDepartmentStores.ReportSource = REPORT_DOC;
        }

        private void RptCetakKwitansi_Load(object sender, EventArgs e)
        {
            string strPath = Application.StartupPath + @"\Form\Report\Kwitansi\RptKwitansi.rpt";

            // Object for load report.
            ReportDocument rpt = new ReportDocument();
            rpt.Load(strPath);

            //Set Parameter
            ParameterFields pfields = new ParameterFields();
            ParameterField pfield = new ParameterField();
            ParameterDiscreteValue disValue = new ParameterDiscreteValue();
            pfield.Name = "spell";
            disValue.Value = spell;
            pfield.CurrentValues.Add(disValue);
            pfields.Add(pfield);

            pfield = new ParameterField();
            pfield.Name = "price";
            disValue = new ParameterDiscreteValue();
            disValue.Value = harga;
            pfield.CurrentValues.Add(disValue);
            pfields.Add(pfield);

            pfield = new ParameterField();
            pfield.Name = "keterangan";
            disValue = new ParameterDiscreteValue();
            disValue.Value = ket;
            pfield.CurrentValues.Add(disValue);
            pfields.Add(pfield);
            crystalReportViewer1.ParameterFieldInfo = pfields;

            crystalReportViewer1.ReportSource = rpt;
            crystalReportViewer1.Refresh();
        }

 public void setParameters(ReportDocument Rpt)
 {
     ParameterFields paramFields = new ParameterFields();
     if (HttpContext.Current.Request.QueryString["MailingId"] != null && HttpContext.Current.Request.QueryString["MailingId"] != string.Empty)
     {
         ParameterField MailingId = new ParameterField();
         MailingId.ParameterFieldName = "@CampaignId";
         ParameterDiscreteValue dcMailingId = new ParameterDiscreteValue();
         dcMailingId.Value = Convert.ToInt32(Request.QueryString["MailingId"].ToString());
         MailingId.CurrentValues.Add(dcMailingId);
         paramFields.Add(MailingId);
     }
     else
     {
         ParameterField CampId = new ParameterField();
         CampId.ParameterFieldName = "@AssignedCampaignID";
         ParameterDiscreteValue dcCampId = new ParameterDiscreteValue();
         dcCampId.Value = Convert.ToInt32(Request.QueryString["CampId"].ToString());
         CampId.CurrentValues.Add(dcCampId);
         paramFields.Add(CampId);
     }
     CrystalReportViewer1.ParameterFieldInfo = paramFields;
     CrystalReportViewer1.ReportSource = Rpt;
     CrystalReportViewer1.DataBind();
 }

        private void LoadReport()
        {
            try
            {

                string strSql = "select work_id,shipsup,cargosup,to_char(appdate,'yyyy-mm-dd') appdate, cargo_name,cargo_num from zjgdou_declare where to_char(appdate,'yyyy-mm-dd')>='2009-05-08'";

            //            DataTable tab = rpDocDB.GetDataTable(strSql);
                string strPath = Server.MapPath("../../rpt/declare.rpt");
                this.rpDoc.Load(strPath);
            //            rpDoc.SetDataSource(tab);
                this.Login(rpDoc);
                ParameterFields pfs = new ParameterFields();
                ParameterField pf = new ParameterField();
                ParameterDiscreteValue pfv = new ParameterDiscreteValue();
                string strCode = "信息中心";

                pfv.Value = strCode;
                pf.Name = "corp";
                pf.CurrentValues.Add(pfv);
                pfs.Add(pf);
                this.CrystalReportViewer1.ParameterFieldInfo = pfs;

                this.CrystalReportViewer1.ReportSource = rpDoc;
                this.CrystalReportViewer1.DataBind();

                //this.CrystalReportViewer1.RefreshReport();
                //this.Session["REPORT"] = rpDoc;

            }
            catch (Exception err)
            {

            }
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            string BcDate;
            string DueDate;

            BcDate = Convert.ToString(dtpfromdate.Text);
            DueDate = Convert.ToString(dtpTodate.Text);

            ReportDocument reportDocument = new ReportDocument();
            ParameterField paramField = new ParameterField();
            ParameterFields paramFields = new ParameterFields();
            ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
            string ReportPath = ConfigurationManager.AppSettings["ReportPath"];

            paramField.Name = "@BcDate";
            paramField.Name = "@DueDate";
            paramDiscreteValue.Value = 1;
            reportDocument.Load(ReportPath + "Reports\\DateWiseTransactionReport.rpt");

            ConnectionInfo connectionInfo = new ConnectionInfo();
            connectionInfo.DatabaseName = "DB_LoanApplication";
            //connectionInfo.UserID = "wms";
            //connectionInfo.Password = "wms";
            connectionInfo.IntegratedSecurity = true;
            SetDBLogonForReport(connectionInfo, reportDocument);

            reportDocument.SetParameterValue("@BcDate", BcDate);
            reportDocument.SetParameterValue("@DueDate", DueDate);
            DatewisecrystalReport.ReportSource = reportDocument;
            DatewisecrystalReport.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
        }

        public void setParameters(ReportDocument Rpt)
        {
            if (HttpContext.Current.Request.QueryString["StartDate"] != null && HttpContext.Current.Request.QueryString["EndDate"] != null)
            {
                ParameterFields paramFields = new ParameterFields();
                ParameterField StartDay, EndDay;
                ParameterDiscreteValue dcStartDay, dcEndDay;
                StartDay = new ParameterField();
                StartDay.ParameterFieldName = "@FromDate";
                dcStartDay = new ParameterDiscreteValue();
                dcStartDay.Value = Request.QueryString["StartDate"].ToString();

                EndDay = new ParameterField();
                EndDay.ParameterFieldName = "@ToDate";
                dcEndDay = new ParameterDiscreteValue();
                dcEndDay.Value = Request.QueryString["EndDate"].ToString();

                StartDay.CurrentValues.Add(dcStartDay);
                EndDay.CurrentValues.Add(dcEndDay);
                paramFields.Add(StartDay);
                paramFields.Add(EndDay);

                AdminActivityCRViewer.ParameterFieldInfo = paramFields;
                AdminActivityCRViewer.ReportSource = Rpt;
                AdminActivityCRViewer.DataBind();
            }
        }

        public PrintSI(string Supplier, string city, string kapal, string date)
        {
            InitializeComponent();
            reportDocument = new ReportDocument();
            paramFields = new ParameterFields();

            paramField = new ParameterField();
            paramField.Name = "supplier";
            paramDiscreteValue = new ParameterDiscreteValue();
            paramDiscreteValue.Value = Supplier;
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);

            paramField = new ParameterField();
            paramField.Name = "kapal";
            paramDiscreteValue = new ParameterDiscreteValue();
            paramDiscreteValue.Value = kapal;
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);

            paramField = new ParameterField();
            paramField.Name = "tujuan";
            paramDiscreteValue = new ParameterDiscreteValue();
            paramDiscreteValue.Value = city;
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);

            paramField = new ParameterField();
            paramField.Name = "ATD";
            paramDiscreteValue = new ParameterDiscreteValue();
            paramDiscreteValue.Value = date;
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);
            crystalReportViewer1.ParameterFieldInfo = paramFields;
        }

        private void crystalReportViewer1_Load(object sender, EventArgs e)
        {
            reportDataBind();
            ParameterFields paramFields = new ParameterFields();
            ParameterField paramField1 = new ParameterField();
            ParameterDiscreteValue discreteVal1 = new ParameterDiscreteValue();
            paramField1.ParameterFieldName = "drawingno";
            discreteVal1.Value = drawingno;
            paramField1.CurrentValues.Add(discreteVal1);
            paramFields.Add(paramField1);

            ParameterField paramField2 = new ParameterField();
            ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
            paramField2.ParameterFieldName = "blockno";
            discreteVal2.Value = blockno;
            paramField2.CurrentValues.Add(discreteVal2);
            paramFields.Add(paramField2);

            ParameterField paramField3 = new ParameterField();
            ParameterDiscreteValue discreteVal3 = new ParameterDiscreteValue();
            paramField3.ParameterFieldName = "project";
            discreteVal3.Value = project;
            paramField3.CurrentValues.Add(discreteVal3);
            paramFields.Add(paramField3);
            crystalReportViewer1.ParameterFieldInfo = paramFields;
        }

        private void crystalReportViewer1_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            ds = GetDs();
            if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS"))
            {
                NestProjectMaterialRpt pmrpt = new NestProjectMaterialRpt();
                pmrpt.SetDataSource(ds);
                crystalReportViewer1.ReportSource = pmrpt;
            }
            else
            {
                ProjectMaterialRpt pmrpt = new ProjectMaterialRpt();
                pmrpt.SetDataSource(ds);
                crystalReportViewer1.ReportSource = pmrpt;
            }

            //crystalReportViewer1.DisplayGroupTree = false;
            ParameterFields paramFields = new ParameterFields();
            ParameterField paramField1 = new ParameterField();
            ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
            //   第一个参数是具有多个值的离散参数。设置参数字段的名称，它必须和报表中的参数相符。
            paramField1.ParameterFieldName = "kickoffdate";
            //   设置离散值并将其传递给该参数。
            discreteVal.Value = User .KickOffDate ;
            paramField1.CurrentValues.Add(discreteVal);
            //   将该参数添加到参数字段集合。
            paramFields.Add(paramField1);

            ParameterField paramField2 = new ParameterField();
            ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
            paramField2.ParameterFieldName = "TotalBaseLength";
            discreteVal2.Value = User.TotalBaseLength;
            paramField2.CurrentValues.Add(discreteVal2);
            paramFields.Add(paramField2);

            ParameterField paramField5 = new ParameterField();
            ParameterDiscreteValue discreteVal5 = new ParameterDiscreteValue();
            paramField5.ParameterFieldName = "kickoffdateStart";
            discreteVal5.Value = User.KickOffDate_start;
            paramField5.CurrentValues.Add(discreteVal5);
            paramFields.Add(paramField5);

            ParameterField paramField6 = new ParameterField();
            ParameterDiscreteValue discreteVal6 = new ParameterDiscreteValue();
            paramField6.ParameterFieldName = "kickoffdateEnd";
            discreteVal6.Value = User.KickOffDate_end;
            paramField6.CurrentValues.Add(discreteVal6);
            paramFields.Add(paramField6);

            ParameterField paramField7 = new ParameterField();
            ParameterDiscreteValue discreteVal7 = new ParameterDiscreteValue();
            paramField7.ParameterFieldName = "TotalWeight";
            discreteVal7.Value = User.PipeBaseTotalWeight;
            paramField7.CurrentValues.Add(discreteVal7);
            paramFields.Add(paramField7);

            crystalReportViewer1.ParameterFieldInfo = paramFields;
        }

        private void NestingDetailViewer_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            ds = GetDs();
            if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS"))
            {
                NestingPipeRpt pmrpt = new NestingPipeRpt();
                pmrpt.SetDataSource(ds);
                NestingDetailViewer.ReportSource = pmrpt;
            }

            ParameterFields paramFields = new ParameterFields();

            ParameterField paramField1 = new ParameterField();
            ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
            paramField1.ParameterFieldName = "kickoffdate";
            discreteVal.Value = User.KickOffDate;
            paramField1.CurrentValues.Add(discreteVal);
            paramFields.Add(paramField1);

            ParameterField paramField2 = new ParameterField();
            ParameterDiscreteValue discreteVa2 = new ParameterDiscreteValue();
            paramField2.ParameterFieldName = "Margin";
            discreteVa2.Value = User.Margin;
            paramField2.CurrentValues.Add(discreteVa2);
            paramFields.Add(paramField2);

            ParameterField paramField3 = new ParameterField();
            ParameterDiscreteValue discreteVal3 = new ParameterDiscreteValue();
            paramField3.ParameterFieldName = "TotalBaseLength";
            discreteVal3.Value = User.TotalBaseLength;
            paramField3.CurrentValues.Add(discreteVal3);
            paramFields.Add(paramField3);

            ParameterField paramField4 = new ParameterField();
            ParameterDiscreteValue discreteVal4 = new ParameterDiscreteValue();
            paramField4.ParameterFieldName = "PipeRatio";
            discreteVal4.Value = User.PipeRatio;
            paramField4.CurrentValues.Add(discreteVal4);
            paramFields.Add(paramField4);

            ParameterField paramField5 = new ParameterField();
            ParameterDiscreteValue discreteVal5 = new ParameterDiscreteValue();
            paramField5.ParameterFieldName = "kickoffdateStart";
            discreteVal5.Value = User.KickOffDate_start;
            paramField5.CurrentValues.Add(discreteVal5);
            paramFields.Add(paramField5);

            ParameterField paramField6 = new ParameterField();
            ParameterDiscreteValue discreteVal6= new ParameterDiscreteValue();
            paramField6.ParameterFieldName = "kickoffdateEnd";
            discreteVal6.Value = User.KickOffDate_end;
            paramField6.CurrentValues.Add(discreteVal6);
            paramFields.Add(paramField6);

            NestingDetailViewer.ParameterFieldInfo = paramFields;
        }

        private void btnGenerar_Click(object sender, EventArgs e)
        {
            if(todos)
            {
                //C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedor.rpt
                FormProveedor formulario = new FormProveedor();
                ReportDocument crystalrpt = new ReportDocument();
                crystalrpt.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedor.rpt");
                formulario.crystalReportViewer1.ReportSource = crystalrpt;
                formulario.crystalReportViewer1.Refresh();
                formulario.Show();
            }
            else
            {
                DateTime fecha = dateDesde.Value;
                string fechaDesde = fecha.ToString("d");

                DateTime fecha2 = dateHasta.Value;
                string fechaHasta = fecha2.ToString("d");

                FormProveedoresParametros form = new FormProveedoresParametros();



                ReportDocument oRep = new ReportDocument();
             
                
                ParameterField pf = new ParameterField();
                ParameterFields pfs = new ParameterFields();
                ParameterDiscreteValue pdv = new ParameterDiscreteValue();
                pf.Name = "@fechaDesde";
                pdv.Value = fechaDesde;
                pf.CurrentValues.Add(pdv);
                
                pfs.Add(pf);

                pfs.Clear();


                pf.Name = "@fechaHasta";
                pdv.Value = fechaHasta;
                pf.CurrentValues.Add(pdv);

                pfs.Add(pf);

               
                 
                
                form.crystalReportViewer1.ParameterFieldInfo = pfs;
                oRep.Load(@"C:\Users\Usuario\Documents\GitHub\ProyectoProgramacion5\ProyectoProgV\ProyectoProgV\Presentacion\reporteProveedoresParametros.rpt");
                form.crystalReportViewer1.ReportSource = oRep;
                form.Show();
            }
           
        
        }