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");
}