I'm having another issue while updating from v7.6.1 to v.7.7.02
In 7.6.1, I have reports that COMPUTE fields after an ACROSS. One of these computed fields is just a "tolerance" calculation for use in conditional styling so I NOPRINT the column. After copying the fex into the 7.7.02 environment, the NOPRINT does not work.
Has anyone run across this problem or know of a solution?
thanks BobV
2/3/2012: My development team is looking into this. Will post a solution if found.This message has been edited. Last edited by: BobV,
WF (App Studio) 8.2.01m / Windows Mainframe FOCUS 8
January 31, 2012, 08:26 AM
njsden
Same in 7.7.03M:
DEFINE FILE CAR
CONTINENT/A10 = IF COUNTRY EQ 'JAPAN' THEN 'ASIA' ELSE 'EUROPE';
END
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ACROSS CONTINENT
COMPUTE DONT_SHOW_ME/D12 = 999; NOPRINT
END
I don't think I've used that before (even in older versions) but we all know what to expect from NOPRINT, don't we?
njsden, I have the NOPRINT after the ACROSS...COMPUTE but it does not NOPRINT
Even if I use the sample code from CAR that you posted, it does not work.
Does anyone know if there is a new SET command that's needed?
I might need to add a step to hold off initial data, then do a DEFINE and COMPUTE without the ACROSS. That kind of defeats the purpose of some of the power in WF to report in as few steps as possible.
-BobV
WF (App Studio) 8.2.01m / Windows Mainframe FOCUS 8
January 31, 2012, 10:02 AM
njsden
quote:
Even if I use the sample code from CAR that you posted, it does not work.
Exactly BobV! That's what I intended to illustrate with the example. The odd behaviour you reported sadly occurs in 7.7.03M as well.
Even though we all know what NOPRINT should do, WebFOCUS is not following the expected behaviour in this case
Have you opened a case with IBI? this definitely has the characteristics of a bug.
No, I have not opened a case. But I suppose it's worth the while.
WF (App Studio) 8.2.01m / Windows Mainframe FOCUS 8
January 31, 2012, 10:36 AM
njsden
BobV,
I don't know what the rules for your "tolerance" field are but if they can be calculated at the last BY-field level (excluding the ACROSS ones) you may probably do this in a multi-verb request.
DEFINE FILE CAR
CONTINENT/A10 = IF COUNTRY EQ 'JAPAN' THEN 'ASIA' ELSE 'EUROPE';
END
TABLE FILE CAR
SUM
COMPUTE FLAG/A1 = EDIT(COUNTRY, '9'); NOPRINT
BY COUNTRY NOPRINT
SUM
DEALER_COST
BY COUNTRY
ACROSS CONTINENT
ON TABLE SET STYLE *
TYPE=DATA, BACKCOLOR=YELLOW, WHEN=C1 EQ 'E', $
TYPE=DATA, BACKCOLOR=GREEN, WHEN=C1 EQ 'J', $
ENDSTYLE
END
It still requires more than one step but at least you can avoid HOLDing and joining back to access your field for special formatting.This message has been edited. Last edited by: njsden,