@wgt issues

Jeff Harrison jeffaharrison at yahoo.com
Mon Apr 18 06:20:42 PDT 2005


--- "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


More information about the Filepro-list mailing list