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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] OVER
 Login/Join
 
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, 2008Reply With QuoteReport This Post
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, 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
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, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 


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