Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]How do I get rid of the empty cells between the across columns?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved]How do I get rid of the empty cells between the across columns?
 Login/Join
 
Hua
Guru
posted
It may be very obvious to most of you, but I couldn't figure out a way to get rid of empty cells when using ACROSS, values are scattered all over.
And why WF assumes we don't need the column title when there is only one across column?

TABLE FILE CAR
PRINT
     CAR
BY COUNTRY
ACROSS SEATS
END

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


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
Change PRINT to SUM.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Darin Lee
Virtuoso
posted Hide Post
Change to SUM


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Piipster
Guru
posted Hide Post
Generally, if you are only using one verb object a heading on your report would describe what the data is so you don't need the column title.

If you do want the column title to appear you can trick it by using:

SUM CAR/A16

This puts a second column of car in the internal table so the column title will print.


ttfn, kp


Access to most releases from R52x, on multiple platforms.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
Hua
Guru
posted Hide Post
Thanks every one for replying.

quote:
Change PRINT to SUM.

This looses my detail information. And it is wrong information if SUMming a alpha value:
TABLE FILE CAR
SUM 
     CAR
BY SEATS
ACROSS COUNTRY
END


This only show me TRIUMPH is a 2-seated car in ENGLAND, and JAGUAR is missing when I SUM instead of PRINT.


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
Then what you need to do is COUNT something to go into the cells.

Maybe you could give us more information on what you are actually trying to do.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Hua
Guru
posted Hide Post
	COUNTRY				
	ENGLAND	FRANCE	ITALY	JAPAN	W GERMANY
SEATS					
2	JAGUAR		ALFA ROMEO		
	TRIUMPH		ALFA ROMEO		
			MASERATI


I simply want to list the cars by seats for each country across. I am trying to avoid the Italian cars listed 2 lines below English cars.
A more practical example is I want to see what products the salesmen sold over the 12-month period. The PRINT verb gives the diagonal views of the products for each salesman, and SUM gives the last product sold by the salesmen.


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
FrankDutch
Virtuoso
posted Hide Post
Hua

you need to add a list sequence and then you get what you want.

TABLE FILE SALES
LIST
PRODUCTS 
BY SALESMAN
ON TABLE HOLD
END
TABLE FILE HOLD
SUM PRODUCTS
BY LIST NOPRINT
ACROSS SALESMAN
END


The list command ad an sequence number 1 to xx
now you are listing all the products per salesman.
You also could Rank the products (and the number of sold items) and then print the products ranked by highest number.
The Rank is a more functional sequence.

TABLE FILE SALES
SUM SALES
BY SALESMAN
BY PRODUCTS
RANKED BY HIGHEST SALES 
ON TABLE HOLD
END
TABLE FILE HOLD
SUM PRODUCTS SALES
BY RANK NOPRINT
ACROSS SALESMAN
END




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Hua
Guru
posted Hide Post
Frank,

Thank you and everybody for your sugguestions. I have to put this aside for now as I got dragged to other matters.

Hua


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
Hua
Guru
posted Hide Post
Hi Frank,

I tried your suggestion and it works!
Thanks.

Hua


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]How do I get rid of the empty cells between the across columns?

Copyright © 1996-2020 Information Builders