{Closed} Sort and Other

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/963109174

June 22, 2010, 01:34 PM

kfr104

{Closed} Sort and Other

Is anyone else not able to get the other function to work when using the GUI?

It displays all of the records and does not lump them into an other line. I am very confused on why this does not work. Any ideas?

Thanks,
Kerry

TABLE FILE WEBFOCUS_REPORT_SALES_BY_SUPPLIER
SUM 
     SALESCURYTD
BY HIGHEST 10 SALESCURYTD NOPRINT PLUS OTHERS AS 'OTHERS'
BY SUPPLIERID
BY SUPPLIERNAME

This message has been edited. Last edited by: kfr104,

WebFocus 7.6.4
SQL
HTML and Excel

June 22, 2010, 02:08 PM

Francis Mariani

PLUS OTHERS is a reporting language enhancement and most likely has not reached the GUI.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

June 22, 2010, 02:23 PM

kfr104

It allows the option in the GUI under the Sort function...

Thanks,
Kerry

WebFocus 7.6.4
SQL
HTML and Excel

June 22, 2010, 06:43 PM

Waz

quote:
PLUS OTHERS AS 'OTHERS'

You learn something new all the time.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 22, 2010, 07:11 PM

Tom Flynn

Because you have 2 BY columns AFTER the PLUS OTHERS row:

BY SUPPLIERID
BY SUPPLIERNAME

Take out the 2 BY's, it then works like it should...

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

June 24, 2010, 09:26 AM

kfr104

Thanks...

Kerry

WebFocus 7.6.4
SQL
HTML and Excel