Multiple levels of sub-totals in a report

Multiple levels of sub-totals in a report

Post by Claude_Goldm » Thu, 05 Jun 1997 04:00:00



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.

 
 
 

Multiple levels of sub-totals in a report

Post by Patrick Finucan » Mon, 09 Jun 1997 04:00:00


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


> 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.


 
 
 

Multiple levels of sub-totals in a report

Post by Brian Copela » Tue, 10 Jun 1997 04:00:00


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.
-----------------------------------------------------------------------------

 
 
 

1. How can I extract sub-total from a sub-report into the main report

Crystal Reports 6 and SQL (Macola)

I have a main report pulling information from a database.

In it I have inserted a sub-report and in it have a
sub-total of a group of numbers.  I want to pull the
sub-total out and insert into a formula in the main report.

I have tried linking it and a few other things that didn't
work.  I'm stuck and don't know what to try.  The Crystal
book is vague on sub reports, they're easy to insert but no
info on pulling data out of one.

Can anyone give me a suggestion or direct me where I can
find out how to retrieve the sub-total?

2. ADOX and ADO problem?

3. Replication randomly stops - something to do with deadlocks

4. Need Help! Sub-totals within Sub-Totals

5. Using Utl_File

6. Crystal Reports/SQL 2000 - Reporting from a Stored Procedure with multiple selects (for a sub-report)

7. Hiding Total in Sub levels

8. Set skip to can't use subtotals and totals in reports Fpw2.6

9. Count() : sub-totals and grand total ?

10. canceling through multiple levels of sub procedures in VB

11. multiple sub-summary reports