Highlighted
RahatGauri Absent Member.
Absent Member.
617 views

How to Implement JSP Report

Jump to solution

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

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Absent Member.. Vineet Shiva Ku Absent Member..
Absent Member..

Re: How to Implement JSP Report

Jump to solution

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)

View solution in original post

1 Reply
Absent Member.. Vineet Shiva Ku Absent Member..
Absent Member..

Re: How to Implement JSP Report

Jump to solution

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)

View solution in original post

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.