Hi All,

I need to check the values record by record..... that means i have to take the first id in the first row and check with 2nd to end row whether any other id available with the same ID....... if found then i need to check the current row date with the matched row date.... if the current row date is less than matched date then i want to display "This row not required" .... actually i wan t to write this code in a seperate variable and place that variable in the report......... Presently i am using the below code and it is not working

stringvar x;
stringvar y;
numbervar i;
numbervar j;
FOR I:= 1 TO COUNT(ID) STEP 1 DO
(
x:=ID
y=DATE
FOR J= 1 TO COUNT(ID) STEP 1 DO
(
IF X=ID AND Y<DATE THEN
"NOT REQUIRED"
EXIT FOR;
);
);
when i am placing this variable in report it is just displaying TRUE IN ALL THE ROWS..... what is the correct code to get the required or not required information.....?? I am using CR 2008......

Hi lockwelle,