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