Very Computer

I need to write a report that is sorted by vendor name, blank order #, order
date, invoice number, and stock number.  My problems is that I do not see how
to get sub-totals on the invoice level (i.e. when it changes) as well as the
blanket order level, and a grand summary.  Report page breaks on vendor and
blanket order number.  What I want is something like this

vendor a blanket order a1
order date ... invoice a11
                 invoice amount a11
order date ... invoice a11
           ... invoice anount a12            ** this part I do see how to
                  .                          ** do. Only last invoice is
                  .                          ** printed with blanket order
                  .                          ** subtotal and they are the
               total amount for invoice a11  ** the same, i.e. group band
order date ... invoice a12                   ** prints after details and
               invoice amount a12            ** cannot be intermingled with
order date ... invoice a12                   ** detial lines as I need to
           ... invoice anount a22            ** do. What are the alternates?
                  .
                  .
               total amount for invoice a12
                  .
                  .
               total amount for blanket order a1

repeat for additional blanket orders

               grand total for all blanket orders

Of course this really a simplification of the real report.

Could you verbalize this one again (your A11, A12 confuses me slightly
as I never saw a stock number.)  Is the A11 the invoice and A12 the
stock number?

Can assume that your file is sorted, perhaps via a SQL Select, or index
on vendor name, blanket order, order date, invoice number, and stock
number?.

Do you have a group band for the vendor name, the blanket order,  the
order date, and invoice number?

For example, is the following what you are attempting?
Vendor name
    Blanket order
        order date today
            iinvoice 1
                item1 invoice 1
                item2 invoice  1
                    total invoice 1
            invoice 2
                item1 invoice 2
                    total invoice 2
     total order date
        order date tomorrow
            iinvoice 1
                item 3 invoice 1
                item 4 invoice  1
                     total invoice 1
         total order date
    total blanket order
total report

C>I need to write a report that is sorted by vendor name, blank order #,
C>order  date, invoice number, and stock number.  My problems is that I
C>do not see how  to get sub-totals on the invoice level (i.e. when it
C>blanket order changes) as well as the  level, and a grand summary.
C>blanket order Report page breaks on vendor and  number.  What I want
C>blanket order is something like this

C>vendor a blanket order a1
C>order date ... invoice a11
C>                 invoice amount a11
C>order date ... invoice a11
C>           ... invoice anount a12            ** this part I do see how
C>           to        .                          ** do. Only last
C>                  .                          ** invoice is printed
C>                  .                          ** with blanket order
C>               subtotal and they are the total amount for invoice a11
C>** the same, i.e. group band order date ... invoice a12
C>** prints after details and                invoice amount a12
C>** cannot be intermingled with order date ... invoice a12
C>           ** detial lines as I need to  ... invoice anount a22
C>           ** do. What are the alternates?        .
C>                  .
C>               total amount for invoice a12
C>                  .
C>                  .
C>               total amount for blanket order a1

C>repeat for additional blanket orders

C>               grand total for all blanket orders

C>Of course this really a simplification of the real report.

You need to use nestled grouping

Group on Vendor
then within that group group on blanket order
then on invoice

Use report variables to accumulate totals for the various grouping
levels.

You will have to setup an index tag that matches the grouping levels.                                                        

-----------------------------------------------------------------------------

This message was processed by NetXpress from Merlin Systems Inc.
-----------------------------------------------------------------------------