private void btn_imprimir_Click(object sender, EventArgs e)
        {
            Random rnd       = new Random();
            int    randomnum = rnd.Next(1000);
            string root      = @"N:\PDF";

            if (!Directory.Exists(root))
            {
                Directory.CreateDirectory(root);
            }
            try
            {
                btn_imprimir.Enabled = false;



                formatearReporte();
                DocumentoExcel cr  = new DocumentoExcel();
                string         rut = @"N:\PDF\20300166611-01-ReportePorFecha" + dpickerInicio.Value.ToString("ddMMyyyy") + "-"
                                     + dpickerFin.Value.ToString("ddMMyyyy") + "-" + randomnum + ".pdf";
                // System.Web.HttpResponse res = new System.Web.HttpResponse();
                if (File.Exists(rut))
                {
                    File.Delete(rut);
                }
                cr.SetDataSource(objListaReporteExcel);
                cr.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, rut);
                using (PrintDialog Dialog = new PrintDialog())
                {
                    Dialog.ShowDialog();

                    ProcessStartInfo printProcessInfo = new ProcessStartInfo()
                    {
                        Verb           = "print",
                        CreateNoWindow = true,
                        FileName       = rut,
                        WindowStyle    = ProcessWindowStyle.Hidden
                    };

                    Process printProcess = new Process();
                    printProcess.StartInfo = printProcessInfo;
                    printProcess.Start();

                    printProcess.WaitForInputIdle();

                    Thread.Sleep(3000);

                    if (false == printProcess.CloseMainWindow())
                    {
                        printProcess.Kill();
                    }
                }
                btn_imprimir.Enabled = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " + ex.Message);
                btn_imprimir.Enabled = true;
            }
        }
        private void btn_pdf_Click(object sender, EventArgs e)
        {
            btn_pdf.Enabled = false;
            DocumentoExcel cr = new DocumentoExcel();

            formatearReporte();
            // System.Web.HttpResponse res = new System.Web.HttpResponse();
            cr.SetDataSource(objListaReporteExcel);
            SaveFileDialog saveFileDialog1 = new SaveFileDialog();

            saveFileDialog1.FileName = "20300166611-01-ReportePorFecha" + dpickerInicio.Value.ToString("ddMMyyyy") + "-"
                                       + dpickerFin.Value.ToString("ddMMyyyy") +
                                       ".pdf";
            saveFileDialog1.DefaultExt = "pdf";
            saveFileDialog1.Filter     = "Pdf files (*.pdf)|*.pdf";
            if (saveFileDialog1.ShowDialog() == DialogResult.OK)
            {
                cr.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @saveFileDialog1.FileName);
            }

            btn_pdf.Enabled = true;
        }