Sums for two groupings

[dlee]

I have a report that is based on an sql statement that returns all
records for a given date and where the Shipped field (a number field)
is > 0.

The sql statement returns the fields VPN, PPN, DESC, LotNumber, and
Shipped.

I want to sort the report by VPN then PPN. A VPM may have several
differnet PPN's as well as multiples listing of the same PPN. What I
need to do is sum all of field Shipped for all of the same PPN's for a
given VPN.

Thanks,
Thomas

 

[Marshall Barton]

I have a report that is based on an sql statement that returns all
records for a given date and where the Shipped field (a number field)
is > 0.

The sql statement returns the fields VPN, PPN, DESC, LotNumber, and
Shipped.

I want to sort the report by VPN then PPN. A VPM may have several
differnet PPN's as well as multiples listing of the same PPN. What I
need to do is sum all of field Shipped for all of the same PPN's for a
given VPN.

Sounds like all you want is to use Sorting and Grouping
(View menu) in the report. Select the VPN field for the top
level grouping and PPN for the second group. Select Yes for
Group Footer for both groups. Then you can add a text box
with an expression like =Sum(Shipped) to either or both
group footers sections.

 

[dlee]

Sounds like all you want is to use Sorting and Grouping
(View menu) in the report. Select the VPN field for the top
level grouping and PPN for the second group. Select Yes for
Group Footer for both groups. Then you can add a text box
with an expression like =Sum(Shipped) to either or both
group footers sections.

Well, I had tried that before but at your suggestion I tried it one
more time and got it to work. Thanks!!!