Working with Report Variables

[NeedERP]

I have a report that prints total sales by Account+Location. I am trying to add a field that will total all sales for an Account that has more than 1 location. I have setup 2 groups, Location and Account. They seem to work fine. I have also setup the Report Variable lnCount as follows:

Value to Store: lnCount+1 (Nothing)
Initial Value: 0
Reset at: Account

In the total sales field in the Account Group I have
Print When: lnCount>1.

At the moment the total sales field in the Account group is printing for all accounts even if there is only one Location. It is probably very simple, but I cannot see my error. Any assistance is appreciated.

 

[jimstarr]

Am guessing that lnCount is set up so that it gets incremented with each detail line rather than just when Location changes. I'd try printing lnCount itself on the report to see exactly what's going on.

Jim