How to Implement JSP Report (259 Views)
Reply
Occasional Contributor
RahatGauri
Posts: 4
Registered: ‎03-26-2013
Message 1 of 2 (259 Views)
Accepted Solution

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

Advisor
Vineet Shiva Kumar
Posts: 10
Registered: ‎12-31-2008
Message 2 of 2 (183 Views)

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)

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.