[null, {"document_url": "https://support.boyum-it.com/hc/en-us/articles/232267808-Guide-sending-reports-to-specific-sales-employees", "unformatted_src": "/hc/article_attachments/115023840768/blobid0.png", "src": "https://support.boyum-it.com/hc/article_attachments/115023840768/blobid0.png", "formatted_filename": "blobid"}, null, {"document_url": "https://support.boyum-it.com/hc/en-us/articles/232267808-Guide-sending-reports-to-specific-sales-employees", "unformatted_src": "/hc/article_attachments/115023772547/blobid1.png", "src": "https://support.boyum-it.com/hc/article_attachments/115023772547/blobid1.png", "formatted_filename": "blobid"}, null, {"document_url": "https://support.boyum-it.com/hc/en-us/articles/232267808-Guide-sending-reports-to-specific-sales-employees", "unformatted_src": "/hc/article_attachments/115023772567/blobid2.png", "src": "https://support.boyum-it.com/hc/article_attachments/115023772567/blobid2.png", "formatted_filename": "blobid"}, null, {"document_url": "https://support.boyum-it.com/hc/en-us/articles/232267808-Guide-sending-reports-to-specific-sales-employees", "unformatted_src": "/hc/article_attachments/115023772587/blobid3.png", "src": "https://support.boyum-it.com/hc/article_attachments/115023772587/blobid3.png", "formatted_filename": "blobid"}, null, {"document_url": "https://support.boyum-it.com/hc/en-us/articles/232267808-Guide-sending-reports-to-specific-sales-employees", "unformatted_src": "/hc/article_attachments/115023840808/blobid4.png", "src": "https://support.boyum-it.com/hc/article_attachments/115023840808/blobid4.png", "formatted_filename": "blobid"}, null, {"document_url": "https://support.boyum-it.com/hc/en-us/articles/232267808-Guide-sending-reports-to-specific-sales-employees", "unformatted_src": "/hc/article_attachments/115023840788/blobid5.png", "src": "https://support.boyum-it.com/hc/article_attachments/115023840788/blobid5.png", "formatted_filename": "blobid"}, null]


You want to email a report to each sales rep individually, showing just data related to them, so, running a report with specific parameter value.

Mass delivery of type custom using B1P&D.

First you need to define a mass delivery configuration that selects out the SlpCode. You also need to define the DocKey in the DI and you can define any form type (in this case i have taken the formtype of the sales employee screen) as this is not going to be used: SQL: SELECT SlpCode, SlpName AS 'Employee name', Email FROM OSLP WHERE SlpCode <> -1

Next you need to define a Crystal report definition: You need to create your own report that will populate with data based on the SlpCode of the sales employee.

You need to define a report action of type email that will be used for the delivery: You can get the email address from the sales employee using the SQL:


Finally you need to define the report configuration that ties it all together: Now you can run the mass delivery and if everything is setup correctly you will get a list of sales employees: Mark the once you want to send the report to and press "OK": Now you can set it up as schedule so that it will be delivered automatically :)


