Totals for Hide Duplicates

[Jim]

I have a report which summarizes shipments and shows the
values for the order. Some orders have more than one
shipment. I use hide duplicates so that the order value
will only show once for any given order no matter how
many shipments there are per order. That works great.

My problem is trying to total up the total order value in
the report footer, I have a text box in the footer with
=Sum(OrderValue), but it includes all of the order values
whether displayed or not. How do I show the value for
only the visible order values?

Example
Order Shipment Order Value Ship Date
1 First Items 5,000 1/2/04
1 Second Items (hidden) 2/2/04
2 First Item 7,000 3/3/04
2 Second Item (hidden) 4/4/04
2 Third Item (hidden) 5/5/04

Total 31,000

I would like the 31,000 to be 12,000

Thanks,

Jim

 

[Marshall Barton]

I have a report which summarizes shipments and shows the
values for the order. Some orders have more than one
shipment. I use hide duplicates so that the order value
will only show once for any given order no matter how
many shipments there are per order. That works great.

My problem is trying to total up the total order value in
the report footer, I have a text box in the footer with
=Sum(OrderValue), but it includes all of the order values
whether displayed or not. How do I show the value for
only the visible order values?

Example
Order Shipment Order Value Ship Date
1 First Items 5,000 1/2/04
1 Second Items (hidden) 2/2/04
2 First Item 7,000 3/3/04
2 Second Item (hidden) 4/4/04
2 Third Item (hidden) 5/5/04

Total 31,000

I would like the 31,000 to be 12,000

The Hide Duplicates has nothing to do with this issue, the
problem is that you have the same data on multiple records
(details).

The standard way to do this kind of total is to use Sorting
and Grouping (View menu) to create a group with header or
footer. Set the group's Field to the Order Number field.
Then you can place a text box in the header/footer bound to
the Order Value field and set its RunningSum property to
Over All to calculate the total.

The Report footer can then display the total by just
refering to the above text box.

 

[Guest]

How can I do i f I need subtotal groups?
I have two level groups, in the second level I have a value.
In the 1st level footer I need a total for that value. If I use a simple sum, the field calculate that sum with all details !!!

pmfcop00 Texto35 FAIMP FCFECO PAGADO
87611 10000183 280.00
20030425 204.88
20030425 75.12
560.00 Suma De PAGADO2: 280.00
87619 251 53.00
20030506 13.00
20030506 8.00
20030506 8.00
20030506 8.00
20030506 8.00
20030506 8.00
318.00 Suma De PAGADO2: 53.00
87620 6768 50.00
20030425 50.00
87642 211 25.00
20030417 15.00
87642 212 25.00
20030422 15.00
87642 214 25.00
20030424 15.00
87642 215 25.00
20030429 15.00
87642 2080 25.00
20030424 20.00
87642 2083 60.00
20030507 13.00
20030507 20.00
245.00 Suma De PAGADO2: 113.00


Please, could you help me?

 

[Guest]

Thank you Thank you, I could solve it with the Marshall idea