[SOLVED] Squishing Multiple rows into 1 then they share a column in common

I'm having trouble finding information on how to effectively "squish" or simply get rid of displaying multiple return results.

For example if I'm writing a report to display the names and total number of people who own Hondas and Sally Sample has 2, I don't want to show her name 2x on the report. I just want a name to show one time in the report regardless of how many Hondas she owns and corresponding rows which are in the database.

Thanks so much for your help.
Appreciated,
Shawna

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

WebFOCUS 7.6.7
WIN XP
Excel, PDF, HTML

Posts: 25 | Registered: October 05, 2011

David Briars

Master

posted

Hide Post

Sound like you want to switch from a detail report to a summary report.

If so, switch your use TABLE verbs accordingly.

Detail Report: PRINT or LIST TABLE commands.

Summary Report: SUM or COUNT TABLE commands.

Dave

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster

Posts: 822 | Registered: April 23, 2003

Ignored post by David Briars posted

Show Post

Waz

Expert

posted

Hide Post

Or, use ACROSS if you need the car info.

TABLE FILE ...
SUM VAUE
BY NAME
ACROSS CAR
END

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!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Show Post

Danny-SRL

Virtuoso

posted

Hide Post

Hi Shawna,
What do you mean by:

quote:
... and corresponding rows which are in the database

Using the CAR file, one could say:
Show all CARs having SEDAN and display their number. You could do something like this:

-* File Shawna01.feX
TABLE FILE CAR
SUM
COMPUTE NN/I3=NN + 1; NOPRINT
BY CAR
WHERE BODYTYPE EQ 'SEDAN';
ON TABLE SUBFOOT
"Number of Cars having SEDAN: <NN "
END

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Show Post

Shawna

Member

posted

Hide Post

thanks so much guys!!