Sendmail with filtered report as attachment - Best practice ?

Sendmail with filtered report as attachment - Best practice ?

Salut,

I am scripting sendmail workflows with reports attached. I need those reports to be filtered. For example, a 10 subrows order would have 3 different suppliers, and I want those 3 suppliers to receive a copy of the order with only the subrows related to them.

My question is should I create a new report with filters, or should I script the filters in the sendmail workflow. What is the best practice ?

I would prefer filter in workflow since adding new reports could be endless and I would have a very long side menu on my application after awhile.

Sylvain