I want to use a shared variable in the Record Selection formula of a sub report.
I can't use shared in the formula so I use a global.

I'm having trouble though as the global var is not set at the time when the record selection formula is evaluated ( I think ).

So, my questions are is this possible?
Where should I set the global variable value so that it can be used in the selection formula

TIA

DC

REPORT HEADER b - Suppression Code
Shared StringVar ShowMarketType;
Global StringVar gShowMarketType;
gShowMarketType := ShowMarketType;
false;

SELCTION FORMULA
Global StringVar gShowMarketType;

if gShowMarketType = 'A' then
(
    {RPT_COMMON_ORDER_CHRG.REPORT_PROCESS_ID} = {?Pm-RPT_COMMON_ORDER_HEADER.REPORT_PROCESS_ID}
    AND
    {RPT_COMMON_ORDER_CHRG.ORDER_ID} = {?Pm-RPT_COMMON_ORDER_HEADER.ORDER_ID}
)
else  //Restrict by Market Type code if not 'A'll.
(
    {RPT_COMMON_ORDER_CHRG.REPORT_PROCESS_ID} = {?Pm-RPT_COMMON_ORDER_HEADER.REPORT_PROCESS_ID}
    AND
    {RPT_COMMON_ORDER_CHRG.ORDER_ID} = {?Pm-RPT_COMMON_ORDER_HEADER.ORDER_ID}
    AND
    {RPT_COMMON_ORDER_CHRG.MARKET_TYPE_CODE} = gShowMarketType;
)


Edited by AntDC - 07 Apr 2009 at 2:15am