[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 ENDThis 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