ReportID |
INT Required, ID of report to be mailed. |
ReportName |
VARCHAR Required, Name for used in subject. |
SmtpServer |
VARCHAR Required, Mail server. |
Port |
INT Required, Port for Mail Server. |
FromAddress |
VARCHAR Required, From address to be used for the email. |
ToAddress |
VARCHAR Required, List of users that will be receiving the email coma delimited. |
Sent |
BIT Required, Set to true if successfully sent email false if failed to send. |
Modified |
DATETIME Required, Set to the time when record was processed in DGS. |
P0 |
FLOAT Required, Parameter 0 or {0} in the reports. |
P1 |
FLOAT Required, Parameter 1 or {1} in the reports. |
P2 |
VARCHAR Optional, Parameter 2 or {2} in the reports. |
P3 |
VARCHAR Optional, Parameter 3 or {3} in the reports. |
P4 |
VARCHAR Optional, Parameter 4 or {4} in the reports. |
P5 |
VARCHAR Optional, Parameter 5 or {5} in the reports. |
P6 |
VARCHAR Optional, Parameter 6 or {6} in the reports. |
P7 |
VARCHAR Optional, Parameter 7 or {7} in the reports. |
P8 |
VARCHAR Optional, Parameter 8 or {8} in the reports. |
P9 |
VARCHAR Optional, Parameter 9 or {9} in the reports. |
Excel |
BIT Optional, Will send report as Excel instead of PDF. |
FileName |
VARCHAR Optional, Allows for overriding default file name of Report.pdf or Report.xls |