Question

asp.net 使用水晶报表做柱形图时，如何显示出此柱形图的数据表

asp.net 使用水晶报表做柱形图时，如何显示出此柱形图的数据表，效果如图。用的SQL数据库，表里有两个字段，一个“周名称”，一个“百分比”。

Answer 1

<script type="text/javascript">
Ext.chart.Chart.CHART_URL ='../../js/charts.swf';
Ext.onReady(function(){
var store = new Ext.data.JsonStore({
fields:['name', 'visits', 'views'],
data: [
<%=strshuju %>]
});
new Ext.Panel({
iconCls:'chart',
<%=strtitle %>,
frame:true,
renderTo:'container',
width:660,
height:300,
layout:'fit',

items: {
xtype:'columnchart',
store:store,
url:'../../js/charts.swf',
xField: 'name',
yAxis: new Ext.chart.NumericAxis({
displayName: 'Visits',
labelRenderer : Ext.util.Format.numberRenderer('0,0')
}),
tipRenderer : function(chart, record, index, series){
if(series.yField == 'visits'){
return Ext.util.Format.number(record.data.visits, '0,0') + ' 产品数 ' + record.data.name;
}
else if(series.yField == 'views')
{
return Ext.util.Format.number(record.data.views, '0,0') + ' 故障件数 ' + record.data.name;
}
},
chartStyle: {
padding: 10,
animationEnabled: true,
font: {
name: 'Tahoma',
color: 0x444444,
size: 11
},
dataTip: {
padding: 5,
border: {
color: 0x000000c,
size:1
},
background: {
color: 0xd2effd,
alpha: .9
},
font: {
name: 'Tahoma',
color: 0x000000,
size: 10,
bold: true
}
},
xAxis: {
color: 0x808080,
majorTicks: {color: 0x808080, length: 4},
minorTicks: {color: 0x3d80b3, length: 2},
majorGridLines: {size: 1, color: 0x808080}
},
yAxis: {
color: 0x808080,
majorTicks: {color: 0x808080, length: 4},
minorTicks: {color: 0xcccccc, length: 2},
majorGridLines: {size: 1, color: 0x808080}
}
},
series: [{
type:'line',
displayName: 'Visits',
yField: 'visits',
style: {
color: 0x013CA1
}
}
,{
type:'line',
displayName: 'views',
yField: 'views',
style: {
color: 0x3d80b3
}
}
]
}
});
});
</script>

Answer 2

去找个插件吧