"Subject list" report

Open Report register and create new report. Set report "Name" to Subject List. Open the FastReport designer by selecting clicking the “Design...” menu item in Wizard. ​ In report designer window click the “New report” button there to automatically create a basic report design with three bands (“Report title,” “Master data” and “Page footer”). On tab "Data"  and drag a “TfrxDlDBTable” object and drop it onto the workplace. Set property "TableName" to tHE_SetSubj. In this table data about subjects are stored. 

Now let’s design the report. First, add a “Text” object containing “Subject List” to the “ReportTitle” band.

Next, connect the “MasterData” band to our dataset. This can done in any of three ways:

- double-click on the band

- select “Edit...” in the band’s contextual menu

- or click on the “DataSet” property of the band in the Object inspector.

Now place four “Text” objects (which will display the client number, customer name, phone and fax fields from the dataset) on the band. Let’s do this in several different ways to demonstrate some features of the FastReport designer.

The first way is to place a “Text” object on the band and type "[frxDBDataSet1."CustNo"]" into it. This is the least convenient way, since the field link has to be entered manually, with the possibility of incorrectly typing the text. Somewhat easier is to use the expression designer - double-click the “Text” object and click the leftmost button on the “Text” tab of the editor window which opens. To insert our field double-click the field name in the expression designer. Click the OK button to close the dialogue and see the field link inserted into the “Text” object.

The second way of adding the DB field to the “Text” object is by setting two properties in the object inspector. Place a second “Text” object on the band, without writing anything in the editor window. Set the object’s properties using the object inspector:

DataSet = frxDBDataSet1

DataField = 'Company'

Both of these properties are presented as a list, so just select the required value from the drop-down using the mouse.

The third way is to “drag and drop” the required field from the “Data tree” pane into the report. This is the simplest and easiest way, but before doing it uncheck the “Create header” checkbox at the bottom of the “Data tree” pane, otherwise a second “Text” object, containing the field’s name, is created in addition to the field link object itself. In this way select the “Phone” field and drag it onto the band.

The fourth way requires the designer option “Show drop-down fields list” flag to be set (via main menu : “View>Options”) and the band to be already connected to the dataset. Place a blank “Text” object on the band and hover the cursor over the object – a drop-down button will appear at the right hand end. Click this button to open the list of DB fields and select the ”FAX” field.

Our report design is complete.

Click on the “Preview” button to see the result.