|
Now let's turn from theory to practice. We will construct a simple cross-tab report displaying employees’ salaries over four years. To do this we need the “crosstest” table, which is located in the FastReport “DEMOS\MAIN” folder. The table contains data like:
Name Year Salary
Ann 1999 3300
Ben 2002 2000
….
Create a new project in Delphi, place “TTable”, “TfrxDBDataSet” and “TfrxReport” components on the form and set their properties:
Table1:
DatabaseName = 'c:\Program Files\FastReport 4\Demos\Main'
TableName = 'crosstest.db'
the DatabaseName property, of course, must correspond to the path of your FastReport installation folder!
frxDBDataSet1:
DataSet = Table1
UserName = 'SimpleCross'
The “TfrxCrossObject” component  from the FastReport component palette is used to design a cross-tab report. Just place it on the Delphi form, it does not need any properties to be changed. The “frxCross” unit, containing the cross-tab functionality, is added to the “uses” list when the Delphi application is compiled.
Open the report designer. Firstly connect the data source using the “Report > Data…” menu item. Then select the “DB cross-tab” object  from the designer's object toolbar and click on the design page to place the object there:
All settings are made using the cross-tab editor. Open it by double-clicking on the object:
Key to the items shown above:
1 – a drop-down list of available data sources
2 – the list of fields in the selected data source; the fields from this list can be dragged to the lists numbered 3, 4 or 5
3 – the list of fields which generate line (row) headers
4 – the list of fields which generate column headers
5 – the list of fields which generate table cells
6 – table structure preview
7 – structure options : display of titles, totals, etc
You can only use the mouse in this editor to make changes. For our example it is only necessary to drag fields from the list 2 to lists 3, 4 and 5 (in the diagram above). After that close the editor by clicking the ОК button. The cross-tab object now shows its structure:
When the report is previewed you will see a table resembling this:
| 
