BI Publisher (MOSC)

MOSC Banner

How to set bursting to split report by 'compnay' and deliver report employee of company severally b

edited Jul 9, 2018 5:01AM in BI Publisher (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center