I created a routing that I need to send 2 types of report by email. One is a certificate and the other is a work order. Both report styles are active and functionnal on their own.
Since I can’t add 2 branch to a condition (example, if true, 2 actions), and I can’t add an action after an email, I tried to generate the first report that have it’s own branch and from this widget, sent a request for the alternate report with it’s own branch.
However, the “Report BT” alternate report is not generated and no email is sent for this one, only the original Certificate report.
Is the certificate truly a report or is it a document? I’m asking because if it is a document that is attached to the record, you could easily use the send document to meet this need.
For our overseas branch, they want the pack slip sent when the shipping acknowledgement goes out. We did this in a Data directive. Not sure if that is an option here.
Hmm you may have a work around there. I will verify if I could build a directive instead that would send the reports once a pack is “Shipped” or on any other condition. Thanks for the input.
I was successful in delivering two separate emails using this routing. The Conditions used are identical and it delivered the two separate emails with distinct attachments. I hope this is what you are trying to accomplish or at least gives you path to explore.
I hoped this would work, but only the left branch will work, the other causes an error which says :
System.Data.SqlClient.SqlException: Invalid object name ‘JobHead_bee8484a238c4f54a15115c67683a605’ refering as well to the dataset ShipHeadShipDtl.
The “BT” report works independently under the same Data Definition, same break table but it won’t work generating it from the “Certificat” report/routing.
So I will look at the SSRS report for “Certificate” to see if there is something in there causing conflict.
