MainWindow.xaml.cs 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120
  1. using FastReport;
  2. using System.Data;
  3. using System.Windows;
  4. namespace ExportTo
  5. {
  6. /// <summary>
  7. /// Interaction logic for MainWindow.xaml
  8. /// </summary>
  9. public partial class MainWindow : Window
  10. {
  11. private DataSet dataSet;
  12. public MainWindow()
  13. {
  14. InitializeComponent();
  15. CreateDataSet();
  16. }
  17. private void CreateDataSet()
  18. {
  19. // create simple dataset with one table
  20. dataSet = new DataSet();
  21. DataTable table = new DataTable();
  22. table.TableName = "Employees";
  23. dataSet.Tables.Add(table);
  24. table.Columns.Add("ID", typeof(int));
  25. table.Columns.Add("Name", typeof(string));
  26. table.Rows.Add(1, "Andrew Fuller");
  27. table.Rows.Add(2, "Nancy Davolio");
  28. table.Rows.Add(3, "Margaret Peacock");
  29. }
  30. private Report GetReport()
  31. {
  32. // create report instance
  33. var report = new Report();
  34. // load the existing report
  35. report.Load("report.frx");
  36. // register the dataset
  37. report.RegisterData(dataSet);
  38. // run the report
  39. report.Prepare();
  40. return report;
  41. }
  42. private void ExportToPDF_Dialog(object sender, RoutedEventArgs e)
  43. {
  44. using (var report = GetReport())
  45. {
  46. // create export instance
  47. var export = new FastReport.Export.Pdf.PDFExport();
  48. // export using dialog
  49. export.Export(report);
  50. }
  51. }
  52. private void ExportToPDF_Silent(object sender, RoutedEventArgs e)
  53. {
  54. using (var report = GetReport())
  55. {
  56. // create export instance
  57. var export = new FastReport.Export.Pdf.PDFExport();
  58. // export to file
  59. report.Export(export, "result.pdf");
  60. }
  61. }
  62. private void ExportToHTML_Dialog(object sender, RoutedEventArgs e)
  63. {
  64. using (var report = GetReport())
  65. {
  66. // create export instance
  67. var export = new FastReport.Export.Html.HTMLExport();
  68. // export using dialog
  69. export.Export(report);
  70. }
  71. }
  72. private void ExportToHTML_Silent(object sender, RoutedEventArgs e)
  73. {
  74. using (var report = GetReport())
  75. {
  76. // create export instance
  77. var export = new FastReport.Export.Html.HTMLExport();
  78. // export to file
  79. report.Export(export, "result.html");
  80. }
  81. }
  82. private void ExportToExcel_Dialog(object sender, RoutedEventArgs e)
  83. {
  84. using (var report = GetReport())
  85. {
  86. // create export instance
  87. var export = new FastReport.Export.OoXML.Excel2007Export();
  88. // export using dialog
  89. export.Export(report);
  90. }
  91. }
  92. private void ExportToExcel_Silent(object sender, RoutedEventArgs e)
  93. {
  94. using (var report = GetReport())
  95. {
  96. // create export instance
  97. var export = new FastReport.Export.OoXML.Excel2007Export();
  98. // export to file
  99. report.Export(export, "result.xlsx");
  100. }
  101. }
  102. }
  103. }