Focal Point
Webfocus 7.6.4 Graph Issue

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

January 10, 2008, 06:36 AM
<ludo>
Webfocus 7.6.4 Graph Issue
Hi everybody,

First of all i'd like to wish to the community a happy new year.

I'm migrating to Webfocus 7.6.4 and I have an issue with the color of my frame.
Indeed when I set the coolor of my frame it still stay to blue when I run the report (even I see the choosen color in the avance graph assistant window).

Here is the code I'm trying to test

  
GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM CNT.CAR.BODY.BODYTYPE
BY LOWEST CAR.CARREC.MODEL
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(0);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
setPlace(true);
setFillColor(getFrame(),new Color(153,99,93));
ENDSTYLE
END


Any ideas ?
January 10, 2008, 08:21 AM
Tony A
Hi Dr Nick,

Ludo,

I have just run the code you gave and I do not see a blue frame (I guess you mean the fill colour - setFillColor(getFrame(),new Color(153,99,93)); ?)

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 10, 2008, 08:32 AM
<ludo>
Who is Dr Nick ?

Yes the fillcolor doesn't work on my system. Previously I installed a 7.1.6 and everything works correctly.

No I installed the new version but it doesn't work. Perharps I forget to set a webfocus client settings but I can't find wich one.
January 10, 2008, 08:39 AM
FortuneCookie
I'm not sure I understand either, but the following displays ALL Blue for me

GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM CNT.CAR.BODY.BODYTYPE
BY LOWEST CAR.CARREC.MODEL
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setPlace(true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setFillColor(getChartBackground(),new Color(0,0,255));
setFillColor(getFrameSide(),new Color(0,0,255));
setFillColor(getFrameBottom(),new Color(0,0,255));
setFillColor(getFrame(),new Color(0,0,255));
ENDSTYLE
END
January 10, 2008, 08:57 AM
<ludo>
I assume it 's the same issue I have ....
January 10, 2008, 09:15 AM
FortuneCookie
Not necessarily, in my stylesheet, everything is coded to return BLUE 0,0,255

With your's it's coded for I guess light brown 153,99,93

You can substitute my earlier example with
setFillColor(getChartBackground(),new Color(153,99,93));
setFillColor(getFrameSide(),new Color(153,99,93));
setFillColor(getFrameBottom(),new Color(153,99,93));
setFillColor(getFrame(),new Color(153,99,93));

and it fills it properly


Prod: WebFOCUS 7.1.6, Windows 2003

Dev: WebFOCUS 7.6.2, Windows 2003
January 10, 2008, 09:31 AM
<ludo>
Alright ,

I put all the settings you gave me and unfortunately I still have a blue frame not a brown one ...

Frowner
January 10, 2008, 09:50 AM
Tony A
Ludo,

Dr Nick is a Simpson's character that always arrives in the scene with the greeting "Hello Everybody".

Back to your question though, when I run your code - without change - on 7.6.2 it gives the brown fill colour as per fillcolor parameter. It looks as though we're running virtually the same configuration as well - win 2003/7.62/IIS/Tomcat with XP end user machines. The only difference is that you are using VmWare.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 10, 2008, 09:55 AM
FortuneCookie
I no longer have 7.6.1 available. The code did work for me in 7.6.2 and 7.6.4.


Prod: WebFOCUS 7.1.6, Windows 2003

Dev: WebFOCUS 7.6.2, Windows 2003
January 10, 2008, 09:59 AM
GinnyJakes
I get brown and I'm on 762 and Unix. I changed the graph because I couldn't see any data on Ludo's graph. Is this the emperor and his clothes?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
January 10, 2008, 10:08 AM
<ludo>
Hello Everybody
:-)

I don't know this character ...

The other difference is that I run my test on a 7.6.4 version. Previously I also run it on a 7.6.2 and I believe that the code's running correctly.

DrNick
January 10, 2008, 10:41 AM
Tony A
Ginny, once I ran the code the first time I changed it to CNT.MODEL BY COUNTRY just to get the line off the top row but only to make sure that wasn't the blue to which Ludo was "alluding"

Dr Nick (aka Ludo),

Perhaps that's a reason not to go to 7.6.4 Wink

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 10, 2008, 11:04 AM
<ludo>
Thx Tomm Flynn,

but I think the the fillcolor function doesn't work on my 7.6.4 environnement and I don't know why. I think that I missed a settings during the installation process but I don't know wich one.

Thx for all
January 11, 2008, 12:32 PM
Trav
Just tried your original and it produced a brownish box. Ran it on 7.6.4 on VMWare W2k3 Server



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
January 14, 2008, 04:07 AM
<ludo>
Hello everybody,

Trav I don't understand what you propose me to do ?
could you explain a little bit more. I tried my original code and the code I posted on a 7.1.6 version and it works fine

Dr Nick
January 14, 2008, 04:54 AM
Tony A
Ludo,

My understanding of what Trav has posted is that he has tried your original code on 7.6.4 using a 2K3 server on VMWare. Basically your configuration. His result was as you expected.

He doesn't want you to do anything, he is just confirming that your code worked using his set-up which is basically the same as yours?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 14, 2008, 04:59 AM
<ludo>
Ok ok sorry guys ...

So Trav could you give your WF client settings (Graph section) , the jre you use or anything else that I probably missed and can explain the problem I have

Ludo