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

Help on custom report

Highlighted
Ryan Grobler
Regular Collector

Help on custom report

HI All

I am wanting to edit an existing out the box report - Project Cost Details.

The report is the only OTB report which gives non-labor actuals, but is limited in search functionality.

I would like to add an additional filter to this report.

Anyone had any experience in this - My sql skills are next to non existant, which probably doesn't help much, but wanted to know how easy/difficult something like this would be?

Thanks!
7 REPLIES
Ryan Grobler
Regular Collector

Re: Help on custom report

Sorry - wrong report, I want to amend the Project Cost Breakdown report and add a new filter.
Mahen M
Honored Contributor

Re: Help on custom report

Do you want the new report as Custom Report?

Regards,
Mahendran M
Ryan Grobler
Regular Collector

Re: Help on custom report

Whichever is easiest!

If I can amend the current one then we'll use that, if it means creating a custom report then I'll go with that.

We haven't created our own reports before - so not sure what the right process is.
Mahen M
Honored Contributor

Re: Help on custom report

I am not sure whether we can modify the OOTB Reports.

If you want to get the Query which is getting fired, please enable JDBC Logging.

Procedure : In Workbench
Edit -> Debug Settings

Check on the check box 'Enable JDBC Logging'

After that run the OOTB Report. As soon as you run the report, uncheck 'Enable JDBC Logging'.

After that see the Log for the query which got fired.

You can take that Query and you can do modifications to it. Perhaps you can get some help from SQL Person or you can type your requirement in the forum.

Regards,
Mahendran M
Mahen M
Honored Contributor

Re: Help on custom report

Sorry the attachments.

Regards,
Mahendran M
Prabha N
Super Collector

Re: Help on custom report

It would be good, if you take a copy of the OOTB report and use it.

Here, another option to get the code:
The jsp used for this report is ProjectCostBreakdownReport.jsp which is in
/deploy/itg.war/web/knta/drv/rpt
(Refer the path in Workbench ->Project Cost Breakdown report type ->Commands tab)
Mahen M
Honored Contributor

Re: Help on custom report

Yep, Thanks Buddy.

The attachment has the Query (Open with wordpad.)

Not sure how to create a new custom Java Portlet from PPM Administration side.

Regards,
Mahendran M
//Add this to "OnDomLoad" event