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     RANK command in WF 7.1.3

Read-Only Read-Only Topic
Go
Search
Notify
Tools
RANK command in WF 7.1.3
 Login/Join
 
peplawusb
Member
posted
Trying to use the RANK command in a report. When I do, it works but...the RANK column shows on the report and I want it to be invisible. I use the NOPRINT statement and it's like it just gets ignored. Anybody experience this problem or have any solutions?
 
Posts: 2 | Registered: March 13, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
If that is the case, you can either put the ranked data in a hold file and TABLEF from the hold without the rank field or you can do the ranking yourself by sorting BY HIGHEST, then doing a compute to calculate the rank. You can then test that compute with a WHERE TOTAL to limit the number of entries you see on the report.


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
Waz
Expert
posted Hide Post
If you don't need the Rank, then use BY HIGHEST only as Ginny says.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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, 2006Report This Post
Guy
Member
posted Hide Post
A person I work with made the text of the rank column the same color as the background so you couldn't see the column when you run the report.

Kind of "caveman" but it worked.


WebFOCUS 7.6.4
Windows XP against an Oracle Database mainly SCT Banner Higher Education ODS and EDW
Various output formats


Guy Brenckle
Budget Analyst
University of Northern Colorado
 
Posts: 25 | Location: Greeley Colorado | Registered: October 08, 2007Report 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     RANK command in WF 7.1.3

Copyright © 1996-2020 Information Builders