Project and Portfolio Management Practitioners Forum
cancel

how to create a report in PPM 7.5 that runs the .xls format file

SOLVED
Go to solution
Highlighted
ak5250
Regular Contributor.

how to create a report in PPM 7.5 that runs the .xls format file

I am using HP PPM 7.5. I know that when we create a report, it usually display the html file in the browser. I am having an issue where I need to create a report which will display the results in an excelsheet. I tried by defining the extension in sql script to .xls rather than .html. However when the report completes, it shows the error that the html file cannot be downloaded.
2 REPLIES
swaroop.nani
Respected Contributor.
Solution

Re: how to create a report in PPM 7.5 that runs the .xls format file

Hi,

Don't remove .html extension.
Add the following toi your sql file

define xls_extension = '.xls';

set verify off
spool &report_dir&report_name&html_extension;
select '<script>window.location.href="&report_name'||'.xls"</script>' from dual;
spool off;
swaroop.nani
Respected Contributor.

Re: how to create a report in PPM 7.5 that runs the .xls format file

Attached file might help you.