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.
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.
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