cfchart embedded inside cfdocument
Example to show the usage of cfchart embedded inside cfdocument.
Description: Embed a cfchart inside a cfdocument. Note: In case of cfcharts, if you want to embed a cfchart inside a cfdocument, you can use the following formats for cfchart. 1. jpg 2. png Currently, format="flash" is NOT supported.
You should have the datasource cfdocexamples(this comes by default with the installation)
<!---The following example analyzes the salary data in the cfdocexamples
database and generates a bar chart showing average salary by department. The
body of the cfchartseries tag includes one cfchartdata tag to include data that
is not available from the query. --->
<cfdocument format="pdf">
<!--- Get the raw data from the database. --->
<cfquery name="GetSalaries" datasource="cfdocexamples">
SELECT Departmt.Dept_Name,
Employee.Dept_ID,
Employee.Salary
FROM Departmt, Employee
WHERE Departmt.Dept_ID = Employee.Dept_ID
</cfquery>
<!--- Use a query of queries to generate a new query with statistical data for each department.
AVG and SUM calculate statistics. GROUP BY generates results for each department. --->
<cfquery dbtype="query" name="DataTable">
SELECT
Dept_Name,
AVG(Salary) AS avgSal,
SUM(Salary) AS sumSal
FROM GetSalaries
GROUP BY Dept_Name
</cfquery>
<!--- Reformat the generated numbers to show only thousands. --->
<cfloop index = "i" from = "1" to = "#DataTable.RecordCount#">
<cfset DataTable.sumSal[i] = Round(DataTable.sumSal[i]/1000)*1000>
<cfset DataTable.avgSal[i] = Round(DataTable.avgSal[i]/1000)*1000>
</cfloop>
<h1>Employee Salary Analysis</h1>
<!--- Bar graph, from Query of Queries --->
<cfchart format="jpg" xaxistitle="Department" yaxistitle="Salary Average">
<cfchartseries type="cone" query="DataTable" itemcolumn="Dept_Name" valuecolumn="avgSal">
<cfchartdata item="Facilities" value="35000">
</cfchartseries>
</cfchart>
</cfdocument>
database and generates a bar chart showing average salary by department. The
body of the cfchartseries tag includes one cfchartdata tag to include data that
is not available from the query. --->
<cfdocument format="pdf">
<!--- Get the raw data from the database. --->
<cfquery name="GetSalaries" datasource="cfdocexamples">
SELECT Departmt.Dept_Name,
Employee.Dept_ID,
Employee.Salary
FROM Departmt, Employee
WHERE Departmt.Dept_ID = Employee.Dept_ID
</cfquery>
<!--- Use a query of queries to generate a new query with statistical data for each department.
AVG and SUM calculate statistics. GROUP BY generates results for each department. --->
<cfquery dbtype="query" name="DataTable">
SELECT
Dept_Name,
AVG(Salary) AS avgSal,
SUM(Salary) AS sumSal
FROM GetSalaries
GROUP BY Dept_Name
</cfquery>
<!--- Reformat the generated numbers to show only thousands. --->
<cfloop index = "i" from = "1" to = "#DataTable.RecordCount#">
<cfset DataTable.sumSal[i] = Round(DataTable.sumSal[i]/1000)*1000>
<cfset DataTable.avgSal[i] = Round(DataTable.avgSal[i]/1000)*1000>
</cfloop>
<h1>Employee Salary Analysis</h1>
<!--- Bar graph, from Query of Queries --->
<cfchart format="jpg" xaxistitle="Department" yaxistitle="Salary Average">
<cfchartseries type="cone" query="DataTable" itemcolumn="Dept_Name" valuecolumn="avgSal">
<cfchartdata item="Facilities" value="35000">
</cfchartseries>
</cfchart>
</cfdocument>
You can download the example code using the download link.
Comments
[Add Comment]
http://www.soft-r-us.com/forum/forum_posts.asp?TID...
# Posted By wetywe
| 10/10/08 12:46 AM
http://www.soft-r-us.com/forum/forum_posts.asp?TID...
# Posted By qwer2
| 10/10/08 12:49 AM
http://www.soft-r-us.com/forum/forum_posts.asp?TID...
# Posted By wer523
| 10/10/08 12:52 AM
http://www.soft-r-us.com/forum/forum_posts.asp?TID...
# Posted By wetwett
| 10/10/08 12:54 AM
http://www.soft-r-us.com/forum/forum_posts.asp?TID...
# Posted By wewet34535
| 10/10/08 12:57 AM
[Add Comment]
