> On 30 Dec 94 01:19pm, TOM DARRAGH wrote to ALL:
> 
>  TD> Is it possible in a report to control the display of data in one
>  TD> calculated field based on the data in another field. My situation
> is
> No.  The value computed as a result of a calc field in a report is
> simply written to the output, not stored as a variable.  You will need
> to create the variable as part of a PAL app, then complete the other
> calcualtions.
> Depending on the actual values being calculated, it may not be
> possible to do this as a report using the Report Generator native to
> Pdox. You might consider using PAL to create the report from scratch,
> or using a third-party add-in or add-on report writer product.
> 
> --- Via Silver Xpress V4.00P SW12473
> 
> --- RBBSMail 17.3A
TD Thanks for the answer Torre. I think I neglected to say that my 
version of Paradox is PDOXWIN 5.0. Any way I worked a little more with 
the IIF method and found out that if I don't have a value in a number 
format field the blank value is considered by PDOXWIN as a 0. I want to 
leave the field blank so that customer order "total" is not calculated. 
The reason for this is because the total of order will change after 
shipping charges are added. I hope this will save confusion that the 
customer will have when he sees that the invoice total is different than 
order total. I want the "total" field to calculate only if I enter a 
value into the order form: either a 0 or greater value. This way the 
customer will be guaranteed the cost of shipping. I hope this is clear 
to you. Thanks again for the response!!
--- RBBSMail 17.3A
---------------
** A related thread FOLLOWS this message.

FIDO MESSAGE AREA==> TOPIC: 119 PARADOX       Ref: C1ED2960 Date: 01/10/95
From: STEVE BOOTH                                           Time: 09:49am
\/To: TOM DARRAGH                                         (Read 10 times)
Subj: R: Re: Report Calculations

Tom,
   fwiw, I believe there's a setting in the Session setting that allows
you to indicate you want discrimination between blanks and zeros...
 
Regards, STeve... (Exec-PC Netmail: 1:154/280)
---------------
>>>>>>>>>>>>>>>>>>>>>> LAST Message In Thread <<<<<<<<<<<<<<<<<<<<<<

FIDO MESSAGE AREA==> TOPIC: 119 PARADOX       Ref: C1A00004 Date: 01/02/95
From: CHARLES SIMPKINSON                                    Time: 07:04pm
\/To: TIMOTHY GRANT                                       (Read 10 times)
Subj: PDOXWIN MISSING METHODS

 >     I would like to attach some code to the keyChar or
 > keyPhysical methods for a form, but these methods do not
 > appear in the built in methods list.  I went and looked at the DIVEPLAN
 > app, and they appear for some, but not all of the forms in that
 > application.  I attempted to use the Custom Method and hoped that
 > by giving the method the same name as the PDox built in that it
 > would appear as a built in, but it did not.  How do I work with the
 > methods that don't appear in the dialogue?
 >
On the menu bar try Properties->ObjectPal and then check the Advanced box to 
get all of the built in methods.
Charlie
---
---------------