Avatar

Correct answer by
Level 3

You can automate the report through java script.

vars.AshokDeliveryRpt="/usr/local/neolane/nl6/var/xxxxxxxxx/export/Ashok_DS_1.xls";

      var reportName = "CustomDeliveryStatistics";

      var path = vars.AshokDeliveryRpt;

      var exportFormat = "XLS";

      isAdHoc = false;

      var _ctx = <ctx _context="selection" _selectionCount="1" _selection={campId} _schema="nms:delivery" _reportContext={reportName} />

      xtk.report.export(reportName,_ctx,exportFormat,path,isAdHoc);

Once report is generated in the export directory - you can add it as an attachment and send it everyday in a specified time.

View solution in original post