Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Display a GRAPH as report page header

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Display a GRAPH as report page header
 Login/Join
 
johney
Gold member
posted
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
 
Posts: 83 | Registered: October 19, 2007Report This Post
Tony A
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
johney
Gold member
posted Hide Post
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
 
Posts: 83 | Registered: October 19, 2007Report This Post
Tony A
Expert
posted Hide Post
... 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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Darin Lee
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Darin Lee
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Darin Lee
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
<shislandguy>
posted
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
 
Report This Post
<shislandguy>
posted
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
 
Report This Post
johney
Gold member
posted Hide Post
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
 
Posts: 83 | Registered: October 19, 2007Report This Post
Darin Lee
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Darin Lee
Virtuoso
posted Hide Post
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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Display a GRAPH as report page header

Copyright © 1996-2020 Information Builders