Report Setup

The following reports need to be manually deployed and have their locations set:

Resource Schedule

The Resource Schedule report included with Schedule needs to moved, deployed, and have the location path set for each user's computer that will be accessing Schedule.

Copy to local SSRS location

1. Go to Schedule's installation location and then Schedule > WebServiceFiles > SSRS Reports.
2. Copy Resource Schedule.rdl. You can either right-click on the file name and then choose Copy or you can highlight the file name, choose Edit and then choose Copy.
3. Paste the Resource Schedule.rdl file in the Signature Service reports location. Microsoft Dynamics\GPxxxx\Signature\SRS Reports\Signature Service

Deploy the report

1. Launch Microsoft Dynamics GP and then go to Microsoft Dynamics GP > Tools > Setup > Service Management > Module Setup > Service Options.
2. Under Reporting at the bottom of the window, choose Run Wizard and then choose Continue.
3. Choose Next.
4. Complete the server information and choose Next.
5. Choose the System Database and then choose Next.
6. Verify the information and choose Next.
7. In the next window, unmark all checked boxes.
8. Expand Signature Service. by choosing the +.
9. Mark the checkbox next to Resource Schedule and choose Deploy.
10. After the report has deployed, you are returned to the Report Wizard window. Choose Cancel to close the window.Repeat this for any additional company databases.

Set location path

1. Launch and connect to the SQL Server.
2. Use the following SQL statement to update the Resource Report ReportLocation,  replacing Report URL with your actual report URL.
   
   UPDATE WSRepts SET ReportLocation = 'Report URL' WHERE ReportReference = 'Schedule_Resource_Report_1'

Job Schedule by Cost Code

The Job Schedule by Cost Code report is included with Signature 2018 R4. This report needs to be deployed and have the location path set for each user's computer that will be accessing Schedule.

Deploy the report

1. Launch Microsoft Dynamics GP and then go to Microsoft Dynamics GP > Tools > Setup > Service Management > Module Setup > Service Options.
2. Under Reporting at the bottom of the window, choose Run Wizard and then choose Continue.
3. Choose Next.
4. Complete the server information and choose Next.
5. Choose the System Database and then choose Next.
6. Verify the information and choose Next.
7. In the next window, unmark all checked boxes.
8. Expand Job Cost. by choosing the +.
9. Mark the checkbox next to Job Schedule by Cost Code and choose Deploy.
10. After the report has deployed, you are returned to the Report Wizard window. Choose Cancel to close the window.Repeat this for any additional company databases.

Set location path

1. Launch and connect to the SQL Server.
2. Run the following SQL statement to update the Job Schedule by Cost Code ReportLocation, replacing Report URL with your actual report URL.
   
   UPDATE WSRepts SET ReportLocation = 'Report URL' WHERE ReportReference = 'Job Schedule by Cost Code'