<< Click to Display Table of Contents >> CREATE_XXX_FILE |
![]() ![]() ![]() |
Creates a file in XXX format from the current result set. Currently supported file formats are:
•HTM - HTML document (can include also images)
•CSV - CSV document
•TXT - TXT document
•XLSX - XLSX document (Excel 2007+)
•DAT - DAT file (DAT format of SmartIS PC Client)
•XML - XML document (useful if you need to analyze the result by your own tool)
•JSON - JSON document
•WMF - netplans only
•EMF - netplans only
•BMP - netplans and barcharts only
•JPG - netplans and barcharts only
•TIF - netplans and barcharts only
•PNG - netplans and barcharts only
This command has one parameter that specifies the file name. If this parameter equals an empty string then the result is appended to an already opened file. Concatenation of files this way is useful only for HTML documents.
If you create images (netplans or barcharts) and keep the file name empty then a random file name is created where the image is saved and the link to this file is appended to the already opened HTML file. If no HTML file is opened the program prints an error.
If you specify also the file name when a graphic file is created then only the image is created.
If this command is called from a scan block then the file name can contain runtime variables. These variables are coded as %ColumnName%, where ColumnName is a name of the column as it appears in the report's header. This variable is then replaced with the real value of the column. The value is taken from the parent display.
create_htm_file="output\test.htm" // creates new HTML file test.htm
create_htm_file="" // appends HTML table to already opened HTML file
create_png_file="" // creates PGN file and insert link to this file to already opened HTML document
create_png_file="output\image.png" // creates only PNG file