Global Variables

[AAVasaris]

I am developing reports for an accounting application where we track most recent posting date for a project account. The problem is easy using a "sum" variable to get the max posting date, but that only returns the most recent within the scope or query for the report (only the accounts in the report). I want to use max posting date for the COMPANY in the page header, which would require using the entire table for the sum (max) function or:____LOSCOPE/HIGHSCOPE for a UDF__Lookup to non-linked table to get max value__Parameter passing from a control table which would alread have the max value.____Any Ideas?

[kfleming]

You could create a simple report that exports the high date to a DBF and then link to this table in the final report. We use this technique quite frequently when we create reports for clients.____Kathleen__R&R Support