This is the start of the code:
<cfpresentation format="ppt" destination="f:\test\a.ppt" title="" overwrite="yes"> |
<cfpresentationslide> <html> <body background="file:///f:/temp/bg1.jpg"> <h1 style="color:YELLOW"> This is pure HTML page </h1> <h2 style="color:RED"> Sub title </h2> <ul> <li> test 1 </li> <li> test 2 </li> <li> test 3 </li> </ul> </body> </html> </cfpresentationslide> |
<cfpresentationslide> <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> <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> <!--- Bar graph, from Query of Queries ---> <cfchart format="jpg" xaxistitle="Department" yaxistitle="Salary Average"> <cfchartseries type="bar" query="DataTable" itemcolumn="Dept_Name" valuecolumn="avgSal"> <cfchartdata item="Facilities" value="35000"> </cfchartseries> </cfchart> </cfpresentationslide> |
<cfpresentationslide > <html> <body style="color:GREEN" > <h4 style="color:BLUE"> Some examples of HTML text formatting</h4> <p><b>This text is bold</b></p> <p><strong>This text is strong</strong></p> <p><big>This text is big</big></p> <p><em>This text is emphasized</em></p> <p><i>This text is italic</i></p> <p><small>This text is small</small></p> <p>This is<sub> subscript</sub> and <sup>superscript</sup></p> </body> </html> </cfpresentationslide> |
</cfpresentation> |
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhw49x8Zub9xcuA_pkPgTva9b4HIiinmINbumtRbM49XhW5k0eA3U6tmEjKFxKaD2BimUmpkhI-P8h5mgkcksU_ABgbwjIWSPBATcpzjvgnHDLxk2fDd5SnKgLLsAvMFbHekSsBRSGbR0XY/s320/Slide1.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9W36e98LHKyRjFqoQwVoy38YKisloOd860WYFLJ_7asmPewoCw262Os7dkMQO4DFs3OmC7G0sVHWYIy33u3ffbLC_DIYW293_yiMW0fixcf5SNGDEpRPZMKx4B94IOaBSRbmyAbGTTy1a/s320/Slide2.png)
The generated third slide:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMyyNqKcqNwGdzvvO_e5j4gKWlYfMAVb1JB9YJ8JAkb5yoz4EUfwj6HcFrIwdffqc9WclsP47z9k8ZqNzf5FU6PZzEfYgyhDXK8RCtaRBp4RW2lnbDJxnV1LzAu2dDLf8liTZi6lByH6gV/s320/Slide3.png)
No comments:
Post a Comment