<html>
<head>
<title>Evernote Export</title>
<basefont face="Tahoma" size="2" />
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
<meta name="exporter-version" content="Evernote Windows/269614 (zh-CN); Windows/6.1.7600;"/>
<style>
body, td {
font-family: Tahoma;
font-size: 10pt;
}
</style>
</head>
<body>
<a name="2106"/>
<div>
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>做的效果如图:</div><div><br></div><img src="FastReport 报表(饼图制作)_files/Image.png" type="image/png" style="cursor: default;cursor: default;cursor: default;cursor: default;"/><div><br></div><div><img src="FastReport 报表(饼图制作)_files/Image [1].png" type="image/png" style="cursor: default;"/></div><div><br></div><div>1.先准备数据:</div><div align="left"><font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">alter</span></font> <font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">PROCEDURE</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">[dbo]</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">.</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">[up_ordersEmployeeCQQ]</span></font><font color="#010101" face="Courier New" size="2"><span style="font-size:10pt"> </span></font></div><div align="left"><font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">as</span></font></div><div align="left"><font color="#010101" face="Courier New" size="2"><span style="font-size:10pt"> </span></font><font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">select</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">*</span></font> <font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">from</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">(</span></font></div><div align="left"><font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">select</span></font> <font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'</span></font> <font color="#FF0000" face="Times New Roman" size="2"><span style="font-size:10pt">张三</span></font><font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">Name</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'1999'</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">[Year]</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font> <font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'2'</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">[Month]</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF00FF" face="Courier New" size="2"><span style="font-size:10pt">CONVERT</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">(</span></font> <font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">int</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'1'</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">)</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">ItemsSolid</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF00FF" face="Courier New" size="2"><span style="font-size:10pt">CONVERT</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">(</span></font> <font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">int</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'1000'</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">)</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">Revenue</span></font> <font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">union</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">all</span></font></div><div align="left"><font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">select</span></font> <font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'</span></font> <font color="#FF0000" face="Times New Roman" size="2"><span style="font-size:10pt">张三</span></font><font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">Name</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'1999'</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">[Year]</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font> <font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'2'</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">[Month]</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF00FF" face="Courier New" size="2"><span style="font-size:10pt">CONVERT</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">(</span></font> <font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">int</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'11'</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">)</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">ItemsSolid</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font> <font color="#FF00FF" face="Courier New" size="2"><span style="font-size:10pt">CONVERT</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">(</span></font><font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">int</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">,</span></font><font color="#FF0000" face="Courier New" size="2"><span style="font-size:10pt">'1100'</span></font><font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">)</span></font> <font color="#008080" face="Courier New" size="2"><span style="font-size:10pt">Revenue</span></font> <font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">union</span></font> <font color="#808080" face="Courier New" size="2"><span style="font-size:10pt">all</span></font></div><div align="left"><font color="#0000FF" face="Courier New" size="2"><span style="font-size:10pt">select</span></font> <font color="#FF0000" face="Courier New" size="2"><span