CFGRAPH

[takethapowerback]

Hey guys! Im a newbie at this coldfusion stuff and Im trying to use the <cfgraph> to generate some reports for work but I keep getting errors. If any of you guys can help me I would greatly appreciate it. Here's the code below..


<cfquery name=&quot;getresults&quot; datasource=&quot;#db#&quot;>
SELECT tblAgent.AgentID, tblAgent.CallDate, tblProblem.ProblemTitle, tblProblem.ProblemDescription, tblProblem.ProblemTypeID, tblProblemType.ProblemType
FROM tblProblemType INNER JOIN (tblProblem INNER JOIN tblAgent ON tblProblem.ProblemID = tblAgent.ProblemID) ON tblProblemType.ProblemTypeID = tblProblem.ProblemTypeID
WHERE tblAgent.CallDate >= #CreateODBCDate(Form.StartDate)#
AND tblAgent.CallDate <= #CreateODBCDate(Form.EndDate)#
</cfquery>


<cfoutput>
<cfgraph
type=&quot;pie&quot;
query=&quot;getresults&quot;
valuecolumn=&quot;#getresults.recordcount#&quot;
itemcolumn=&quot;ProblemType&quot;
fileformat=&quot;jpg&quot;
Title=&quot;Help Desk Report&quot;
Borderwidth=&quot;1&quot;
Depth=&quot;20&quot;>
</cfgraph>
</cfoutput>

 

[powahusr]

There is a known issue with CFGRAPH in CF5, I don't know if you already did it, but you need to apply the following patch.

http://www.macromedia.com/v1/Handlers/index.cfm?ID=22280&Method=Full