My Oracle Support Banner

WS: WW: Data Sort & Totaling and Summary Functions FAQs (Doc ID 627486.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards World World Writer - Version A7.3 cume 4 and later
Information in this document applies to any platform.

Purpose

This document contains FAQs and troubleshooting tips regarding World Writer Data Sort and Totaling (P82108) and Summary Functions (P82112).

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Question 1: Can the detail records be suppressed so that only the total lines appear on the report? 
 Question 2: Error 1899 occurs when you change a Totals Only version to output to a physical file?
 Question 3: Can the summary functions text be changed or omitted from your report?
 Question 4: How can you get a distinct number of values in a column?
 Question 5: Extra spaces print between total levels.
 Question 6: You have a World Writer report set up with one of the Summary Functions - SUM, MIN, MAX, AVG, CNT - but it is not appearing on the report. 
 Question 7: Can you set up additional text to print on the sub-total and grand total lines?
 Question 8: Is there a way to get text entered using &fieldnames to line up under the column headings?
 Question 9: Can you sort on a presumptive join field?
 Question 10: Can you sort on a calculated field?
 Question 11: Can you place a summary function on a calculated field?
 Question 12: Can you sort by a sub-totaled field?  Can you use a sub-total field in a calculation? Can you data select on the sub-total field?
 Question 13: Is there a way to count the number of summary breaks instead of the number of detail records?
 Question 14: After upgrading from to A9.4, Grand Total no longer prints on a World Writer report that has level breaks.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.