Focal Point
[CLOSED] COMPUTE after ACROSS NOPRINT in 7.7.02

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

January 30, 2012, 03:14 PM
BobV
[CLOSED] COMPUTE after ACROSS NOPRINT in 7.7.02
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?



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
January 31, 2012, 09:39 AM
BobV
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 Frowner

Have you opened a case with IBI? this definitely has the characteristics of a bug.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
January 31, 2012, 10:16 AM
BobV
Oh sorry. I thought you said it worked in 7.7.03

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,



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.