Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Gold member
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
Output: Excel,PDF
Posts: 78 | Registered: January 07, 2008Reply With QuoteReport This Post
posted Hide Post
Take a look at Suppressing the Display of a TAG Row


iSM 6.0
iDM 7.6.5 - 7702
WF 7.6.4 - 7702

All output formats
Posts: 23 | Location: Tallinn, Estonia | Registered: July 31, 2009Reply With QuoteReport This Post
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

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, 2009Reply With QuoteReport This Post
  Powered by Social Strata  

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.