Printing Planning Worksheet reports

First available in TMW Operations: V14.40

You can set up the system to allow specific SSRS reports to be printed from the Planning Worksheet. The setup includes:

Creating the SSRS report
Recording options in several INI settings in your TTS50

You can generate two different SSRS reports for a selected trip. By default, the commands used to print the reports are named Print Load Sheet and Print Delivery Receipt on the View menu. However, you specify which SSRS report is associated with each of these commands.

The SSRS reports you print must use the mov_number field as a parameter for the specified trip. No other parameters are available for the report.

The system automatically prints the reports to the default printer set up for your machine.

Setting up Planning Worksheet report printing

In order to print SSRS reports from the Planning Worksheet, your SSRS reports must use only the mov_number field as a parameter, and you must have a connection with the report server. You link the reports using specific TTS50 settings.

Set up these settings in your TTS50 as follows:

Section Setting Value

Section	Setting	Value
`[.NetOperations]`	`LoadSheetPrinting`	`Y`
`DeliveryReceiptPrinting`	`Y`
`[Misc]`	`ReportingService2010`	Your company’s SSRS ReportService webservice address Example: https://localhost/ReportServer/ReportService2010.asmx
`ReportExecutionService`	Your company’s SSRS ReportExecution service address Example: https://localhost/ReportServer/ReportExecution2005.asmx
`LoadSheetReport`	The location of the SSRS report linked to the Print Load Sheet command Example: `/SSRS DOCUMENTS/SSRS_TEST_LOAD`
`DeliveryReport`	The location of the SSRS report linked to the Print Delivery Receipt command Example: `/SSRS Documents/SSRS_TEST_DR`

[.NetOperations]

LoadSheetPrinting

Y

DeliveryReceiptPrinting

Y

[Misc]

ReportingService2010

Your company’s SSRS ReportService webservice address

Example: https://localhost/ReportServer/ReportService2010.asmx

ReportExecutionService

Your company’s SSRS ReportExecution service address

Example: https://localhost/ReportServer/ReportExecution2005.asmx

LoadSheetReport

The location of the SSRS report linked to the Print Load Sheet command

Example: /SSRS DOCUMENTS/SSRS_TEST_LOAD

DeliveryReport

The location of the SSRS report linked to the Print Delivery Receipt command

Example: /SSRS Documents/SSRS_TEST_DR

Using the SSRS report printing feature

After you set up the report printing feature, you can print the specified SSRS reports from the Planning Worksheet. Follow these steps:

In the Planning Worksheet, select the desired trip on the Available Trips grid.
Select one of the following:
- View > Print Load Sheet
  Prints the SSRS report associated with this command
- View > Print Delivery Receipt
  Prints the SSRS report associated with this command
The SSRS report is sent directly to the machine’s default printer and a confirmation message is displayed.
Click OK to clear the message.

By default, the print commands on the View menu are named Print Load Sheet and Print Delivery Receipt. However, you can rename the commands to match the selected SSRS reports. For more information see, Changing the name of a menu or command.