Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Highlighted
ak5250
Occasional 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
Super Collector
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
Super Collector

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

Attached file might help you.
//Add this to "OnDomLoad" event