When adding items to reports, there is a report-specific property that needs to be set to tell FCS Express where to insert the item in the final report. This property differs depending on report type. It is usually found on the Field page of the report item options dialog. For example, when you add a Regular Token from the Add Item to Report section of the Batch Actions and Reports window for either of these two report types, after the specific token has been chosen a dialog box will open to the Field page and the appropriate property can be entered in the corresponding edit field. You can also reach the Field page by right-clicking on the item in the Batch Process Actions and Reports list and selecting Properties from the pop-up menu.

 

•Excel (Column Mode) and Text Reports

 

The Column Name specifies the text that will appear in the report at the top of each column of data. For example, if the token you are exporting displays the number of events for a plot, a useful Column Name could be Number of Events. In FCS Express V5 and later versions, the report-specific property of Excel (Column Mode) and Text Reports defaults to the name of the item in your layout (e.g., the token description in Fig. 8.47).  To change this default behavior so that the field is left blank, see the Header Options.

 

 

Figure 1: Figure 8.45  Token description automatically exported to Excel as Column Name in FCS Express V5

Figure 1: Figure 8.45  Token description automatically exported to Excel as Column Name in FCS Express V5

 

 

If you wish to manually define the report-specific property in lieu of the default, enter it in Column Name field of the Field category (Figure 8.48).

 

Figure 8.46  Manually entering the Column Name property

Figure 8.46  Manually entering the Column Name property

 

 

 

•Excel (Cell Mode)

 

The report-specific property for Excel (Cell Mode) reports is set in the Cell Address field (Figure 8.49). The Cell Address specifies the Excel cell to write the data.

 

Figure 8.47 The Cell Address property

Figure 8.47 The Cell Address property

 

•Word

 

The specific property for Word reports is set in the Mail Merge field name which specifies the mail merge field in your Word template where the layout item will be placed (Figure 8.50). The field name must exactly match the name in the Word document.

 

Figure 8.48 The Mail Merge field name property

Figure 8.48 The Mail Merge field name property

 

•PDF Form

 

For PDF reports, the specific property is set by editing the Field Name (Figure 8.51). This specifies the text field in your PDF template where the layout item will be placed. The field name must match the corresponding field in the PDF.

 

Figure 8.49 The Field name property

Figure 8.49 The Field name property

www.denovosoftware.com