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&destype=CACHE&desfo rmat=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;
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







||'&p_rep_userid='||


Comment