123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120 |
- using FastReport;
- using System.Data;
- using System.Windows;
- namespace ExportTo
- {
- /// <summary>
- /// Interaction logic for MainWindow.xaml
- /// </summary>
- public partial class MainWindow : Window
- {
- private DataSet dataSet;
-
- public MainWindow()
- {
- InitializeComponent();
- CreateDataSet();
- }
- private void CreateDataSet()
- {
- // create simple dataset with one table
- dataSet = new DataSet();
- DataTable table = new DataTable();
- table.TableName = "Employees";
- dataSet.Tables.Add(table);
- table.Columns.Add("ID", typeof(int));
- table.Columns.Add("Name", typeof(string));
- table.Rows.Add(1, "Andrew Fuller");
- table.Rows.Add(2, "Nancy Davolio");
- table.Rows.Add(3, "Margaret Peacock");
- }
- private Report GetReport()
- {
- // create report instance
- var report = new Report();
- // load the existing report
- report.Load("report.frx");
- // register the dataset
- report.RegisterData(dataSet);
- // run the report
- report.Prepare();
- return report;
- }
- private void ExportToPDF_Dialog(object sender, RoutedEventArgs e)
- {
- using (var report = GetReport())
- {
- // create export instance
- var export = new FastReport.Export.Pdf.PDFExport();
- // export using dialog
- export.Export(report);
- }
- }
- private void ExportToPDF_Silent(object sender, RoutedEventArgs e)
- {
- using (var report = GetReport())
- {
- // create export instance
- var export = new FastReport.Export.Pdf.PDFExport();
- // export to file
- report.Export(export, "result.pdf");
- }
- }
- private void ExportToHTML_Dialog(object sender, RoutedEventArgs e)
- {
- using (var report = GetReport())
- {
- // create export instance
- var export = new FastReport.Export.Html.HTMLExport();
- // export using dialog
- export.Export(report);
- }
- }
- private void ExportToHTML_Silent(object sender, RoutedEventArgs e)
- {
- using (var report = GetReport())
- {
- // create export instance
- var export = new FastReport.Export.Html.HTMLExport();
- // export to file
- report.Export(export, "result.html");
- }
- }
- private void ExportToExcel_Dialog(object sender, RoutedEventArgs e)
- {
- using (var report = GetReport())
- {
- // create export instance
- var export = new FastReport.Export.OoXML.Excel2007Export();
- // export using dialog
- export.Export(report);
- }
- }
- private void ExportToExcel_Silent(object sender, RoutedEventArgs e)
- {
- using (var report = GetReport())
- {
- // create export instance
- var export = new FastReport.Export.OoXML.Excel2007Export();
- // export to file
- report.Export(export, "result.xlsx");
- }
- }
- }
- }
|