最近遇到一个问题，就是要用Grid++做页面数据报表打印，但是翻了Grid++文档就是没有直接从页面上传数据的，都是要加载txt文档，填写txt文档的url。自己尝试直接页面上传JSON数据到Grid++控件中，竟然成功了，分享一下。
静态框赋值Report.ParameterByName("ProductName").AsString="";
1.html页面代码如下：
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>会员资料报表</title>
<!--<script type="text/javascript" src="http://apps.bdimg.com/libs/jquery/2.1.4/jquery.min.js"></script>-->
<script src="CreateControl.js" type="text/javascript"></script>
<script type="text/javascript">
function window_onload() {
var Data = "{\"Detail\": [" +
"{\"ProductID\": 2,\"ProductName\": \"牛奶\",\"UnitPrice\": 15.2,\"Quantity\": 20,\"Amount\": 304}," +
"{\"ProductID\": 16,\"ProductName\": \"饼干\",\"UnitPrice\": 13.9,\"Quantity\": 35,\"Amount\": 486.5}," +
"{\"ProductID\": 36,\"ProductName\": \"鱿鱼\",\"UnitPrice\": 15.2,\"Quantity\": 25,\"Amount\": 380}," +
"{\"ProductID\": 59,\"ProductName\": \"苏澳奶酪\",\"UnitPrice\": 44,\"Quantity\": 30,\"Amount\": 1320}" +
"]}";
var d = JSON.parse(Data);
ReportViewer.Stop();
var Report = ReportViewer.Report;
var Recordset = Report.DetailGrid.Recordset;
Report.PrepareLoadData();
for(var i = 0; i < d.Detail.length; i++) {
Recordset.Append();
Report.FieldByName("C1").AsString = d.Detail[i].ProductID;
Report.FieldByName("C2").AsString = d.Detail[i].ProductName;
Report.FieldByName("C3").AsString = d.Detail[i].UnitPrice;
Report.FieldByName("C4").AsString = d.Detail[i].Quantity;
Report.FieldByName("C5").AsString = d.Detail[i].Amount;
Recordset.Post();
}
ReportViewer.Start();
}
</script>
</head>
<body onload="window_onload()">
<script type="text/javascript">
CreatePrintViewerEx("100%", "100%", "www.grf", "", true, "");
</script>
</body>
</html>
2.Grid++文件代码如下，txt保存改后缀为grf就可以：
{
"Version":"6.3.0.1",
"Font":{
"Name":"宋体",
"Size":90000,
"Weight":400,
"Charset":134
},
"Printer":{
},
"DetailGrid":{
"Recordset":{
"Field":[
{
"Name":"C1"
},
{
"Name":"C2"
},
{
"Name":"C3"
},
{
"Name":"C4"
},
{
"Name":"C5"
}
]
},
"Column":[
{
"Name":"Column1",
"Width":2.38
},
{
"Name":"Column2",
"Width":2.38
},
{
"Name":"Column3",
"Width":2.38
},
{
"Name":"Column4",
"Width":2.38
},
{
"Name":"Column5",
"Width":2.38
}
],
"ColumnContent":{
"Height":0.508,
"ColumnContentCell":[
{
"Column":"Column1",
"DataField":"C1"
},
{
"Column":"Column2",
"DataField":"C2"
},
{
"Column":"Column3",
"DataField":"C3"
},
{
"Column":"Column4",
"DataField":"C4"
},
{
"Column":"Column5",
"DataField":"C5"
}
]
},
"ColumnTitle":{
"Height":0.508,
"ColumnTitleCell":[
{
"GroupTitle":false,
"Column":"Column1",
"TextAlign":"MiddleCenter",
"Text":"ProductID"
},
{
"GroupTitle":false,
"Column":"Column2",
"TextAlign":"MiddleCenter",
"Text":"ProductName"
},
{
"GroupTitle":false,
"Column":"Column3",
"TextAlign":"MiddleCenter",
"Text":"UnitPrice"
},
{
"GroupTitle":false,
"Column":"Column4",
"TextAlign":"MiddleCenter",
"Text":"Quantity"
},
{
"GroupTitle":false,
"Column":"Column5",
"TextAlign":"MiddleCenter",
"Text":"Amount"
}
]
}
},
"Parameter":[
{
"Name":"ProductID"
},
{
"Name":"ProductName"
},
{
"Name":"UnitPrice"
},
{
"Name":"Quantity"
},
{
"Name":"Amount"
}
],
"ReportHeader":[
{
"Name":"ReportHeader1",
"Height":1.05833,
"Control":[
{
"Type":"StaticBox",
"Name":"StaticBox1",
"Left":5.79967,
"Top":0.1905,
"Width":2.794,
"Height":0.804333,
"Font":{
"Name":"宋体",
"Size":156000,
"Weight":400,
"Charset":134
},
"Text":"会员集料"
}
]
}
]
}
注意：grf文件中要赋值字段必须和js赋值一样多，不然就会报错显示不出来。
如果直接传入 json格式的话，加载数据用 ReportViewer.Report.LoadDataFromXML(jsonstr);
ReportViewer.Stop();
ReportViewer.Report.LoadDataFromXML(jsonstr);
//启动报表运行
ReportViewer.Start();
若jsonstr中用到动态加载的数据（记录集）那上述加载的不显示记录集，但是若是生成txt文件加载能显示记录集。不知道是什么什么原因引起的？