Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to get the array result ( Please Help Urgently)

Status
Not open for further replies.

zshukralla

Programmer
Joined
Aug 11, 2005
Messages
2
Location
BH
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top