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
Open the report designer. Firstly connect the data source using the “Report > Data…” menu item. Then select the “DB cross-tab” object
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:
|
