How to set bursting to split report by 'compnay' and deliver report employee of company severally b
Hi ExpertMy customer want to deliver report via email by setting bursting.
Expeted behaviour:
employee Company email
Smith A xxx
Tony B xxx
Report is created by company through setting 'Split by'
A.pdf
B.pdf
and deliver A.pdf to smith who is employee of A ,B.pdf to Tony who is employee of B automatically by emai.
Customer did test in his instance, but didn't get expected behaviour.
Test 1:
1. create table 'data' and 'master'
★DATA
COMPANY MONEY
------- ---------
A 10000
B 20000
★MASTER
COMPANY CD NAME MAILADDRESS
------- ------ ------ -----------------------
A 1234 smith sss@company.com
A 2345 tony ttt@company.com
B 3456 john yyy@companyu.com