Project and Portfolio Management Practitioners Forum

How to Implement JSP Report

Go to solution
New Member.

How to Implement JSP Report

Hi All,


As of now we are running manual SQL queries in toad to generate the reports for deployment management.

I want to automate this with the help of JSP report.


Can someone tell me how to create the JSP reports fpr deployment management.



Vineet Shiva Ku
Trusted Contributor.

Re: How to Implement JSP Report

Try creating HTML/XLS reports by creating an SQL script which spools the SQL results to an HTML/XLS file..


- Create a custom report type in PPM (refer to any other existing HTML/XLS reports)

- Using the commands, connect to oracle and execute a SQL script that would be placed on the server

- You can optionally call a procedure from the SQL script to have greater flexibility over display features


Hope this helps in getting started..!



++ Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”

++ Remember to give Kudos to answers..! (click the KUDOS star)