I have a simple graph in pdf which works outside MRE but won't when I'm in MRE.
GRAPH FILE CAR
SUM SALES BY COUNTRY
ON GRAPH HOLD AS SALESGRAPH FORMAT SVG
END
TABLE FILE CAR
SUM COUNTRY NOPRINT
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,IMAGE=SALESGRAPH,$
ENDSTYLE
END
0 NUMBER OF RECORDS IN GRAPH= 18 PLOT POINTS= 5 SVG FILE SAVED ... 0 ERROR AT OR NEAR LINE 11 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC3315) IMAGE FILE NOT FOUND: salesgraph.gif
Appreciate the help
Any ideas?This message has been edited. Last edited by: vaayu,
why don't you try use below code before GRAPH FILE CAR.
APP HOLD C758760
WebFOCUS 7.6.4, Mainframe Focus Mainframe / Z/OS,MVS Managed Reporting / Windows All formats
July 28, 2011, 01:27 PM
Amar
Or Try this as well. Hope it works.
GRAPH FILE CAR SUM SALES BY COUNTRY ON TABLE HOLD AS SALESGRAPH FORMAT GIF END -RUN
TABLE FILE CAR SUM SALES BY COUNTRY ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * TYPE=REPORT,IMAGE=SALESGRAPH,$ ENDSTYLE END
WebFOCUS 7.6.4, Mainframe Focus Mainframe / Z/OS,MVS Managed Reporting / Windows All formats
July 28, 2011, 01:33 PM
vaayu
I tried the gif and it gave a message in pdf "GIF output is not supported by the JVM in headless mode"
I am not sure how to use APP HOLD for the image. Please give me a sample. The wf client is on AIX.
July 28, 2011, 01:37 PM
vaayu
Even when I change it to PNG it still looks for .gif..
That is strange...
0 NUMBER OF RECORDS IN GRAPH= 18 PLOT POINTS= 5 PNG FILE SAVED ... 0 ERROR AT OR NEAR LINE 11 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC3315) IMAGE FILE NOT FOUND: salesgraph.gif
July 28, 2011, 02:13 PM
vaayu
Well, The users want to be able to create when they login to MRE so there isn't really a self service setup. All the development is on MRE domains.
Thanks and pls let me know
July 28, 2011, 02:15 PM
Tom Flynn
Use MRE as a portal:
Put your code in a fex on your APP PATH, i.e., BASEAPP.
Then, in your MRE fex, call the program:
-MRNOEDIT -INCLUDE baseapp/focexec_name
Graphs and Images have to be in the Other Folder in the MRE Domain; can't be done dynamically...
Hi Vaayu, Tried your code from MRE and added the .SVG extension (IMAGE=SALESGRAPH.SVG) to the saved graph file. It worked. Hope this works.
GRAPH FILE CAR
SUM SALES BY COUNTRY
ON GRAPH HOLD AS SALESGRAPH FORMAT SVG
END
TABLE FILE CAR
SUM COUNTRY NOPRINT
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,IMAGE=SALESGRAPH.SVG,$
ENDSTYLE
END
Regards, Kasi Krishnan WF 7.1.4 & WF 7.6.9: Databases - DB2, SQL Server 2000. OS: Windows & AIX