Fusion Bursting Examples: PRINT Delivery

Variation 1: Print Employee Payslips

SELECT Employee_ID AS "KEY",
       'PayslipReport.rtf' TEMPLATE,
       'en-US' LOCALE,
       'PDF' OUTPUT_FORMAT,
       Employee_Name OUTPUT_NAME,
       'PRINT' DEL_CHANNEL,
       'PRINTER_GROUP' PARAMETER1,                  -- Printer group
       'PRINTER_URI' PARAMETER2,                     -- Printer name or URI
       1 PARAMETER3,                                 -- Number of copies
       'd_single_sided' PARAMETER4,                  -- Sides (single-sided, double-sided long/short edge)
       't1' PARAMETER5,                              -- Tray
       '1-5' PARAMETER6                               -- Print range
FROM Employees;