TF->
EID:8b49 05f87435
TF->On 30 Dec 94 01:19pm, TOM DARRAGH wrote to ALL:
TF-> TD> Is it possible in a report to control the display of data in one
TF-> TD> calculated field based on the data in another field. My situation is
TF->No.  The value computed as a result of a calc field in a report is simply
TF->written to the output, not stored as a variable.  You will need to create 
th
TF->variable as part of a PAL app, then complete the other calcualtions.
YES!  IF IF IF
    the test data is in a real data field, not calculated within the report.
               unless calculated in and reported on during a script run.
    You can use a script to create a variable and use that variable
     in an IIF(test,"",[SomeField]*SalesTax)...  (SalesTax a variable)
or
    without a script in the report IIF(test,"",[SomeField]*.078) ...
I use the existence of a variable to print Query Criteria at the top
of a report when the report is only a subset of the whole table.
That way the reader can tell if the report is a partial or whole report
of the table.
Now, would someone tell me how to link tables in one report so as
to make a purchase order have multiple pages not related to the report
pages?  (I want a report of 3 purchase orders of 2-3 pages each to
show the page numbers of the P.O. not the report... hmmmm?)
Shalom for now!
---
 * SLMR 2.1 * God's hand outstretched...even to a ...stubborn people...
--- QScan v1.14b / 01-0024
---------------