Sparkline.frx 6.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Report ScriptLanguage="CSharp" ReportInfo.Description="This report demonstrates SparklineObject features." ReportInfo.Created="05/16/2008 01:44:40" ReportInfo.Modified="03/24/2023 02:33:49" ReportInfo.CreatorVersion="1.0.0.0">
  3. <Dictionary>
  4. <TableDataSource Name="Employees" ReferenceName="NorthWind.Employees" DataType="System.Int32" Enabled="true">
  5. <Column Name="EmployeeID" DataType="System.Int32"/>
  6. <Column Name="LastName" DataType="System.String"/>
  7. <Column Name="FirstName" DataType="System.String"/>
  8. <Column Name="Title" DataType="System.String"/>
  9. <Column Name="TitleOfCourtesy" DataType="System.String"/>
  10. <Column Name="BirthDate" DataType="System.DateTime"/>
  11. <Column Name="HireDate" DataType="System.DateTime"/>
  12. <Column Name="Address" DataType="System.String"/>
  13. <Column Name="City" DataType="System.String"/>
  14. <Column Name="Region" DataType="System.String"/>
  15. <Column Name="PostalCode" DataType="System.String"/>
  16. <Column Name="Country" DataType="System.String"/>
  17. <Column Name="HomePhone" DataType="System.String"/>
  18. <Column Name="Extension" DataType="System.String"/>
  19. <Column Name="Photo" DataType="System.Byte[]" BindableControl="Picture"/>
  20. <Column Name="Notes" DataType="System.String"/>
  21. <Column Name="ReportsTo" DataType="System.Int32"/>
  22. </TableDataSource>
  23. <TableDataSource Name="Orders" ReferenceName="NorthWind.Orders" DataType="System.Int32" Enabled="true">
  24. <Column Name="OrderID" DataType="System.Int32"/>
  25. <Column Name="CustomerID" DataType="System.String"/>
  26. <Column Name="EmployeeID" DataType="System.Int32"/>
  27. <Column Name="OrderDate" DataType="System.DateTime"/>
  28. <Column Name="RequiredDate" DataType="System.DateTime"/>
  29. <Column Name="ShippedDate" DataType="System.DateTime"/>
  30. <Column Name="ShipVia" DataType="System.Int32"/>
  31. <Column Name="Freight" DataType="System.Decimal"/>
  32. <Column Name="ShipName" DataType="System.String"/>
  33. <Column Name="ShipAddress" DataType="System.String"/>
  34. <Column Name="ShipCity" DataType="System.String"/>
  35. <Column Name="ShipRegion" DataType="System.String"/>
  36. <Column Name="ShipPostalCode" DataType="System.String"/>
  37. <Column Name="ShipCountry" DataType="System.String"/>
  38. <Column Name="Latitude" DataType="System.Double"/>
  39. <Column Name="Longitude" DataType="System.Double"/>
  40. </TableDataSource>
  41. <Relation Name="EmployeesOrders" ReferenceName="NorthWind.EmployeesOrders" ParentDataSource="Employees" ChildDataSource="Orders" ParentColumns="EmployeeID" ChildColumns="EmployeeID" Enabled="true"/>
  42. <Parameter Name="CurrentEmployee" DataType="System.String" AsString=""/>
  43. </Dictionary>
  44. <ReportPage Name="Page1" Watermark.Font="Segoe UI, 60pt">
  45. <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="85.05" CanGrow="true">
  46. <TextObject Name="Text1" Width="718.2" Height="37.8" Text="SparklineObject" HorzAlign="Center" VertAlign="Center" Font="Segoe UI, 14pt, style=Bold"/>
  47. <TextObject Name="Text13" Top="47.25" Width="718.2" Height="37.8" Fill.Color="110, 145, 190" Text="SALES BY EMPLOYEE" VertAlign="Center" Font="Segoe UI, 16pt" TextFill.Color="White"/>
  48. </ReportTitleBand>
  49. <DataBand Name="Data1" Top="87.05" Width="718.2" Height="66.15" Border.Lines="All" Border.Color="Gainsboro" BeforePrintEvent="Data1_BeforePrint" DataSource="Employees">
  50. <TextObject Name="Text2" Left="9.45" Width="330.75" Height="66.15" Text="[Employees.FirstName] [Employees.LastName]" VertAlign="Center" Font="Segoe UI, 9pt"/>
  51. <SparklineObject Name="Sparkline1" Left="510.3" Top="9.45" Width="198.45" Height="47.25" DataSource="Orders" AutoSeriesColumn="" ChartData="PENoYXJ0IEJvcmRlcmxpbmVDb2xvcj0iRGFya0dyYXkiIEJvcmRlcmxpbmVXaWR0aD0iMiI+DQogIDxTZXJpZXM+DQogICAgPFNlcmllcyBOYW1lPSJTZXJpZXMxIiBMZWdlbmQ9IkRlZmF1bHQiIFhWYWx1ZVR5cGU9IkRhdGUiIFlWYWx1ZVR5cGU9IkludDMyIiBDaGFydFR5cGU9IkZhc3RMaW5lIiBDaGFydEFyZWE9IkRlZmF1bHQiIEZvbnQ9Ik1pY3Jvc29mdCBTYW5zIFNlcmlmLCA4cHQiIE1hcmtlclN0eWxlPSJDaXJjbGUiIE1hcmtlclNpemU9IjEzIiBNYXJrZXJDb2xvcj0iT3JhbmdlUmVkIj4NCiAgICAgIDxQb2ludHM+DQogICAgICAgIDxEYXRhUG9pbnQgWVZhbHVlcz0iMSIgQXhpc0xhYmVsPSJBIiAvPg0KICAgICAgICA8RGF0YVBvaW50IFlWYWx1ZXM9IjMiIEF4aXNMYWJlbD0iQiIgLz4NCiAgICAgICAgPERhdGFQb2ludCBZVmFsdWVzPSIyIiBBeGlzTGFiZWw9IkMiIC8+DQogICAgICAgIDxEYXRhUG9pbnQgWVZhbHVlcz0iNCIgQXhpc0xhYmVsPSJEIiAvPg0KICAgICAgPC9Qb2ludHM+DQogICAgPC9TZXJpZXM+DQogIDwvU2VyaWVzPg0KICA8TGVnZW5kcz4NCiAgICA8TGVnZW5kIE5hbWU9IkRlZmF1bHQiIEVuYWJsZWQ9IkZhbHNlIiBJc1RleHRBdXRvRml0PSJGYWxzZSI+DQogICAgPC9MZWdlbmQ+DQogIDwvTGVnZW5kcz4NCiAgPFRpdGxlcz4NCiAgICA8VGl0bGUgTmFtZT0iVGl0bGUxIiBWaXNpYmxlPSJGYWxzZSI+DQogICAgPC9UaXRsZT4NCiAgPC9UaXRsZXM+DQogIDxDaGFydEFyZWFzPg0KICAgIDxDaGFydEFyZWEgTmFtZT0iRGVmYXVsdCI+DQogICAgICA8QXhpc1kgSXNMYWJlbEF1dG9GaXQ9IkZhbHNlIiBFbmFibGVkPSJGYWxzZSI+DQogICAgICAgIDxNYWpvckdyaWQgTGluZUNvbG9yPSI2NCwgNjQsIDY0LCA2NCIgLz4NCiAgICAgIDwvQXhpc1k+DQogICAgICA8QXhpc1ggSXNMYWJlbEF1dG9GaXQ9IkZhbHNlIiBFbmFibGVkPSJGYWxzZSI+DQogICAgICAgIDxNYWpvckdyaWQgTGluZUNvbG9yPSI2NCwgNjQsIDY0LCA2NCIgLz4NCiAgICAgIDwvQXhpc1g+DQogICAgICA8QXhpc1gyIElzTGFiZWxBdXRvRml0PSJGYWxzZSI+DQogICAgICAgIDxNYWpvckdyaWQgTGluZUNvbG9yPSI2NCwgNjQsIDY0LCA2NCIgLz4NCiAgICAgIDwvQXhpc1gyPg0KICAgICAgPEF4aXNZMiBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICA8L0F4aXNZMj4NCiAgICA8L0NoYXJ0QXJlYT4NCiAgPC9DaGFydEFyZWFzPg0KPC9DaGFydD4=">
  52. <MSChartSeries Name="Series1" Filter="[Employees.EmployeeID] == [Orders.EmployeeID]" SortBy="XValue" GroupBy="Months" GroupFunction="Count" CollectValue="1" CollectedItemColor="OrangeRed" XValue="[Orders.OrderDate]" YValue1="[Orders.OrderID]"/>
  53. </SparklineObject>
  54. </DataBand>
  55. <PageFooterBand Name="PageFooter1" Top="155.2" Width="718.2" Height="28.35" Fill.Color="WhiteSmoke">
  56. <TextObject Name="Text12" Left="9.45" Width="217.35" Height="28.35" Cursor="Hand" Hyperlink.Value="https://www.fast-report.com/en/product/fast-report-net/" Text="Generated by FastReport" VertAlign="Center" Font="Segoe UI, 9pt, style=Underline" TextFill.Color="Blue"/>
  57. </PageFooterBand>
  58. </ReportPage>
  59. </Report>