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] "BYDISPLAY" Option for ACROSS Columns?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] "BYDISPLAY" Option for ACROSS Columns?
 Login/Join
 
Deborah Sullivan
Gold member
posted
Hello,

I have done some amount of searching, but have not seen a solution to this one.

We have a user who is using an ACROSS column and would like to see data values that repeat, much the way a BY field would repeat when you set BYDISPLAY=ON.

So, in other words, for this code:

SET BYDISPLAY=ON
TABLE FILE CAR
SUM
SALES
BY COUNTRY AS ''
BY CAR AS ''
ACROSS COUNTRY AS ''
ACROSS MODEL AS '' ACROSS-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT EXL2K
END

They would like to see the value for COUNTRY repeated over each value of MODEL within that country. I suggested creating a DEFINE field that combines COUNTRY and MODEL (with a carriage return between the two), but they need the fields to be seperate.

If it matters, they are using WF 7.6.6 on an AIX platform.

Thanks for any suggestions!

-Debbie / Fidelity

This message has been edited. Last edited by: Kerry,
 
Posts: 52 | Location: Merrimack, NH | Registered: August 17, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
TABLE FILE CAR
SUM
SALES
BY CAR AS ''
ACROSS COUNTRY NOPRINT
ACROSS MODEL NOPRINT 
ACROSS-TOTAL AS 'TOTAL'
ACROSS COUNTRY AS ''
ACROSS MODEL AS '' 

ON TABLE PCHOLD FORMAT EXL2K
END


One problem with this is for some strange reason the column-title for the across-total does not display...


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
j.gross
Virtuoso
posted Hide Post
Here's a way to make the COUNTRY column-heading values repeat -- but you lose the Total header for the subtotal columns:
SET BYDISPLAY=ON

TABLE FILE CAR
SUM
SALES
BY COUNTRY AS ''
BY CAR AS ''

ACROSS COUNTRY NOPRINT
ACROSS MODEL NOPRINT ACROSS-TOTAL AS 'Total'

ACROSS COUNTRY AS ''
ACROSS MODEL AS ''

ON TABLE PCHOLD FORMAT EXL2K
END

The first two levels of ACROSS are NOPRINT-ed; no row is allocated for them in the spreadsheet. They serve to make each value in the third ACROSS (the ACROSS COUNTRY that prints) a sort-break value, since every column is a sort-break at the level of the second ACROSS; so every cell in the printed ACROSS COUNTRY row gets populated.

But the ACROSS-TOTAL, to compute correctly, has to be attached to the upper ACROSS MODEL, which is not printed -- so the Total legend has no row in which to print.


- Jack Gross
WF through 8.1.05
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
j.gross
Virtuoso
posted Hide Post
FM scooped me -- but meanwhile I had time to answer his "Why".
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Debbie,

I think this should do the trick:
  
-* File Debbie1.fex
DEFINE FILE CAR
CS/A15=COUNTRY | EDIT(SEATS);
END
TABLE FILE CAR
SUM
SALES
BY CAR AS ''
ACROSS CS NOPRINT 
ACROSS COUNTRY AS ''
ACROSS SEATS AS ''
-*ON TABLE PCHOLD FORMAT EXL2K
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, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
Jack, beat you to it by four minutes! But thank you for the explanation!


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Deborah Sullivan
Gold member
posted Hide Post
Wow, thanks so much for such a quick response. I didn't think of NOPRINT as an option. I'll send this off to my user and see if this does the trick for them.

Thanks again!
 
Posts: 52 | Location: Merrimack, NH | Registered: August 17, 2006Report This Post
Deborah Sullivan
Gold member
posted Hide Post
I just wanted to update the thread to let you know that this ended up working for my user. They seem to be very happy with the results, so I thank everyone for their insights.

-Debbie / Fidelity
 
Posts: 52 | Location: Merrimack, NH | Registered: August 17, 2006Report 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] "BYDISPLAY" Option for ACROSS Columns?

Copyright © 1996-2020 Information Builders