Problem with sub-total breaks on a report
Boaz Bezborodko
boaz at mirrotek.com
Tue Apr 14 09:44:58 PDT 2009
Kenneth Brody wrote:
> Boaz Bezborodko wrote:
> [...]
>> I use a global variable 'cl(12,,2,g)' that gets set to zero for each
>> new sales rep. In the customer sub-totals I add the commission amount
>> to cl. When I step through the debugger cl is correct on the customer
>> sub-total, but when I look at it on the sales rep sub-total break the
>> amount is not the same and I can't figure out where it came from.
>
> Can you give us an actual example?
>
> [...]
>> In @wbrk2 I have
>> ? If:
>> Then: ch(10,,2)=cg*ca/"100" ; cl=cl+ch
>> The very first line of code checks if it is on a new sales rep and,
>> if so, sets cl(12,,2,g)=""
>>
>> What am I missing?
>
> You have an error on line 42.
>
> http://www.google.com/search?q=wikipedia+"error+on+line+42"
>
When going through the data before hitting any of the breaks cl="".
Once the first break point is hit it should equal '0' until given the
value of ch which in my sample data is "62.32". But it only shows this
when in the @wbrk routine. Once it starts going through the data lines
again cl shows up as '/d0'. When it gets to @wbrk2 again it shows as
"62.32" until a new ch gets added, in this case a value of '248.73' and
'cl' then correctly shows a value of '311.05'. At that point it hits
@wbrk3 and the value shows '396.49' for no particular reason that I can
find. There is no '396.49' anywhere in the data set I'm working with.
I did find that I could get 'cl' to hold the right data if I put it in
AUTO processing. But I'm trying to find out what FP is doing otherwise.
More information about the Filepro-list
mailing list