Hiding rows in grid/Scroll Area for specific conditions

Local Rowset &rs;

Local Number &i,&k;
&rs=getlevel0()(1).getrowset(Scroll.YourRecordName);

&i=1; 

&k=0;

&rs.showAllRows();
while (&i+&k) <=&rs.activerowcount

/* Suppose below condition is to hide that particular row*/

if &rs(&i).YourRecordName.FieldName.value="Whatever" Then 

&rs(&i).visible=false;

&k=&k+1;

else

&i=&i+1;

end-if;

end-while;