[CLOSED] Including Table of data Below a graph?

Is there a way to include a table of data below a graph. I have a line graph of six numeric values across eight quarters. The user wants a table to appear below the x-axis label of the quarter.

This message has been edited. Last edited by: Kerry,

Posts: 103 | Location: ricmmond va | Registered: September 30, 2004

Francis Mariani

Expert

posted

Hide Post

I've been looking for this too, it seems a good way to display data. I would like a table below a graph with the columns lined up with the x axis.

All I can think of is to create the graph as a gif and then use the report style-sheet to embed the gif in the heading. This of course does not line up the report columns to the x axis.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

S.J. Kadish

Guru

posted

Hide Post

It's best to put the GIF in a PDF that contains the result matrix. HTML might not align correctly and there are additional steps when trying to put the .gif into an Excel.

Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL

Posts: 238 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003

Ignored post by S.J. Kadish posted

Show Post

mgrackin

Virtuoso

posted

Hide Post

I have many reports where I have done this. You need to create the graph image file separately and then include it in the heading of the following report that creates the table of data. This can be done for HTML or PDF. The reports I have created are PDFs using the SVG graphics.

To get the data columns to line up, I use the WebFOCUS style sheet commands to control the width of each column to make them line up with the chart above it.

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

Show Post

susannah

Expert

posted

Hide Post

here's what i do, Richmond. (i was born there)

-HTMLFORM BEGIN
<HTML>
<TABLE>
<TR><TD>
!IBI.FIL.MYPIC;
</TD></TR>
<TR><TD VALIGN="TOP"  style="padding-left: &PAD ">
!IBI.FIL.MYTAB;
</TD></TR>
</TABLE>
</HTML>
-HTMLFORM END

..where &PAD is some value i calculate based on needs. i'll do this in a loop and layout hundreds of sets in a matrix on a bunch of pages.

This message has been edited. Last edited by: susannah,

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Show Post

Francis Mariani

Expert

posted

Hide Post

Unfortunately, using a stylesheet to control the width of columns doesn't guarantee that the report columns will line up exactly.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Tony A

Expert

posted

Hide Post

That is true Francis, but it is the best method that I have found.

Like Mickey, I have created quite a few reports in this style, grid above and graph below or vice versa, and the method Mickey describes works in both situations and for different output formats (HTML and PDF). Warning though that it can take a while to get the exact widths you need.

If the user wants the data grid in Excel then it is likely that they want to manipulate it in "what if" scenarios so I have persuaded them not to have graphs in Excel format. After all, if they want a graph in Excel then it is only a few clicks and drags to produce one in any style, and the advantage is it's not fixed as a bar chart or pie etc. .......

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, 2004

Ignored post by Tony A posted

Show Post

secret

Platinum Member

posted

Hide Post

Thank you all very much, I will try these techniques.

Posts: 103 | Location: ricmmond va | Registered: September 30, 2004

Ignored post by secret posted

Show Post

Emily Lee

Gold member

posted

Hide Post

Hi How to save the graphic file before include it with table in PDF or HTML output format?
should we fix somthing in the following code?
( I can't find anything from online help. thanks!)

GRAPH FILE ELHOLD1
-* Created by Advanced Graph Assistant
SUM ELHOLD1.SEG01.ECAT_CMPLD_CNT
ELHOLD1.SEG01.NECAT_CMPLD_CNT
BY ELHOLD1.SEG01.RPTG_RONUM NOPRINT
BY ELHOLD1.SEG01.RGN_NAME AS 'Region'
ON GRAPH PCHOLD FORMAT PNG

WebFOCUS 8.2.01 AppStudio
HTML, PDF, Excel

Posts: 61 | Registered: March 12, 2008

Ignored post by Emily Lee posted

Show Post

Dan Satchell

Virtuoso

posted

Hide Post

First, you need to HOLD the graphic to disk, not PCHOLD it to the browser. Second, I would give it a unique name so it is easier to identify and retrieve in the subsequent TABLE FILE: ON GRAPH HOLD AS ELGRAPH FORMAT PNG.

WebFOCUS 7.7.05

Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007

Ignored post by Dan Satchell posted

Show Post

DavSmith

Platinum Member

posted

Hide Post

Here's an example screenshot:

and here's the code to produce the same:

GRAPH FILE CAR
HEADING
"Global"
SUM CAR.BODY.SALES AS '' CAR.BODY.DEALER_COST AS ''
ACROSS CAR.ORIGIN.COUNTRY AS ''
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 100
ON GRAPH SET HAXIS 500
ON GRAPH HOLD AS GRPH FORMAT HTMTABLE
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(false);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(false);
setO1MajorGridDisplay(false);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setAxisAssignment(1,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1LogScale(true);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(false);
setTextJustHoriz(getY1Title(),1);
setFontSizeAbsolute(getY1Title(),true);
setFontSize(getY1Title(),12);
setTextRotation(getY1Title(),1);
setTextWrap(getY1Title(),false);
setTextJustHoriz(getY1Label(),2);
setFontSizeAbsolute(getY1Label(),true);
setFontSize(getY1Label(),11);
setFontStyle(getY1Label(),2);
setTextRotation(getY1Label(),0);
setTextWrap(getY1Label(),false);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlaceResize(getY1Title(),0);
setPlaceRotate(getY1Title(),0);
setPlaceAlign(getY1Title(),0);
setPlaceWordWrap(getY1Title(),0);
setPlaceResize(getY1Label(),0);
setPlaceRotate(getY1Label(),0);
setPlaceAlign(getY1Label(),0);
setPlaceWordWrap(getY1Label(),0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
$
TYPE=HEADING,JUSTIFY=CENTER,$
ENDSTYLE
END
TABLE FILE CAR
SUM SALES/P9CB       AS 'Sales' OVER
    DEALER_COST/P9CB AS 'Cost'  OVER
COMPUTE DIFF/P9CB=SALES-DEALER_COST;AS Spread
ACROSS COUNTRY  AS ''
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE HOLD AS RPT FORMAT HTMTABLE
ON TABLE SET STYLE *
BORDER=LIGHT,GRID=OFF,LEFTMARGIN=.025,FONT='ARIAL',SIZE=7,$
TYPE=ACROSSVALUE,JUSTIFY=CENTER,STYLE=BOLD,$
TYPE=TITLE,STYLE=BOLD,$
TYPE=DATA,WIDTH=.67,JUSTIFY=RIGHT,$
ENDSTYLE
END
-HTMLFORM BEGIN
<HTML>
<TABLE>
<TR><TD>
!IBI.FIL.GRPH;
</TD></TR>
<TR><TD VALIGN="TOP"  style="padding-left:  ">
!IBI.FIL.RPT;
</TD></TR>
</TABLE>
</HTML>
-HTMLFORM END

In FOCUS since 1985 - WF 8.009/8.104 Win 8 Outputs: ALL of 'em! Adapters: Sql Server Teradata Oracle

Posts: 161 | Location: Dallas, TX | Registered: February 20, 2009

Ignored post by DavSmith posted

Show Post

Emily Lee

Gold member

posted

Hide Post

Dan, Dave and all Forum's members, thank you so much, I will try it.
Tips like this IBI, should include in the online help section, so all can use it without extra search.

WebFOCUS 8.2.01 AppStudio
HTML, PDF, Excel

Posts: 61 | Registered: March 12, 2008

Ignored post by Emily Lee posted

Show Post

Please Wait. Your request is being processed...