January 16, 2009, 02:16 PM
PrarieGraph Help
It's Friday and been a long week. I've taken my more complicated graph and turned into the Car File for help. If you run the following...it runs fine. If you change the PCHOLD to HOLD(for use in another report) it crashes. I know there should be a way to loop thru to hold this but it is not arriving in my brain. Help anyone?.
Thanks.
GRAPH FILE CAR
SUM SALES AS ' '
BY CAR NOPRINT
BY COUNTRY
ACROSS SEATS AS ' '
ON GRAPH PCHOLD AS TRAPHFILEB FORMAT PNG
-*ON GRAPH HOLD AS TRAPHFILEB FORMAT PNG
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 1
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 850
ON GRAPH SET VAXIS 480
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHSTYLE *
ENDSTYLE
END
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
January 16, 2009, 02:25 PM
GinnyJakesIt doesn't crash for me on AIX 765.
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 16, 2009, 02:52 PM
PrarieReally? Hmmmmm
It holds a file?
Hmmmmmm
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
January 16, 2009, 03:34 PM
FrankDutchHow about format SVG?
|
Frank |
| prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
January 16, 2009, 04:09 PM
GinnyJakesThis is what you get with the way your program is currently coded:
-rw-rw-r-- 1 c758760 bi 7168 Jan 16 15:06 @0009.png
-rw-rw-r-- 1 c758760 bi 7168 Jan 16 15:06 @0007.png
-rw-rw-r-- 1 c758760 bi 10240 Jan 16 15:06 @0008.png
-rw-rw-r-- 1 c758760 bi 7168 Jan 16 15:06 @0006.png
-rw-rw-r-- 1 c758760 bi 7168 Jan 16 15:06 @0005.png
-rw-rw-r-- 1 c758760 bi 11264 Jan 16 15:06 @0003.png
-rw-rw-r-- 1 c758760 bi 9216 Jan 16 15:06 @0004.png
-rw-rw-r-- 1 c758760 bi 11264 Jan 16 15:06 @0002.png
-rw-rw-r-- 1 c758760 bi 11264 Jan 16 15:06 @0000.png
-rw-rw-r-- 1 c758760 bi 8192 Jan 16 15:06 @0001.png
This is what you get with GRMERGE ON instead of ADVANCED:
-rw-rw-r-- 1 c758760 bi 17408 Jan 16 15:08 traphfileb.png
Maybe that is your problem.
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 19, 2009, 09:08 AM
PrarieI've tried all format types. Got this from IBI
It looks like this was a bug we could only fix via an upgrade, rather than
a Hotfix. It was resolved in 764. Please upgrade to obtain the fix.
January 19, 2009, 09:49 AM
PrarieHey Ginny - I tried your suggestion and it worked! You can go home now...if you are not off for the Holiday anyway.
January 19, 2009, 09:53 AM
GinnyJakesI'm here! Happy to have been of service.
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 19, 2009, 11:33 AM
PrarieWell i sent you home too soon...while it did prevent the thing from crashing...I lost my legend. Experimenting some more.