Notifications

273 views

Symptoms


Cannot print pdf resource reports. Resouce reports can only be exported as jpeg or png images.

Release


Istanbul Patch 10c

Cause


Enhacement to current functionality.

Resolution


This seems to be a limitation of our platform. That feature is not present in our platform.

The table resource_reports does not hold any data. It is empty OOB. It is only used to generate on-demand report regarding the filter applies and at the moment can only be saved via the export feature to a JPEG and PNG. 


I have attached screenshots of the tables from where the on-demand report generates its data from in this update and have mentioned them below: 
======= 
Resource management tables 
======= 

Resource management adds the following tables. 

Resource Allocation 
[resource_allocation] 

Allocations for resources. 
Resource Allocation Daily 
[resource_allocation_daily] 

On a day-to-day basis, stores the events that are created through a resource plan. Also stores user created calendar events as records. 
Resource Aggregate Daily 
[resource_aggregate_daily] 

On a day-to-day basis, stores aggregated values, such as capacity, allocated hours in a project, confirmed hours in a project, non-project time, and availability of every user. 
Resource Aggregate Weekly 
[resource_aggregate_weekly] 

On a weekly basis, stores aggregated values, such as capacity, allocated hours in a project, confirmed hours in a project, non-project time, and availability of every user. The values in the table are asynchronously updated on every insert/update/delete to the Resource Allocation Daily [resource_allocation_daily] table. 
Resource Aggregate Monthly 
[resource_aggregate_monthly] 

On a monthly basis, stores aggregated values, such as capacity, allocated hours in a project, confirmed hours in a project, non-project time, and availability of every user. The values in the table are asynchronously updated on every insert/update/delete to the Resource Allocation Daily [resource_allocation_daily] table. 
Requested Allocation 
[requested_allocation] 

Allocations for resource plans. 
Resource Event Color 
[resource_event_color] 

The colors that the application displays for each event type. 
Resource Plan 
[resource_plan] 

All resource plans. These columns were added for Helsinki: top_task, program, portfolio. 
Resource Report 
[resource_report] 

Resource reports that you can generate and save. 
Resource Report Chart 
[resource_report_chart] 

This table is not used. 
Resource Report Daily 
[resource_report_daily] 

Daily resource reports that you can generate and save. 
Resource Report Export 
[resource_report_export] 

Saves JPG and PNG exports of resource management reports. 
Resource Report Monthly 
[resource_report_monthly] 

Monthly resource reports that you can generate and save. 
Resource Role 
[resource_role] 

Stores events that are created in the calendar of a user. 
======== 

The above data was obtained from the following documentation: 

https://docs.servicenow.com/bundle/jakarta-it-business-management/page/product/project-portfolio-suite-with-financials/reference/table-installed-with-PPS-finance.html 

If you wish to create a report you would have to pull the data from the resource allocation tables mentioned above. 

Article Information

Last Updated:2018-05-29 06:33:43
Published:2018-05-29