public ActionResult VisorReporte() //FileResult VisorReporte() { string RptPath = Server.MapPath("~/DataSet/Reportes/BitacorasWF/rptBitacoraWFGral.rdlc"); Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport(); /* Aplica Report Data Set */ #region Trae Información Microsoft.Reporting.WebForms.ReportDataSource Fuente = new Microsoft.Reporting.WebForms.ReportDataSource(); string archivoRDLC = RptPath;// @"wucReportes\Internos\Administrador\rpt_facturasxDia.rdlc"; string filtro = ""; string estatus = ""; //string fechaInicial = rdp_Inicial.SelectedDate.Value.ToString("yyyy-MM-dd"); //string fechaFinal = rdp_Final.SelectedDate.Value.ToString("yyyy-MM-dd"); //filtro = " WHERE (CONVERT(VARCHAR(10), CONVERT(nvarchar, Dia , 106), 103) BETWEEN '" + fechaInicial + "' AND '" + fechaFinal + "') "; //if (rbl_Estatus.SelectedValue.Equals("Todas") == true) //{ // estatus = ""; //} //else //{ // if (rbl_Estatus.SelectedValue.Equals("Paso") == true) // { // estatus = " And (Resultado='Paso')"; // } // else // { // estatus = " And (Resultado='No paso!')"; // } //} string Comando = "Select * from view_todoWorkflow " + filtro + estatus; string nombreDataSource = "DataSetReportes"; string nombreTabla = "view_facturasxDia"; //ad_Reportes reportes = new ad_Reportes(); System.Data.DataSet ds = new System.Data.DataSet(); System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(); con.ConnectionString = thisConnectionString; con.Open(); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = Comando; DataTable dt = new DataTable(); dt.TableName = nombreTabla; dt.Load(cmd.ExecuteReader()); ds.DataSetName = nombreDataSource; ds.Tables.Add(dt); con.Close(); Fuente.DataMember = nombreTabla; ReportViewer ReportViewer1 = new ReportViewer(); ReportViewer1.Reset(); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.EnableHyperlinks = true; ReportViewer1.LocalReport.EnableExternalImages = true; ReportViewer1.LocalReport.Dispose(); ReportViewer1.LocalReport.ReportPath = archivoRDLC; ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSetReportes", ds.Tables[0])); ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; ReportViewer1.LocalReport.DisplayName = "Detalles sobrefacturas procesadas con BAFAR por Click Factura " + DateTime.Now.ToShortTimeString(); ReportViewer1.LocalReport.Refresh(); #endregion Trae Información rpt.ReportPath = RptPath; string filePath = System.IO.Path.GetTempFileName(); Exportar(rpt, filePath); //Cerrar REPORT OBJECTO rpt.Dispose(); //return File(filePath, "application/pdf"); return(Json(filePath));//, "application/pdf"); }