Report Table Format

Column Description
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