Schedule SSRS Report

We discovered that invoices for credit card orders are automatically created when the order ships. Because they’re system generated, they’re not emailed, so I’m trying to setup a scheduled APR print job to email them. I’m encountering a couple issues.

First: In the Breaking/Routing programming I created a condition to identify invoices for credit card orders shipped that day. I’m using a ‘condition’ because a ‘filter’ (widget) doesn’t give me the criteria I need. The issue comes when I attempt to print: I receive the error ‘No Invoices selected.’ How do I programatically run that APR rule against invoices. Related to that, how do I execute that for multiple invoices and not just a single invoice.

Second: How do I schedule this to run. I know how to schedule a BAQ report, but can’t find anything on scheduling an SSRS report.

Tim, I feel like you are going to need a data directive or BPM on invoice posted that sends the report.

Maybe someone else here can chime in.

1 Like