Focal Point
[CLOSED] how to apply " BYDISPLAY = OFF" on for particular column

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

July 24, 2018, 07:46 AM
Developer
[CLOSED] how to apply " BYDISPLAY = OFF" on for particular column
how to apply " BYDISPLAY = OFF" on for particular column

i have a requirement like to apply on particular column
suppose "BYDISPLAY = OFF" on this column COUNTRY ,CAR "

can anyone please Help



TABLE FILE CAR
PRINT MODEL CAR DEALER_COST RETAIL_COST
BY COUNTRY
END

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8202
July 24, 2018, 07:50 AM
BabakNYC
BYDISPLAY applies to all BY fields you can't pick one. However, below is the same effect.

quote:
TABLE FILE CAR
PRINT COUNTRY MODEL CAR DEALER_COST RETAIL_COST
BY COUNTRY NOPRINT
END



WebFOCUS 8206, Unix, Windows
July 24, 2018, 10:14 AM
MartinY
Using this technic you can achieve

TABLE FILE CAR
SUM MODEL
BY COUNTRY
BY MODEL NOPRINT
PRINT COMPUTE NCAR /A20V = IF LAST CAR EQ CAR THEN '' ELSE CAR; AS 'CAR'
      DEALER_COST
      RETAIL_COST
BY COUNTRY
BY MODEL NOPRINT
BY CAR   NOPRINT
END 
-RUN



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
July 24, 2018, 11:45 AM
BabakNYC
Does this code assume CAR is in sort order in the database or will it work regardless?


WebFOCUS 8206, Unix, Windows
July 24, 2018, 12:56 PM
Doug
Any field needs to be "in the database", or DEFINEd, in order to be displayed.
July 24, 2018, 01:01 PM
BabakNYC
quote:
in sort order in the database



WebFOCUS 8206, Unix, Windows
July 24, 2018, 01:53 PM
Developer
quote:
Originally posted by BabakNYC:
quote:
in sort order in the database

When we apply to columns as BY command as BYDISPLAY =OFF Functionality has to work

But order should be same as I given first post




WebFOCUS 8202
July 24, 2018, 02:25 PM
MartinY
quote:

When we apply to columns as BY command as BYDISPLAY =OFF Functionality has to work

But order should be same as I given first post


The "SET BYDISPLAY=ON/OFF" does not change the functionality of "BY" key word, it only display (SET BYDISPLAY = ON) or hide (SET BYDISPLAY = OFF) the repeated sort value. The ordering functionality is still the same.

Not sure to understand your above point.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007