[hi.shekhu2002]

Hi,

I have created a report and have given export to excel link. When i click on export to excel an output file is generated. The issue is the output file is not of type excel file. Though when i save the output and open it with excel the o/p comes correctly in excel with correct headers and data.I have used.

I have used the below entry in the after p form for excel hyperlink where _date_from is the user parameter.

_excel_hyperlink := _report_call||'?'||_rep_userid||'&server='|| _reports_server|| '&report='||_report_physical_name||'_excel&desty pe=CACHE&desformat=DELIMITED&mimetype=applicaion/vnd.ms-excel&p_gl_user='||_GL_USER||'&p_within_report=Y '
||'&p_rep_userid='||_rep_userid||'&P_DATE_FROM=' ||_date_from;