About Layout Master
Layout Master (layoutmaster.xls) is a Excel file used to define the layout used when printing a report (Daily/Monthly/Yearly Report).
The following sheets are included in "layoutmaster.xls".
Sheet Name |
explanation |
Standard_DAY_P |
A4 landscape for daily reports |
Standard_MONTH_P |
A4 landscape monthly report |
Standard_YEAR_P |
For annual reports in landscape format (A4) |
With stamp column_DAY_P1 |
A4 landscape daily report with stamp space (first printed page) |
With stamp column_DAY_P2 |
For daily reports in landscape A4 size with a stamp column (printing from the second page onwards within one page) |
With stamp column_MONTH_P1 |
A4 landscape monthly report with stamp space (first printed page) |
With stamp column_MONTH_P2 |
For monthly reports in landscape format with a stamp column (printing from the second page onwards within one page) |
Seal column attached_YEAR_P1 |
For annual reports in landscape format with a stamp space (first printed page) |
Seal column attached_YEAR_P2 |
For annual reports in landscape format with a stamp column (printing from the second page onwards within one page) |
Standard (with load factor)_DAY_P |
Load factor A4 landscape daily report |
Standard (with load factor)_MONTH_P |
Load factor A4 landscape monthly report |
Standard (with load factor)_YEAR_P |
Load factor A4 landscape annual report |
With stamp column (with load factor)_DAY_P1 |
Load factor stamp column for daily reports (A4 landscape, first printed page) |
With stamp column (with load factor)_DAY_P2 |
Load factor stamp column included A4 landscape daily report (printing from the second page onwards within one page) |
With stamp column (with load factor)_MONTH_P1 |
Load factor stamp column for monthly report, A4 landscape (first printed page) |
With stamp column (with load factor)_MONTH_P2 |
A4 landscape monthly report with load factor stamp column (printing from the second page onwards within one page) |
With stamp column (with load factor)_YEAR_P1 |
Load factor stamp column for annual report, A4 landscape (first printed page) |
With stamp column (with load factor)_YEAR_P2 |
For annual reports in landscape A4 format with load factor stamp column (printing from the second page onwards within one page) |
Add "_P" to the end of the sheet name in the Layout Master File. If you specify a number after "_P", it will specify the page. For example, if you have prepared sheets "XXX_DAY_P1", "XXX_DAY_P2", and "XXX_DAY_P3", "XXX_DAY_P1" will be used for printing the first sheet on one page. Similarly, "XXX_DAY_P2" will be used for printing the second sheet on one page, and "XXX_DAY_P3" will be used for printing the third sheet on one page. "XXX_DAY_P3" will continue to be used for printing the fourth sheet on a page and beyond.
In the Layout Master File, you can link report data by embedding "keywords" in Excel cells. A keyword is a string that begins with "**", and when the report is displayed/printed, the actual data is replaced with the embedded keyword and output. For example, for the report title, there are predefined keywords such as "**F_PageTitle".
The keywords are as follows. The following keywords will cause data to be inserted in the order of the fields specified in the action. If the number of columns of fields does not fit on one page, a page break will automatically be started before printing.
keyword |
explanation |
**F_Date |
The date of the report. |
**F_ReferenceDate |
The report date offset by the reference time setting. |
**F_ReferenceDateStr |
The report date, as text in the format specified by the ReportReferenceDateFormat property in the Summary Master File. |
**F_PageTitle |
The title of the report. |
**F_TitleTotal |
The title of the total row set by ReportTitleTotal in the Summary Master File. |
**F_TitleAverage |
The title of the average row set by ReportTitleAve in the Summary Master File. |
**F_TitleMax |
The title of the maximum row set by ReportTitleMax in the Summary Master File. |
**F_TitleMin |
The minimum row title as set by ReportTitleMin in the Summary Master File. |
**F_TitleLoadFactor |
The title of the load factor row set by ReportTitleLoadFactor in the Summary Master File. |
**PT_Head **PT_Head[END] |
Header title. **PT_Head[0] is the first line. **PT_Head[1] is the second line. Up to 5 lines can be set. **PT_Head[END] specifies the rightmost column.
|
**FV_SideData |
For daily reports, it is the time. For monthly reports, it is the day. For annual reports, it is the month. The date format is set in the ReportTitleDateFormat property of the summary master file. |
**PT_Data **PT_Data[END] |
Aggregated data. Specify the rightmost column with **PT_Data[END]. |
**PL_Total **PL_Total[END] |
Total value. Specify the rightmost column with **PL_Total[END]. |
**PL_Average **PL_Average[END] |
Average value. Specify the rightmost column with **PL_Average[END]. |
**PL_Max **PL_Max[END] |
Maximum value. **PL_Max[END] specifies the rightmost column. |
**PL_Min **PL_Min[END] |
Minimum value. Use **PL_Min[END] to specify the rightmost column. |
**PARAM_PrintPage |
Print area. Prints the specified page area. If this parameter does not exist, only one page is printed. The setting value is specified in the cell to the right of the parameter. The parameter can be written anywhere on the sheet.
*For an example of how to use this parameter, see "Print pages with many lines without cutting them off".
|
Furthermore, by adding "_JOINT" to the end of each keyword in the layout master file, if the characters in adjacent cells match, the cells can be automatically merged during printing.
For example, if you define it as "**PT_Head_JOINT[0]", the first line of the header title (heading) will be automatically joined and printed if adjacent data is the same.
For an example of using "_JOINT", see "Merging cells in print layouts".
Whether or not Excel needs to be installed on the PC to be used
The layout master file requires Excel to edit the layout during development, but it is not necessary to install Excel on the PC where it will actually be used.
However, if you want to output subreports in Excel, you will need to install Excel.
In addition, if you want to use Excel functions such as graphs, formulas, and some autoshapes (rectangles, circles, text) in the layout master file, Excel must be installed on the PC you are actually using. If you want to use Excel objects in an environment where Excel is installed, set the ReportExcel property of the summary master file to T.
The Layout Master File supports the following Excel settings and formats:
Text/Text format/Cell format/Border/Paper size/Print orientation/Header/Footer
Page orientation (left to right/top to bottom) / bitmap file
When printing or exporting to an Excel file, the Summary Action populates the values according to the keywords set in the Layout Master File, and can take into account formatting settings such as the number of decimal places and commas.
■ If you want to set the format automatically
If you specify the following in the Aggregation Log section of the Summary Master, the Summary Action will automatically set the decimal point format for each cell (Note, however, that the formatting such as color, text font, and display position will follow the Excel cell format settings set in the Layout Master).
[RAW::DAY] ... ReportExcelCellFormatType=formatednum ... |
If you want to add a comma to the number, specify "formatednum2".
(Example of output when "formatednum2" is specified)
■ If you want to set the format on the Excel side
In most cases, the number of decimal places and comma formatting can be done by specifying "formatednum" or "formatednum2", but if for some reason you want to define it in the format of the cell in the Layout Master, specify "num" for the ReportExcelCellFormatType in the aggregation log section of the Summary Master. In the case of "num", the numbers are simply input as is into the Layout Master file, and the format when printed will follow the Excel cell format specified in the Layout Master.
[RAW::DAY] ... ReportExcelCellFormatType=num ... |
The above definition will adopt the number format of the Excel cell.
|
To embed a bitmap image in a layout master, select "Insert" and "Object" from the Excel menu, and insert the bitmap using the "From File" tab. Bitmaps pasted in any other way will not be printed.
|
