<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
fastreport 报表(饼图制作)
1星 需积分: 50 29 浏览量
2013-12-25
13:50:06
上传
评论
收藏 605KB RAR 举报 
Desktop.rar （16个子文件） 
FastReport 报表(饼图制作).html 56KB
FastReport 报表(饼图制作)_files 
Image [5].png 61KB Image [9].png 45KB Image [6].png 57KB Image [14].png 19KB Image [3].png 103KB Image [1].png 18KB Image [2].png 46KB Image [11].png 25KB Image [13].png 38KB Image [4].png 60KB Image.png 29KB Image [12].png 37KB Image [7].png 59KB Image [8].png 7KB Image [10].png 41KB资源评论
Twenty212018-03-06下载不了啊
