Focal Point
Display a GRAPH as report page header

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

April 10, 2008, 06:15 AM
johney
Display 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 A
You 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
johney
Hi,

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 Lee
You 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 Lee
Looking 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
GinnyJakes
The 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 Lee
I 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
GinnyJakes
Good 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
johney
Hi 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 Lee
It'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 Lee
shislandguy,

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