Report problem

tobarich

Hi all:
I have a report for Sales Tax. This report searches in table VAT Entry and summarizes the data by a given Tax Jurisdiction Code.
For some reason I had to create new Tax jurisdictions codes. Example: before my change only exist code NM-BE and now I have created NM-BE1, NM-BE2... These codes represent the same Jurisdiction but they have some differences, that is way I put 1,2...
When I run the report there is a problem with the result:
Tax Jurisdition Code | Description | Amount
NM-BE Bernalillo 50
NM-BE1 Bernalillo 20
NM-BE2 Bernalillo 30

I need that report generates only one line:
Tax Jurisdition Code | Description | Amount
NM-BE Bernalillo 100

The report that I'm using calls Sales Tax Collected, maybe someone knows it and tell me what to do.

Thanks

Savatage

how about a variable called AllTax
Createtotals(AllTax);

on after get record
AllTax := Amount;

display alltax in the footer :-k

Just throwing it out there