@wgt issues

[J. Ryan Kelley]

J. Ryan Kelley wrote:

> Jeff Harrison wrote:
>
>> --- "J. Ryan Kelley"
>> <ryan.kelley at trinitytransport.com> wrote:
>>  
>>
>>> I'm in the process of writing a report with several
>>> dummy variables.  Throughout the report, i'm accumlating a dollar
>>> ammount to be displayed in the grand total section of my report with 
>>> along
>>> with a profit % calculation.  For some reason, whenever running this
>>> report, the grand total dollar ammounts are showing up as .00, so to
>>> debug I put my accumlating dummy fields in the subtotal fields as
>>> well, just to see where I was going wrong.  Oddly enough, the values
>>> of the dummy variables in the subtotal fields are fine,
>>> accumlating perfectly, for some odd reason when I get to the grand 
>>> total
>>> section of the report they show up blank.  Even more oddly, I have 
>>> another set
>>> of dummy variables that I'm accumulating throughout the report, and
>>> they display just fine.  I'm running the report w/ no automatic
>>> processing and am at a loss for where to go next, has anyone seen a 
>>> problem
>>> like this previously and managed to work around it.
>>>
>>>
>>>   
>>
>> [snip]
>>
>> Filepro's report mechanism can get in the way if you
>> try to keep track of totals manually.  I would suggest
>> that you instead use the "tot" command.
>>
>> Near the top of your code, before any of the @wbrk
>> processing just have the calculation for the values as
>> follows:
>>
>> ja(12,.2)=tot(3)    ' gross sales
>> jb(12,.2)=tot(3-4)   ' gross profit
>> end                  ' end processing
>>
>> (This would assume that field 3 would be your gross
>> sales and field 4 whould be your expenses)
>>
>> If you do it this way then ja and jb will
>> automatically have the correct values when it reaches
>> the @wbrk processing.
>>
>> Good Luck.
>>
>> Jeff Harrison
>> jeffaharrison at yahoo.com
>>
>> Author of JHExport and JHImport.  The easiest and
>> fastest way to generate code for filePro exports and imports.
>>
>>
>>        
>> __________________________________ Do you Yahoo!? Plan great trips 
>> with Yahoo! Travel: Now over 17,000 guides!
>> http://travel.yahoo.com/p-travelguide
>>
>>
>>  
>>
>
> Jeff,
>
> Thanks for the suggestion, and this seems to work great for my gross 
> sales column which is a normal field, however the gross profit column 
> is coming from a dummy field, as it requires calculating values from 
> different files, and the tot() command doesn't seem to be cooperating 
> with my dummy variables, is tot() only useable with real fields?
>
> Thanks,
>
Woops! sorry, I was trying to do the tot() before I actually populated 
the dummy variable, all is well now, thanks a million for the suggestion 
jeff

--ryan

-- 
J. Ryan Kelley
Trinity Transport, Inc.