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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] OVER
 Login/Join
 
subbu
Gold member
posted
Hi all,

When we use OVER to show or bing the records as rows is it possible to hide some of the rows.
like below

  

  CAR          PCT   DEALER_COST    
==================================
  BMW          10    6000
  TOYOTA       20    2000
  MERCIDES     30    3000
  SUZIKI       40    1000
  XENAPP       60    3000


Note that the value for DEALER_COST of tthe MERICIDES row is the division of R1/R2 in other words value sof BMW/TOYOTA and my output should not have SUZIKI row at all

  

  CAR          PCT   DEALER_COST    
==================================
  BMW          10    6000
  TOYOTA       20    2000
  MERCIDES     30    3000
  XENAPP       60    3000


I have used OVER to show the CAR values as a single column and its corresponing calculations like R1/R2

How to hide rows when we use FOR and OVER keywords to make a tabular report.

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


WebFOCUS 7.6.10
Windows
Output: Excel,PDF
 
Posts: 78 | Registered: January 07, 2008Report This Post
RivoU
Member
posted Hide Post
Take a look at Suppressing the Display of a TAG Row

Rivo


iSM 6.0
iDM 7.6.5 - 7702
WF 7.6.4 - 7702

All output formats
 
Posts: 23 | Location: Tallinn, Estonia | Registered: July 31, 2009Report This Post
T.Peters
Platinum Member
posted Hide Post
Is there any criteria that makes you want to supress Suziki or do you know you always want to eliminate that one specifically? If the latter, then Rivo's link will work.

If not, here's an idea:
1. Create DEFINE field that says something like:
IF testVal1 eq criteria1
THEN DEALER_COST
ELSE 0

2. Put your new DEFINE field in the place of where you currently have DEALER_COST and put a WHERE criteria on the report that says WHERE DEFINE > 0

3. In the MATRIX tab, right click your row and check the "WHEN EXISTS" check box on the top of the page.


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders