Layton ServiceDesk - Troubleshooting - PDF Report Not Attached to Scheduled Report Email
When Layton ServiceDesk is installed, the install path is written to the database. If the application is moved to another server, the path may not be updated. This breaks the PDF function for scheduled reports.
Look at the URL in Layton ServiceDesk to determine your server path. By default, it's http://servername/laytonservicedesk. Replace ENTERPATHNAMEHERE below with your path, including the port number (default :80). For example, if your path is http://ithelpdeskserver/laytonservicedesk then the path to enter will be http://ithelpdeskserver:80/laytonservicedesk. You must get this right.
DECLARE @Path VARCHAR(255) SET @Path = 'ENTERPATHNAMEHERE' UPDATE admin SET sys_admin_value = @Path WHERE sys_admin_id = 'ap_serverpath'
Test a scheduled PDF report to ensure that the path is correct.
Note that the query will fail if your path is greater than 50 characters, as that is the length of the column. In this case, use the IP address, e.g. http://10.1.1.10:80/laytonservicedesk.