Project and Portfolio Management Support and News Forum
Showing results for 
Search instead for 
Do you mean 

How to Implement JSP Report

SOLVED
Go to Solution
Highlighted
Occasional Contributor

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.

 

Thanks

1 ACCEPTED SOLUTIONS

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)

1 REPLIES

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)