Oracle Reports (MOSC)

MOSC Banner

Query groups return no rows, but I need to calculate on all groups

edited May 17, 2011 9:14AM in Oracle Reports (MOSC) 2 commentsAnswered
 I have a report where I go through the Bill of Materials and for each item,  I have a group querying the on-hand quantity, another group querying open purchase orders, another group querying what we will be making with wip jobs, and another group querying what may be allocated to be used on wip jobs.

In the last group, I also try to calculate what's onhand minus what may be allocated to wip jobs to show what's left.

I have the groups all linked by item id.

The issue I am having is that if the on-hand query returns no rows, it is "breaking" the links to the rest of the groups.  It appears then that the other

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