Support Article
Values do not display in aggregate column the main report
SA-72837
Summary
The main report is Joined with a subreport (PB) which returns the Date and Time. The main report must display the MIN(PB.pxCreateDateTime) . However, on aggregating the column in the main report and running the report, values do not display in the aggregate column.
Error Messages
Not Applicable
Steps to Reproduce
- Create a main report.
- Create a subreport (PB).
- Join two reports in the main report.
- In the main report, aggregate pxCreateDateTime > MIN.
- Execute the report.
Root Cause
An issue in the custom application code or rules.
The pzInsKey which is used in the Join condition of the subreport is not fetched from the correct class.
Resolution
Perform the following local-change:
Configure pzInsKey value to refer from the same class by adding a page name and calling the value from the given page.
Published March 22, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.