Re: Reports : sorting different reports

From: Sudip Roy <SUDIP.ROY_at_in.bosch.com>
Date: 2000/07/24
Message-ID: <01bff55c$5c40a500$880b94ad_at_hcl.ban.india.bosch.com>#1/1

This can be done with Oracle reports ..

Write the main query joining all the three tables Invoice,Orders,Orderdetails.

Now in the data model editor you need to create groups breaking at the follwoing order

        A (invoice level)
        B(order detail)
        C(Orderdetail)

Once you do the grouping properly create the layout which will be having 3 repeating frames
in the follwoing order
R1(outermost for group A)
  R2(second one within R1 for GroupB)

      R3(innermost for group3)

Once done if you run the report it will take care of your needs and eliminate having 3 reports.

Hope this servers your advice..

Bye
Sudip

wimvermeylen_at_attglobal.net wrote in article <397B5D81.C29A5202_at_attglobal.net>...
> I am looking for a solution for the following problem:
> I have 3 Oracle reports who are related., let's say report A (Invoice)
> has n x reports B (Orders) and report B has n x reports C (Order
> details).
>
> On the moment these reports are printed separedly ans then manually
> ordered:
> ABCCCBCCBCABCCC...
> How would it be possible to have these 3 different reports printed in an
> already mutual sorted order? Does any konw how this could be
> accomplished by using Oracle Reports, or any other tool?
>
> Wim
>
>
Received on Mon Jul 24 2000 - 00:00:00 CEST