missing records when downloaded into excel

[Shahid]

Hello All

there is a prob when downloading the report into excel file. when the report is displayed it shows me 445 records. when i downloaded the same thing using file>>save>spreadsheet..it displays me only 412 records. and then i realized that it didnt downloaded the records of few particular dates. next time when i gave the selection screen of those dates , the records have been downloaded.

and then i used gui_download function to download the file, then the same thing happened.

so i changed the filetype to 'ASC' , then it is downloading all the records but the data is not divided into column wise.

i even chk the internal table it has 445 records...

can anyone comeup with a suggestion ??

FORM download.

CALL FUNCTION 'WS_DOWNLOAD'

EXPORTING

filename = p_file

filetype = 'DAT'

TABLES

data_tab = t_download

• FIELDNAMES =

EXCEPTIONS

file_open_error = 1

file_write_error = 2

invalid_filesize = 3

invalid_type = 4

no_batch = 5

unknown_error = 6

invalid_table_width = 7

gui_refuse_filetransfer = 8

customer_error = 9

OTHERS = 10

.

Message was edited by:

shahid mohammed syed

[Shahid]

hI

WS_EXCEL IS THE FM TO DOWNLOAD TO EXCEL

WS_DOWNLOAD IS FOR CSV AND TEXT FILES.

THANKS

REWARD IF HELPFUL

VIVEKANAND

[Former Member]

Hi Shahid,

Is your report output an ALV?

If yes.....Check your field catalog.

Regards,

Ravi

[Shahid]

ITS NOT AN ALV REPORT...ITS AN CLASSICAL REPORT

[Former Member]

hI

WS_EXCEL IS THE FM TO DOWNLOAD TO EXCEL

WS_DOWNLOAD IS FOR CSV AND TEXT FILES.

THANKS

REWARD IF HELPFUL

VIVEKANAND