BAQ Email to Clients

If I have a BAQ the is a functional replacement of the Stock Status Report and I wanted to send the results filtered by company to each respective company, would I create a BAQ for each company (Please don’t say this is the answer) or is there some other beautiful solution to this problem? Hopefully there’s a filter

There’s a “CurrentCompany” constant you could try to use.

If you have APR (The Advanced Print Routing?? - the module with break/routing), you make just one BAQ, one report, and then in the Print Style, define the routing to “break” on the Company.

What the “Breaking” does is break up a single report into multiple reports based on the field choosen.

You’d want to have your BAQ include a column with the email address to send it to for that company. Then in the Break Routing, you’d set the “To:” field to use that BAQ field.

Edit

There’s a filter setting, in one (or more) of the widgets in Break/Routing that might be the better way of dynamically setting the email’s “To:” field