Create Report

Dear all,

Something like this never made the report using the report developer 6i

Name initial stock of goods additional unit
Reduction
Stock end
Unit
Supplier customer qty qty

Table fruit olympic 10 12 33 20 adidas comp fruit
Fertile jaya 20 pt five xy

I've created with the group above, to view the results as follows:

Name initial stock of goods stock reduction unit of the addition of the end unit
Supplier customer qty qty

Table olympic 20 23 10 fruit fruit
20 23 glorious fertile fruit
Adidas comp 12 23 fruit
Pt xy 5 23 fruit
Pt fruit yy 10 23

The problem, I would like to stock the end there is only one row
Just like the previous view.

If there are colleagues who have samples or know how to create a report
Like this.

Please help and enlightenment.

 

If the display's desideratum, I more prefer pakek who report LEFT group.
Querynya also be addressed first.
Both sides of the addition / suppliers and the reduction / customer, must be made in a single query to be side by side.
If two different tables, can be attributed to his pakek ROWNUM.
In order to perform the final stock of just one line for each group could try the way
This (slightly tricky):
1. Add one column in the report queries that use analytic function ROW_NUM () that are partitioned based on the group.
2. a. Add the stock column FORMAT TRIGGER at the end, refer to the value row_num (), if not equal to one, hide the object (return false)
OR
b. Value at end of column-retrieve stock through a formula column and not directly in the report query, if row_num () that is not the same row one, return 0 or NULL.