When creating an .ods file to use as a report template, you can use the OpenOffice Calc formatting options to change the look and feel of your custom reports. SL1 includes several options for maintaining consistency across multiple output templates:
- Instead of including a static logo in reports, you can specify that a report will use the logo associated with each user's theme.
- For commonly used styles, you can add them to the global list of styles that is included with each report template downloaded from the Report Output Templates page.
- You can upload commonly used images to the Report Output Media page for re-use in multiple reports.
Use the following menu options to navigate the SL1 user interface:
- To view a pop-out list of menu options, click the menu icon (
).
- To view a page containing all of the menu options, click the Advanced menu icon (
).
Using Theme Logos
Instead of including a static logo in reports, you can specify that a report will use the report logo assigned to each user's theme. To assign a report logo to a theme:
- Go to the Theme Management page (System > Customize > Themes) in the classic SL1 user interface.
- Select the wrench icon (
) for the theme to which you want to assign a new report logo. The Theme Editor page is displayed.
- In the Theme Images section, select a new logo in the Report Logo field. You can upload a new logo for use in this field under the tab.
- Click . Users who subscribe to this theme will see the new logo in all reports that use the report logo setting.
To configure an output template to use the Report Logo from a theme:
- In the output template for the report, merge or expand cells to create an appropriately sized cell that can display the report image. SL1 will automatically proportionally scale the report logos to fit this cell; the image will be scaled until either the height or width is the same as the height or width of the cell. In most of the ScienceLogic default reports, this cell is 5 standard rows high and a width proportional to the data displayed in the report. For example, the Asset Warranty Expiration report includes the input options in the header. The width of the report image is the remaining width of the data table:
- In the cell, enter the following output directive, entering the desired alignment settings where indicated:
- left. The image will be aligned to the left border of the cell.
- right. The image will be aligned to the right border of the cell.
- center. The image will be equidistant from the left and right borders of the cell.
- top. The image will be aligned to the top border of the cell.
- bottom. The image will be aligned to the bottom border of the cell.
- middle. The image will be equidistant from the top and bottom borders of the cell.
- Add a default logo image to the report and anchor the image to the cell.

[bindimage:logoimage:<alignment 1>:<alignment 2>]
Possible values for the first alignment setting are:
Possible values for the second alignment setting are:
Adding Global Styles
For commonly used styles, you can add them to the global list of styles that is included with each report template downloaded from the Report Output Templates page (Reports > Management > Report Output Templates).
To view the list of global styles, go to the Report Output Styles page (Reports > Management > Report Output Styles).
For each global style, the page displays the following information:
- Style Family. The type of style.
- Style Name. The name of the style.
- Style Description. A description of the style. You can select the wrench icon (
) in this field to edit the description of the style.
- Parent Style. The style that this style is linked to in OpenOffice.
- Edited By. The user that last imported the style.
- Edited On. The date and time that the style was last edited.
To add a global style:
- Go to the Report Output Styles page (Reports > Management > Report Output Styles).
- Select the button and save the em7_styles.ods file to your local system.
- In the em7_styles.ods file, create a new custom style and save the .ods file. For information about adding and editing custom styles in OpenOffice Calc, see: https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Styles_and_Templates.
- In the Report Output Styles page, click the button.
- In the modal page that appears, select the Import Styles page is displayed. button, locate the updated em7_styles.ods file, and then select the button. The
- Select the checkbox for your new style and select the button.
- Your new style will now be displayed in the Report Output Styles page and will be included when an output template is downloaded with global styles from the Report Output Templates page. To add a description, select the wrench icon for the new style (
).
Although new styles will be included in existing output templates when they are downloaded from the Report Output Templates page, new styles are not automatically added to the existing templates; if you generate a report in .ods format, the new style will not automatically appear.
Report Output Media
You can upload commonly used images to the Report Output Media page for re-use in multiple reports.
To upload an image:
- Go to the Report Output Media page (Reports > Management > Report Output Media).
- Select the button.
- In the modal page that appears, select the button, locate the image file on your local system, and then select the button.
To configure a report to use the image:
- In the output template for the report, merge or expand cells to create an appropriately sized cell that can display the image. SL1 will automatically proportionally scale the image to fit this cell, i.e. the image will be scaled until either the height or width is the same as the height or width of the cell.
- In the cell, enter the following output directive, entering a unique output variable name and the desired alignment settings where indicated:
[bindimage:<variable_name>:<alignment 1>:<alignment 2>]
- left. The image will be aligned to the left border of the cell.
- right. The image will be aligned to the right border of the cell.
- center. The image will be equidistant from the left and right borders of the cell.
- top. The image will be aligned to the top border of the cell.
- bottom. The image will be aligned to the bottom border of the cell.
- middle. The image will be equidistant from the top and bottom borders of the cell.
- Add a default logo image to the report and anchor the image to the cell.
- In your report gluecode, use the following function, entering the file name of the image (displayed in the Report Output Media page) and the output variable name (specified in the output directive) where indicated:
Possible values for the first alignment setting are:
Possible values for the second alignment setting are:
$output['<variable_name>']=od_image('<image_file_name>');
To delete an image:
- Go to the Report Output Media page (Reports > Management > Report Output Media).
- Select the checkbox for the image(s) you want to delete.
- In the Select Action drop-down list in the lower right of the page, select the Delete File button, and then select the button.