Reports

You can schedule reports to be sent from JAMS Jobs or JAMS Integration Pack applications. Use the Schedule tab on a Job to create several types of reports. The Execution Method that these Jobs are based on will create the related reports. The Reports Schedule Items (Send a Report) will send the report to the appropriate place.

Send a Report as an Email

You can use JAMS to create and send a report as an email. Use the JAMS Reports Execution Method to create a Job that creates a Report. You can then add the Schedule Item below to have the report sent as an email.

Depending on the type of mail server you are using, ensure an SMTP or a Graph API Connection Store item has been configured. See Connections to Mail Servers for more information.

  1. Click Definitions from the Shortcuts menu.
  2. Right-click a Job and select Properties.
  3. Click the Schedule tab.
  4. Click the + button.
  5. Select Send a report | as an e-mail.
  6. In the Mail Server field, select the Connection Store item for the mail server.
  7. In the To Address field, enter the email address where the email will be sent.
  8. In the Subject field, add a subject line for the email.
  9. In the Message Body field, click in the field to add the email message and click OK.
  10. Click Finish. The Report is listed under the Send a report section on the Schedule tab.
  11. Click Save and Close.

Email Report Properties

Status Description
Enabled Select or clear the checkbox to enable or disable the report from being generated.
E-Mail Description
Mail Server This property specifies the server to check for e-mail. Use the drop-down menu to select a Mail Server Connection from the Connection Store.
To Address This property specifies one or more email addresses that the email will be sent to. You can enter a comma-separated list of e-mail addresses.
Subject This property specifies the subject of the e-mail.
Message Body This property specifies the body of the e-mail message. You can enter Markdown language in the message body.
Cc Address This property specifies one more email address that the email will be sent to. You can enter a comma-separated list of e-mail addresses.

Send a Report as a JD Edwards Report

  1. Click Definitions from the Shortcuts menu.
  2. Right-click a Job and select Properties.
  3. Click the Schedule tab.
  4. Click the + button.
  5. Select Send a report | as a JDE Report.
  6. In the Printer Name field, enter the name of the printer to be used.
  7. In the Copies field, enter the number of copies to be printed.
  8. Click Finish. The Report is listed under the Send a report section on the Schedule tab.
  9. Click Save and Close.

JD Edwards Report Properties

Status Description
Enabled Select or clear the checkbox to enable or disable the report from being generated.
Execute Description
Conversion Filter This property specifies the name of the conversion filter that should be applied to the report before it is sent to the printer.
Printer Name This property specifies the name of the printer to use.
Copies This property specifies the number of copies to be printed.

Send a Report as a Microsoft Dynamics Email Report

You can use JAMS to create and send a report as a Microsoft Dynamics email report. Use the MSDAX2012Job Execution Method to create a Job that creates a Report. You can then add the Schedule Item below to have the report sent as an email.

  1. Click Definitions from the Shortcuts menu.
  2. Right-click a Job and select Properties.
  3. Click the Schedule tab.
  4. Click the + button.
  5. Select Send a report | as an MS Dynamics Email.
  6. In the Start Page field, enter the first page of the report.
  7. In the End Page field, enter the last page of the report.
  8. In the To Address field, enter the email address where the email will be sent.
  9. In the Subject field, add a subject line for the email.
  10. Click Finish. The Report is listed under the Send a report section on the Schedule tab.
  11. Click Save and Close.

Microsoft Dynamics Email Report Properties

Status Description
Enabled Select or clear the checkbox to enable or disable the report from being emailed.
Execute Description
Start Page This property specifies the first page of the report.
End Page This property specifies the last page of the report.
E-Mail Description
To Address This property specifies one or more email addresses that the email will be sent to. You can enter a comma-separated list of e-mail addresses.
Subject This property specifies the subject of the e-mail.
Cc Address This property specifies one more email address that the email will be sent to. You can enter a comma-separated list of e-mail addresses.

Send a Report as a Microsoft Dynamics File Report

You can use JAMS to create and send a report as a Microsoft Dynamics File report. Use the MSDAX2012Job Execution Method to create a Job that creates a Report. You can then add the Schedule Item below to have the report sent as a file report.

  1. Click Definitions from the Shortcuts menu.
  2. Right-click a Job and select Properties.
  3. Click the Schedule tab.
  4. Click the + button.
  5. Select Send a report | as an MS Dynamics File Report.
  6. In the File Format field, enter the extension of the file.
  7. In the Start Page field, enter the starting page of the file that will be sent.
  8. In the End Page field, enter the ending page of the file that will be sent.
  9. Click Finish. The Report is listed under the Send a report section on the Schedule tab.
  10. Click Save and Close.

Microsoft Dynamics File Report Properties

Status Description
Enabled Select or clear the checkbox to enable or disable the report from being emailed.
Execute Description
File Format This property specifies the file extension of the file.
Start Page This property specifies the starting page of the report.
End Page This property specifies the ending page of the report.
File Watch Description
File Name This property specifies the name of the file that will be saved.

Send a Report as a Microsoft Dynamics Print Report

You can use JAMS to create and send a report as a Microsoft Dynamics File Print report. Use the JAMS MSDAX2012Job Execution Method to create a Job that creates a Report. You can then add the Schedule Item below to have the report sent to a printer.

  1. Click Definitions from the Shortcuts menu.
  2. Right-click a Job and select Properties.
  3. Click the Schedule tab.
  4. Click the + button.
  5. Select Send a report | as an MS Dynamics Print Report.
  6. In the Printer Name field, enter the name of the printer that will be used.
  7. In the Copies field, enter the number of copies that will be printed.
  8. In the Start Page field, enter the starting page of the file that will be sent.
  9. In the End Page field, enter the ending page of the file that will be sent.
  10. Click Finish. The Report is listed under the Send a report section on the Schedule tab.
  11. Click Save and Close.

Microsoft Dynamics Print Report Properties

Status Description
Enabled Select or clear the checkbox to enable or disable the report from being saved as a file.
Execute Description
Printer Name This property specifies the name of the printer to use.
Copies This property specifies the number of copies to be printed.
Start Page This property specifies the first page of the report.
End Page This property specifies the last page of the report.

Send a Report as an SSRS Print Report

You can use JAMS to create and send a report as an SSRS report. Use the SSRS Execution Method to create a Job that creates a Report. You can then add the Schedule Item below to have the report sent to a printer.

  1. Click Definitions from the Shortcuts menu.
  2. Right-click a Job and select Properties.
  3. Click the Schedule tab.
  4. Click the + button.
  5. Select Send a report | as an SSRS Print Report.
  6. In the Printer field, enter the name of the printer that will be used.
  7. In the Start Page field, enter the first page of the report that will be printed.
  8. In the End Page field, enter the last page of the report that will be printed.
  9. Click Finish. The Report is listed under the Send a report section on the Schedule tab.
  10. Click Save and Close.

SSRS Print Report Properties

Status Description
Enabled Select or clear the checkbox to enable or disable the report from being printed.
Execute Description
Printer Name This property specifies the name of the printer used.
Start Page This property specifies the first page of the report.
End Page This property specifies the last page of the report.
Page Width This property specifies the width of the printed page.
Page Height This property specifies the height of the printed page.
Print DPI X This property specifies the horizontal resolution of the printout in dots per inch.
Print DPI Y This property specifies the vertical resolution of the printout in dots per inch.