public ActionResult Report(string id, string rdlc, string NameDataSet)
{
LocalReport lr = new LocalReport();
string path = Path.Combine(Server.MapPath("~/ReportViewer"), rdlc + ".rdlc");
if (System.IO.File.Exists(path))
{
lr.ReportPath = path;
}
else
{
return(View("Index"));
}
List <sp_RepUsuarios_Result> cm = new List <sp_RepUsuarios_Result>();
using (RacePuntosEntities dc = new RacePuntosEntities())
{
cm = dc.sp_RepUsuarios().ToList();
}
ReportDataSource rd = new ReportDataSource(NameDataSet, cm);
lr.DataSources.Add(rd);
string reportType = id;
string mimeType;
string encoding;
string fileNameExtension;
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>" + id + "</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.5in</MarginTop>" +
" <MarginLeft>1in</MarginLeft>" +
" <MarginRight>1in</MarginRight>" +
" <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
renderedBytes = lr.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
return(File(renderedBytes, mimeType));
}
public ActionResult Report(string id, string rdlc, string NameDataSet, string cDesde, string cHasta, string servicios)
{
cDesde = (cDesde != "" && cDesde != "null") ? cDesde : null;
cHasta = (cHasta != "" && cHasta != "null") ? cHasta : null;
servicios = (servicios != "" && servicios != "null") ? servicios : null;
LocalReport lr = new LocalReport();
string path = Path.Combine(Server.MapPath("~/ReportViewer"), rdlc + ".rdlc");
if (System.IO.File.Exists(path))
{
lr.ReportPath = path;
}
else
{
return(View("Index"));
}
List <sp_RepHistRedmPuntos_Result> cm = new List <sp_RepHistRedmPuntos_Result>();
using (RacePuntosEntities dc = new RacePuntosEntities())
{
cm = dc.sp_RepHistRedmPuntos(cDesde, cHasta, servicios).ToList();
}
ReportDataSource rd = new ReportDataSource(NameDataSet, cm);
lr.DataSources.Add(rd);
ReportParameter[] parameters = new ReportParameter[3];
parameters[0] = new ReportParameter("Fecha_I", cDesde);
parameters[1] = new ReportParameter("Fecha_F", cHasta);
parameters[2] = new ReportParameter("Servicios", servicios);
lr.SetParameters(parameters);
string reportType = id;
string mimeType;
string encoding;
string fileNameExtension;
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>" + id + "</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.5in</MarginTop>" +
" <MarginLeft>1in</MarginLeft>" +
" <MarginRight>1in</MarginRight>" +
" <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
renderedBytes = lr.Render(
reportType,
deviceInfo,
out mimeType,
out encoding,
out fileNameExtension,
out streams,
out warnings);
return(File(renderedBytes, mimeType));
}
