| Microsoft Excel devices (CE)You can define devices that allow you to print reports to an MS
Excel spreadsheet. 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
- 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.
| |