Hi,
I convert rep file into excel using command
OUT_FILE TEXT_IO.FILE_TYPE;
begin
if :xlflag1='Y' then
OUT_FILE := TEXT_IO.FOPEN(:NUM||''||:NUM_1||''||'.CSV','A');
TEXT_IO.PUT_LINE(OUT_FILE,'PARTY NAME'||','||'ITEM NAME '||','||'LINE'||','||'TOTAL BALANCE QUANTITY '||','||'RATE '||','||'VALUE'||','||'J/W RATE'||','||'SALE VALUE');
TEXT_IO.FCLOSE(OUT_FILE);
END if;
return (TRUE);
end;
In Layout section main body - M1,
I got out put in excel but in page break last record is shown in next page which create duplicate record.
which shows in above
please give the solution to remove duplicate records
thanks