| # Microsoft Excel devices You can define devices that allow you to print reports to an MS Excel spreadsheet. Note Printing reports to an MS Excel device is not supported in WorkTop. Defining a Microsoft Excel device To create a Microsoft Excel device: Start the Device Data (ttaad3500m000) session. Add a device. The Device Data (ttaad3100s000) session starts. Complete these steps: Specify the name and description for the device. In the Device Type field, select External Reporting Services. Leave the 4GL Program empty. In the Argument field, specify `-excel`, optionally followed by other parameters. For example: `-excel` Print the data to an Excel file. The file is stored in a folder on your computer. This folder is specified in the Path field. The filename has this format: `[report name]_[company number]_[yyyymmdd-hhmmss].xlsx` This is a sample filename: `ttaad340001000_000_20130626-202842.xlsx` `-excel -open` Similar to `-excel`. The Excel file is automatically opened. `-excel -nodatetimestamp` Similar to `-excel`. The Excel file has no date- and timestamp. The filename has this format: `[report name]_[company number].xlsx` This is a sample filename: `ttaad340001000_000.xlsx` `-excel -server` Similar to `-excel`. The file is stored in a folder on the server. This folder is specified in the Path field. In the Path field, specify the folder where the Excel file will be stored. Note If you use the `-server` option in the Argument field, specify a folder on the LN server. For example, `/home/jdoe/tmp` (Unix). If you do not use the `-server` option in the Argument field, specify a folder on your computer. For example, `c:\temp`. Specify the remaining device properties and save the device. For details, see the online help of the Device Data (ttaad3100s000) session. Printing reports to a Microsoft Excel device To print a report to a Microsoft Excel device: Start the print session to which the report is linked. Print the report. Points of attention: In the Device tab in the print session, select Advanced Device. In the Printer tab in the Select Device (ttstpsplopen ) session, select the Microsoft Excel device. A flat file with all input fields of the report is generated. |