Oracle Reports (MOSC)

MOSC Banner

Conditional Distribution

edited Nov 4, 2010 11:21PM in Oracle Reports (MOSC) 1 commentAnswered
I am trying to burst a report and conditionally send instances of the burst group to various destinations.  Is there any way to build conditional logic into the distribution?

For example:

I burst on dept_id and I have three dept_id's returned by by report (100, 110, 120). I want the following to happen.

Dept_id 100:  Should be sent to three different email addresses and print at one printer.

Dept_id 110:  Should be sent to two printers

Dept_id 120:  Not distributed.

In the distribution file below I can send three emails, but it will send them for all the instances.  I don't want dept_id 110 to have any emails sent, but the foreach will apply to all the instances of the group returned so I need the mail tags for group_id 100.  The same applies for any other destination.  I don't want to print dept_id 120 but I need a print tag to print for dept_id 110.

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