Focal Point
[CLOSED] Generate Graph

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

December 18, 2009, 01:33 PM
lovime85
[CLOSED] Generate Graph
Hi all...I tried using the composer layout and the Generate Graph option..but it returns me an error...
Anyone knows how can i make a graph using a report?

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


WebFOCUS 7.6, Windows
All output
December 18, 2009, 02:32 PM
GinnyJakes
Which composer are you using, HTML or Document?

What is the error you are getting?

To create a graph, you use either the Graph Assistant or the Advanced Graph Assistant.


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
December 18, 2009, 03:16 PM
Doug
What is the error that you're getting?
GRAPH instead of TABLE does the trick most of the time...




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
December 18, 2009, 03:40 PM
lovime85
I want a graph using this report..
TABLE FILE F_PATIENT_STAY_DETAIL
SUM
'CNT.F_PATIENT_STAY_DETAIL.F_PATIENT_STAY_DETAIL.PATIENT_ID'
AS 'NumberofPatientes'
BY 'J0.F_PATIENT_STAY_HEADER.DISCHARGE_DT'
BY TOTAL COMPUTE StayedDays/D12 = HDIFF(J0.F_PATIENT_STAY_HEADER.DISCHARGE_DT, J0.F_PATIENT_STAY_HEADER.ADMISSION_DT, 'DAY-OF-YEAR', 'D12'); NOPRINT
AS 'StayedDays'
BY TOTAL COMPUTE TotalDischargeDays/D12 = ( CNT.F_PATIENT_STAY_DETAIL.F_PATIENT_STAY_DETAIL.PATIENT_ID ) * StayedDays; NOPRINT
BY TOTAL COMPUTE TotalDischarges/I9 = &TOT; NOPRINT
BY TOTAL COMPUTE AvgLenghtofStay/D12.2 = TotalDischargeDays / TotalDischarges;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET STYLE *


WebFOCUS 7.6, Windows
All output
December 18, 2009, 04:17 PM
GinnyJakes
Since the report is an active report, you can do a graph directly from the AHTML output. You can select one measure and one dimension.

You can also present the existing AHTML as a graph by using the Initial Presentation as graph option on the Format tab of Report Options.

And you still didn't tell us what error you are getting.
Or you can hold the data from your report then use one of the graph assistants to create your graph.


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
December 21, 2009, 07:36 AM
David Glick
Like the others said, we need to know the exact error message you are getting to try to assist you. In doing the graph option, we take your report code and attempt to create a graph from it.


David Glick
Director WebFOCUS App Studio
and WebFOCUS Developer Studio
WebFOCUS Division
Information Builders, Inc.
Direct (917) 339-5560
Voice Mail (212) 736-6250 x3560
Fax (212) 947-5168
Email david_glick@ibi.com