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