General information
Category:
Reports & Report designer
>Hi Guys,
>
>This might be a stupid question, but I am pretty much poofed out.
>I have two tables: an Invoice Header table (invh) and its Detail table (invd).
>Supposing these are the contents:
>
>INVH.dbf
>InvNo Date Tax Amount
>001 5/11 100.00 1000.00 - has 2 child recs
>002 5/13 125.00 1250.00 - has 1 child rec
>003 5/25 80.00 800.00 - has 3 child recs
>004 5/26 50.00 500.00 - has 1 child rec
>
>INVD.dbf
>InvNo Prodcode Qty Price
>001 A1 Some value...
>001 B2 Some value...
>002 B1 Some value...
>003 B1 Some value...
>003 C3 Some value...
>003 C4 Some value...
>004 A5 Some value...
>
>- I then created a report form to list all the invoices and the respective details.
>- The report is grouped by InvNo
>- INVH is related into INVD via InvNo (obviously)
>- SET SKIP TO InvD is also enforced (which means each header will be in effect for every matching detail record)
>
>Question: How do I get the total TAX value using a report variable? In the example above it should amount to 355.00. Since I use SET SKIP, the total I get is wrong since the tax value is added for every matching child record.
>
>Thanks and God bless.
>
>Dennis
you could use the variable to sum up the children amounts
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only