@wgt issues
J. Ryan Kelley
ryan.kelley at trinitytransport.com
Mon Apr 18 06:52:05 PDT 2005
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,
--
J. Ryan Kelley
Trinity Transport, Inc.
More information about the Filepro-list
mailing list