Focal Point
[CLOSED] OVER

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7917028495

December 05, 2010, 05:50 AM
subbu
[CLOSED] OVER
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
December 05, 2010, 06:34 AM
RivoU
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
December 06, 2010, 04:18 PM
T.Peters
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