public static void Run()
{
var query = TestRepository.GetAllProducts();
var reportDataSource = query.ToReportDataSource("Products");
var reportDefinition = ReportDefinition.FromJson(
EmbeddedResource.GetResourceTextFile("Sample2ReportDefinition.json"));
var report = SimpleExporter.CreateReport(reportDefinition, reportDataSource);
report.SetTextBlock("titleId", "Titulo de Prueba");
report.SetTextBlock("subtitleId", "Other text for the sample");
//CSV
using (var fs = File.Create("Sample2.csv"))
{
var writer = new DelimitedTextReportWriter();
report.WriteReport(fs, writer);
Console.WriteLine("(CSV) Sample 2 created: {0}", fs.Name);
}
//Xlsx
using (var fs = File.Create("Sample2.xlsx"))
{
var writer = new XlsxReportWriter();
report.WriteReport(fs, writer);
Console.WriteLine("(Xlsx) Sample 2 created: {0}", fs.Name);
}
}
public static void Run()
{
var query = TestRepository.GetAllPerson();
var reportDataSource = query.ToReportDataSource("Persons");
var reportDefinition = ReportDefinition.FromJson(
EmbeddedResource.GetResourceTextFile("Sample3ReportDefinition.json"));
var report = SimpleExporter.CreateReport(reportDefinition, reportDataSource);
report.SetTextBlock("titleId", "Titulo de Prueba");
report.SetTextBlock("subtitleId", "Subtitulo");
var table = (Table)reportDefinition.Body[2];
table.Columns = GetColumns(query);
//CSV
using (var fs = File.Create("Sample3.csv"))
{
var writer = new DelimitedTextReportWriter();
report.WriteReport(fs, writer);
Console.WriteLine("(CSV) Sample 3 created: {0}", fs.Name);
}
//Xlsx
using (var fs = File.Create("Sample3.xlsx"))
{
var writer = new XlsxReportWriter();
report.WriteReport(fs, writer);
Console.WriteLine("(Xlsx) Sample 3 created: {0}", fs.Name);
}
}
public static void Run()
{
var query = TestRepository.GetAllProducts();
var reportDataSource = query.ToReportDataSource("Products");
var reportDefinition = ReportDefinition.FromJson(
EmbeddedResource.GetResourceTextFile("Sample1ReportDefinition.json"));
var report = SimpleExporter.CreateReport(reportDefinition, reportDataSource);
//CSV
using (var fs = File.Create("Sample1.csv"))
{
var writer = new DelimitedTextReportWriter();
report.WriteReport(fs, writer);
Console.WriteLine("(CSV) Sample 1 created: {0}", fs.Name);
}
//Xlsx
using (var fs = File.Create("Sample1.xlsx"))
{
var writer = new XlsxReportWriter();
report.WriteReport(fs, writer);
Console.WriteLine("(Xlsx) Sample 1 created: {0}", fs.Name);
}
//PDF
using (var fs = File.Create("Sample1.pdf"))
{
var writer = new PdfReportWriter();
report.WriteReport(fs, writer);
Console.WriteLine("(PDF) Sample 1 created: {0}", fs.Name);
}
}
void RenderReport(HttpContext context)
{
var type = context.Request.QueryString["type"];
Report report;
switch (type)
{
case "GdpByYear":
report = Reports.GdpByYearReport.Generate();
break;
case "GdpByCountry":
report = Reports.GdpByCountryReport.Generate();
break;
case "BiggestCountries":
report = Reports.GdpYearColumnReport.BiggestCountries();
break;
case "FastestGrowingCountries":
report = Reports.GdpYearColumnReport.FastestGrowingCountries();
break;
case "BestCountries":
report = Reports.GdpYearColumnReport.BestCountries();
break;
default:
throw new InvalidOperationException("Invalid report type.");
}
try
{
switch (context.Request.QueryString["format"])
{
case "pdf":
var url = context.Request.Url.ToString().Replace("format=pdf", "print=1");
PdfConvert.ConvertHtmlToPdf(new PdfDocument {
Url = url
}, new PdfOutput {
OutputStream = context.Response.OutputStream
});
context.Response.SetFileDownloadHeaders(String.Format("Report{0}.pdf", DateTime.Now.Ticks));
break;
case "text":
context.Response.SetFileDownloadHeaders(String.Format("Report{0}.txt", DateTime.Now.Ticks));
TextReportWriter.WriteTo(report, context.Response.Output);
break;
case "xlsx":
context.Response.SetFileDownloadHeaders(String.Format("Report{0}.xlsx", DateTime.Now.Ticks));
XlsxReportWriter.WriteToStream(report, Themes.Default, context.Response.OutputStream);
break;
default:
var output = new HtmlTextWriter(context.Response.Output);
var htmlWriter = new HtmlReportWriter(output);
htmlWriter.RegisterCss(DextopUtil.AbsolutePath("client/css/report.css"));
if (context.Request.QueryString["print"] == null)
{
htmlWriter.RegisterCss(DextopUtil.AbsolutePath("client/css/report-preview.css"));
}
htmlWriter.Write(report, new DefaultHtmlReportTheme());
break;
}
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
}
