SSRS Breaking/Routing not printing or Emailing if there is more than 1?

Kinetic ERP
,
1

Hi All,

I am trying to set the routing for customer statement. For my scenario, not all customer has an email address and therefore the Email field in Customer is blank. What I’m trying to do is send the customer statement to customers’ email address and have the one’s with blank email field to be send to a specific email address.

However, when I set in the Breaking/Routing the customer with email field is sent but the ones that are blank doesn’t get sent and I can only download it from the System Monitor. I have also tried by replacing the Email with Print but it still doesn’t work.

image
image883×403 16.3 KB

Anyone else having this issue?

2

I have the same requirement and it works without issue.
In the Condition I check for an @ in the Email field rather than looking for blank or missing.

1 Like
3

Thank you! I tried it and it works now :laughing: