Focal Point
Display a GRAPH as report page header
April 10, 2008, 06:15 AM
johneyDisplay a GRAPH as report page header
Hi ,
Is there any way to add a graph in a report's page header (Format HTML) so that the graph will repeat in every page.
Thanks and regards,
Johney Joseph
Version 7.6.11
Webfocus installed in AIX 5.3,
desktop PC: Windows-XP based
Output: Excel, HTML, PDF
April 10, 2008, 07:09 AM
Tony AYou would need to store it as an image file in a location relative to the output format you want. For HTML you need it on the client server so that you reference it via a URL. Make the reference in style sheet commands - check documentation for details.
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 | |
April 11, 2008, 03:39 AM
johneyHi,
Actualy I need different graphs in each page. I need to have a page break on every BY clause on a column called BUSINESS_UNIT and the graph's X and Y axis are BUSINESS_UNIT and SALARY respectively. I tried to implement the graph code in the ON SUBHEAD clause of the TABLE FILE request, but it did not work.
Thanks and regards,
Johney Joseph.
Version 7.6.11
Webfocus installed in AIX 5.3,
desktop PC: Windows-XP based
Output: Excel, HTML, PDF
April 11, 2008, 12:35 PM
Tony A... so for each new page in your HTML output you will require a different TABLE request ...
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 | |
April 11, 2008, 01:28 PM
Darin LeeYou have multiple graphs being created with a BY. You want each graph to appear on a report page that is associated with the sort values for that report.
Sounds to me like your best bet would be to use a coordinated compound PDF report. That gets you the graph and report associated with the same BY value on the same page. You can make it appear as part of the heading or just as part of the body depending on how you set up the report. No savings graphs, referencing URLs, etc., etc. Use the PDF report layout to create one graph request with a BY, one report request with a BY, coordintate the report and you've got what you need.
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
April 11, 2008, 01:30 PM
Darin LeeLooking back at your request, I missed the part about format HTML. Is that a requirement? You went on about pages and page headings which don't really exist very nicely in the HTML world so I started down the PDF track where a page is a page.
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
April 11, 2008, 03:55 PM
GinnyJakesThe PDF Layout Painter can produce HTML output, Excel too. The product is misnamed.
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
April 11, 2008, 05:35 PM
Darin LeeI was aware that it could be used for other outputs, but when you place a graph at (position 5.0 1.0), that works for PDF but how does it appear in an HTML page?
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
April 11, 2008, 05:40 PM
GinnyJakesGood question!
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
April 13, 2008, 02:41 PM
<shislandguy>wouldn't something like this work for HTML?
DEFINE FILE CAR
IMG1/A100 WITH CAR = '
';
IMG2/A100 WITH CAR = '
';
END
TABLE FILE CAR
SUM COMPUTE
IMG/A100 = IF COUNTRY EQ 'JAPAN' OR 'ENGLAND' THEN IMG1
ELSE IMG2;
NOPRINT
BY COUNTRY PAGE-BREAK
ON COUNTRY SUBHEAD
"
END
April 13, 2008, 02:45 PM
<shislandguy>okay, so I didn't realize that the .gif files would get posted- the original DEFINE looks like this-
IMG1/A100 WITH CAR = '
';
IMG2 would be gif_two- you get the idea
April 14, 2008, 03:29 AM
johneyHi Darin,
To create a compound PDF report what tool we need to have in the developer studio? I searched for PDF Layout Painter with in Dev studio 7.16 but did not find . Is it a free downloadable software ?
Thanks and regards,
Johney Joseph.
Version 7.6.11
Webfocus installed in AIX 5.3,
desktop PC: Windows-XP based
Output: Excel, HTML, PDF
April 14, 2008, 10:37 AM
Darin LeeIt's all in Dev Studio. When you create a new report, in the "Create With" dropdown box, select PDF Layout Painter.
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
April 14, 2008, 10:45 AM
Darin Leeshislandguy,
You need to disable HTML when you post anything with HTML code. That allows the code to be seen instead of trying to render the HTML.
We have used code like your example for including images - so it does work, but the issue Johney is running into is that the images are WF graphs that need to be *dynamically* created and added to appropriate pages of the report based on some sort values in the report.
So it would really take the long way around to get what he needs using this example.
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat