Layton ServiceDesk - Reporting - Report Design Layout

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Minor formatting changes, image replacements)
(Major rewrite)
Line 45: Line 45:
 
Reports can be generated automatically on a scheduled basis and sent via email in a PDF format. The scheduled reports are processed by the LaytonServiceDesk service which is running on the Layton ServiceDesk IIS server. The process to create a schedule a report works in a same manner as scheduling a recurring Task.  
 
Reports can be generated automatically on a scheduled basis and sent via email in a PDF format. The scheduled reports are processed by the LaytonServiceDesk service which is running on the Layton ServiceDesk IIS server. The process to create a schedule a report works in a same manner as scheduling a recurring Task.  
  
To schedule a report click on the Schedule Report icon in the Reports sub-menu. You will then be presented with a list of the currently scheduled reports. This will show the report name, last run time, next run time, scheduling details and icons to set the email information and a delete button.
+
To schedule a report, click the Schedule Reports button in the Reports sub-menu. You will then be presented with a list of the currently scheduled reports. This will show the report name, last run time, next run time, scheduling details and buttons to edit the email settings and to delete the schedule.
  
Click on the add new icon to add a new schedule. You will then receive a pop up window which will allow you to select the report that you want to schedule from the drop down list of reports. Once you have selected the report you can create the schedule. Once the schedule is saved the email message page will be displayed. Enter the email address that the report is to be emailed to; you can enter multiple email addresses separated by a semi colon. Once the email message is completed and saved you will be returned you to the list of scheduled reports.
+
#Click the Add button [[File:Lsd btn plus.png|link=]] to add a new schedule.
 +
#In the Name dialog, Give the schedule a name.
 +
#Select the report from the Report menu..
 +
#Specify the format of the report. You can choose PDF, CSV or both.
 +
#Click the Save button [[File:Lsd btn save.png|link=]].
 +
#The Schedule dialog will open. Choose a schedule and click the Save button [[File:Lsd btn save.png|link=]].
 +
#The Report Email Body page will open. Enter an email address or addresses separated by a semicolon, a subject and a body. Click the Save button [[File:Lsd btn save.png|link=]].
  
 
=Access Control=
 
=Access Control=

Revision as of 03:09, 27 January 2016

Btn back up.png Back to Contents

Btn back up.png Previous article in this series: Creating Charts

Contents

Layout

The report layouts may be modified from the report design layout button Lsd btn rpt design layout.png:


Lsd rpt design layout01.png


The report design page allows you to modify the layout of each report using the same user-friendly drag-and-drop feature which is used throughout the application:


Lsd rpt design layout02.png


The floating toolbar is used to add labels, images and set the page properties. For more information on form design please see the form design section.

To change the position of the grid or chart, using the handle in the top left hand corner of the grid, drag the grid to the desired position on the page. You can also click on the grid or chart link next to the handle to set the left and top pixel positions.

To resize a report data field or change the field properties click on the field link. You can change the heading of the field, font type, size, field size, field color etc. You can also resize the field width by hovering between the field headings until you see the left and right arrows which will allow you to drag the field to the left or right to resize.

Images and labels can be added to the reports using the add label and add images button on the floating toolbar. For more information please see the main form design section.

Exporting Reports

The Layton ServiceDesk reports can be exported in the following formats, PDF, XLS or CSV. Once a report has been run the PDF, XLS and CSV icons will be displayed in the reports sub-menu. Please note that when exporting the report in XLS format Excel will prompt you that the file is in a different format to the file extension and to verify the source. Click "Yes" to this prompt and the report will be displayed as an XLS file.

Quick Tip: When you export a report to PDF or schedule the report, the data grid and charts are automatically scaled to fit the PDF perfectly, you do not need to worry about how wide or long the grid size is on the screen as Layton ServiceDesk will scale the grid to best fit the page layout, however, you may wish to change the page orientation if you have many columns and the grid is quite wide so maximize the amount of data you can get across the page.

PDF Reports

In report design mode on the floating toolbar there is a PDF icon which allows you to see the report PDF Settings. Each Layton ServiceDesk report can have its own PDF setting. The PDF settings include many options such page format (E.g. US Letter, A4, etc.), page orientation (Portrait or Landscape), margin settings along with header and footer options. You can even create passwords and security settings for the PDF.

In the PDF footer or header text field you can use the system value of {{Datetime}} and this will show the date and time that the report was generated.

PDF Security Settings

The PDF Security Settings allow you to protect sensitive reports from either being viewed, printed, copied once the PDF is created. This is adds an extra level of security and peace of mind when emailing or distributing reports. There are two password options:

  • Owner
  • User

The Owner password is the administrator that has set the PDF settings and will have full access control to the PDF document when it is created and the correct Owner (admin) password entered.

The User setting is the password you would supply to the end user where the PDF restrictions are set and what the end user can do with the PDF, eg Print, Copy text etc.

Scheduling Reports

Reports can be generated automatically on a scheduled basis and sent via email in a PDF format. The scheduled reports are processed by the LaytonServiceDesk service which is running on the Layton ServiceDesk IIS server. The process to create a schedule a report works in a same manner as scheduling a recurring Task.

To schedule a report, click the Schedule Reports button in the Reports sub-menu. You will then be presented with a list of the currently scheduled reports. This will show the report name, last run time, next run time, scheduling details and buttons to edit the email settings and to delete the schedule.

  1. Click the Add button Lsd btn plus.png to add a new schedule.
  2. In the Name dialog, Give the schedule a name.
  3. Select the report from the Report menu..
  4. Specify the format of the report. You can choose PDF, CSV or both.
  5. Click the Save button Lsd btn save.png.
  6. The Schedule dialog will open. Choose a schedule and click the Save button Lsd btn save.png.
  7. The Report Email Body page will open. Enter an email address or addresses separated by a semicolon, a subject and a body. Click the Save button Lsd btn save.png.

Access Control

By default all Analysts have access to run the reports and statistics. Only Administrators will have access to create, modify, schedule or delete reports.

To turn off Analyst Access to the Reports and Statistics go to Administration > Company Structure > Manage Analyst > Settings > Access Restrictions. Options in this section are; Reports Access, Statistics Access & Statistics Group Access. There are also additional options in Administration > Company Structure > Manage Analyst > Settings > Site Access > Statistics Access.

If an Analyst is denied access to the Reports and Statistics the main Reporting menu will not be available for this Analyst.

Security can also be applied on an individual report by report basis. To restrict analyst access to a particular report click on the edit report icon and then click on the security icon on the report builder page. A new page will be displayed showing the current security settings. By default all of the reports have the access restriction turned off. To turn on the security simply select the "Restrict Access" button and select the Analysts which are to have access to this report.

Copying a Report

The Copy report button allows you to create a copy of an existing report and is quite helpful if you need a new report which is very similar to an existing report. To copy an existing report click on the edit report icon for the report that you want to copy. Then in the main report builder page rename the report and then select the category that you would like the report to appear under and then click the copy button.

Restore Default Reports

This feature allows you to restore the default reports to their original settings. Restoring a report will overwrite any existing report with the same name.

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox