Uploading output to excel
Hi all,
i need to give a parameter in my report in which to the specified path i need to pass my report data as an excel output format.Can u please tell me how to do this.
thanks in advance
sri
If I'm understanding you you need to pass a file format of DAT and suffiex your filename with .XLS
i will tell u clearly..in my report i need to give a parameter in which if the path and and file name is specified my report should be saved in excel output format.Can u tell me the code for this.
thanks
sri25
i will tell u clearly..in my report i need to give a parameter in which if the path and and file name is specified my report should be saved in excel output format.Can u tell me the code for this.
thanks
sri25
We need to be more courteous..... I don't want to open a can of worms for us desis here... no offense to anyone.
anyways here is the code,
parameters:
p_xl as checkbox default 'X',
p_fname(50) type c default 'c:\temp\myxlfile.XLS'.
start-of-selection.
.....
if p_xl = 'X' and p_fname <> ' '.
perform download_to_excel_file.
endif.
Hope this helps,