Problem with sub-total breaks on a report -

Boaz Bezborodko boaz at mirrotek.com
Tue Apr 14 11:59:57 PDT 2009


Steve Wiltsie wrote:
> Boaz,
>
> In the Automatic table, does is cl set as (12,,2,g) or (12,2,g)?
>
> Steve Wiltsie
> microCONCEPTS
>
> -----Original Message-----
> From: filepro-list-bounces+swiltsie=micro-mui.com at lists.celestial.com
> [mailto:filepro-list-bounces+swiltsie=micro-mui.com at lists.celestial.com]
> On Behalf Of Boaz Bezborodko
> Sent: Tuesday, April 14, 2009 11:45 AM
> To: Kenneth Brody
> Cc: filepro-list at lists.celestial.com
> Subject: [SPAM] - Re: Problem with sub-total breaks on a report - Found
> word(s) list error in the Text body
>
>
>
> 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.
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>   
It was (12,,2,g).  When I put cl(12,,2,g) into the Automatic table it 
worked.  When it wasn't there I had the problems listed.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090414/74ebe40b/attachment.html 


More information about the Filepro-list mailing list