zshukralla
Programmer
I have a report with 4 subreports, In one of the subreports I move the data from a table into arrays, but for some reason (I do not know) it doesnot move all the columns to the assigned arrays.
In the header I initailized the arrays as follows:
whileprintingrecords;
shared stringvar array BO_fiid_ARRAY:=["","","","","","","",""];
shared NUMBERvar array LOW_TX_ARRAY:=[0,0,0,0,0,0,0,0];
shared NUMBERvar array HIGH_TX_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array LOW_AMT_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array HIGH_AMT_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array BO_APP_NUM_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array SW_APP_NUM_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array IS_APP_NUM_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array BO_FIX_FEE_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array SW_FIX_FEE_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array IS_FIX_FEE_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array BO_APP_PRC_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array SW_APP_PRC_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array IS_APP_PRC_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array FIX_FEE_ARRAY:=[0,0,0,0,0,0,0,0];
shared numbervar counter2:=0
In the detail I move the data from a table into arrays as follows:
WHILEPRINTINGRECORDS;
evaluateafter({@COUNTER2});
shared numbervar counter2;
shared stringvar array BO_FIID_ARRAY;
shared NUMBERvar array LOW_TX_ARRAY;
shared NUMBERvar array HIGH_TX_ARRAY;
shared NUMBERvar array LOW_AMT_ARRAY;
shared NUMBERvar array HIGH_AMT_ARRAY;
shared NUMBERvar array BO_APP_NUM_ARRAY;
shared NUMBERvar array SW_APP_NUM_ARRAY;
shared NUMBERvar array IS_APP_NUM_ARRAY;
shared NUMBERvar array BO_FIX_FEE_ARRAY;
shared NUMBERvar array SW_FIX_FEE_ARRAY;
shared NUMBERvar array IS_FIX_FEE_ARRAY;
shared NUMBERvar array BO_APP_PRC_ARRAY;
shared NUMBERvar array SW_APP_PRC_ARRAY;
shared NUMBERvar array IS_APP_PRC_ARRAY;
shared NUMBERvar array FIX_FEE_ARRAY;
BO_FIID_ARRAY[counter2]:={DD_FEE.FIID};
LOW_TX_ARRAY[counter2]:={DD_FEE.LOW_TX};
HIGH_TX_ARRAY[counter2]:={DD_FEE.HIGH_TX};
LOW_AMT_ARRAY[counter2]:={DD_FEE.LOW_AMT};
HIGH_AMT_ARRAY[counter2]:={DD_FEE.HIGH_AMT};
BO_APP_PRC_ARRAY[counter2]:={DD_FEE.BO_APP_PRC};
SW_APP_PRC_ARRAY[counter2]:={DD_FEE.SW_APP_PRC};
IS_APP_PRC_ARRAY[counter2]:={DD_FEE.IS_APP_PRC};
BO_APP_NUM_ARRAY[counter2]:={DD_FEE.BO_APP_NUM};
SW_APP_NUM_ARRAY[counter2]:={DD_FEE.SW_APP_NUM};
IS_APP_NUM_ARRAY[counter2]:={DD_FEE.IS_APP_NUM};
BO_FIX_FEE_ARRAY[counter2]:={DD_FEE.BO_FIX_FEE};
SW_FIX_FEE_ARRAY[counter2]:={DD_FEE.SW_FIX_FEE};
IS_FIX_FEE_ARRAY[counter2]:={DD_FEE.IS_FIX_FEE};
FIX_FEE_ARRAY[counter2]:={DD_FEE.MINIMUM_FEE};
When I checked the arrays in another subreport I found that the data moved only to 8 arrays,( BO_APP_NUM_ARRAY and the rest are all filled zeroes )
Please I need a help.
In the header I initailized the arrays as follows:
whileprintingrecords;
shared stringvar array BO_fiid_ARRAY:=["","","","","","","",""];
shared NUMBERvar array LOW_TX_ARRAY:=[0,0,0,0,0,0,0,0];
shared NUMBERvar array HIGH_TX_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array LOW_AMT_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array HIGH_AMT_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array BO_APP_NUM_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array SW_APP_NUM_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array IS_APP_NUM_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array BO_FIX_FEE_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array SW_FIX_FEE_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array IS_FIX_FEE_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array BO_APP_PRC_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array SW_APP_PRC_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array IS_APP_PRC_ARRAY:=[0,0,0,0,0,0,0];
shared NUMBERvar array FIX_FEE_ARRAY:=[0,0,0,0,0,0,0,0];
shared numbervar counter2:=0
In the detail I move the data from a table into arrays as follows:
WHILEPRINTINGRECORDS;
evaluateafter({@COUNTER2});
shared numbervar counter2;
shared stringvar array BO_FIID_ARRAY;
shared NUMBERvar array LOW_TX_ARRAY;
shared NUMBERvar array HIGH_TX_ARRAY;
shared NUMBERvar array LOW_AMT_ARRAY;
shared NUMBERvar array HIGH_AMT_ARRAY;
shared NUMBERvar array BO_APP_NUM_ARRAY;
shared NUMBERvar array SW_APP_NUM_ARRAY;
shared NUMBERvar array IS_APP_NUM_ARRAY;
shared NUMBERvar array BO_FIX_FEE_ARRAY;
shared NUMBERvar array SW_FIX_FEE_ARRAY;
shared NUMBERvar array IS_FIX_FEE_ARRAY;
shared NUMBERvar array BO_APP_PRC_ARRAY;
shared NUMBERvar array SW_APP_PRC_ARRAY;
shared NUMBERvar array IS_APP_PRC_ARRAY;
shared NUMBERvar array FIX_FEE_ARRAY;
BO_FIID_ARRAY[counter2]:={DD_FEE.FIID};
LOW_TX_ARRAY[counter2]:={DD_FEE.LOW_TX};
HIGH_TX_ARRAY[counter2]:={DD_FEE.HIGH_TX};
LOW_AMT_ARRAY[counter2]:={DD_FEE.LOW_AMT};
HIGH_AMT_ARRAY[counter2]:={DD_FEE.HIGH_AMT};
BO_APP_PRC_ARRAY[counter2]:={DD_FEE.BO_APP_PRC};
SW_APP_PRC_ARRAY[counter2]:={DD_FEE.SW_APP_PRC};
IS_APP_PRC_ARRAY[counter2]:={DD_FEE.IS_APP_PRC};
BO_APP_NUM_ARRAY[counter2]:={DD_FEE.BO_APP_NUM};
SW_APP_NUM_ARRAY[counter2]:={DD_FEE.SW_APP_NUM};
IS_APP_NUM_ARRAY[counter2]:={DD_FEE.IS_APP_NUM};
BO_FIX_FEE_ARRAY[counter2]:={DD_FEE.BO_FIX_FEE};
SW_FIX_FEE_ARRAY[counter2]:={DD_FEE.SW_FIX_FEE};
IS_FIX_FEE_ARRAY[counter2]:={DD_FEE.IS_FIX_FEE};
FIX_FEE_ARRAY[counter2]:={DD_FEE.MINIMUM_FEE};
When I checked the arrays in another subreport I found that the data moved only to 8 arrays,( BO_APP_NUM_ARRAY and the rest are all filled zeroes )
Please I need a help.