1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
| {
| "Version":"6.6.8.1",
| "Title":"1a.简单表格",
| "Author":"锐浪报表软件",
| "Description":"演示一个最基本的列表报表。",
| "Font":{
| "Name":"宋体",
| "Size":90000,
| "Weight":400,
| "Charset":134
| },
| "Printer":{
| "Oriention":"Landscape",
| "LeftMargin":1.5,
| "RightMargin":1.5
| },
| "ReportHeader":[
| {
| "Name":"ReportHeader1",
| "Height":12.0121,
| "Font":{
| "Name":"宋体",
| "Size":142500,
| "Weight":400,
| "Charset":134
| },
| "Control":[
| {
| "Type":"Chart",
| "Name":"Chart1",
| "Dock":"Fill",
| "PaddingLeft":4,
| "PaddingRight":4,
| "PaddingTop":4,
| "PaddingBottom":4,
| "Title":"按城市与产品类别统计销售额",
| "Font":{
| "Name":"宋体",
| "Size":105000,
| "Weight":400,
| "Charset":134
| },
| "TitleFont":{
| "Name":"微软雅黑",
| "Size":157500,
| "Bold":true,
| "Charset":134
| },
| "ValueFont":{
| "Name":"幼圆",
| "Size":105000,
| "Weight":400,
| "Charset":134
| },
| "LegendValueVisible":true,
| "LegendShowSum":true,
| "GroupCount":1,
| "SeriesCount":1,
| "BarWidthPercent":85,
| "SeriesField":"CategoryName",
| "GroupField":"City",
| "Recordset":{
| "ConnectionString":"Provider=Microsoft.Jet.OLEDB.4.0;\r\nUser ID=Admin;\r\nData Source=C:\\Grid++Report 6\\Samples\\Data\\Northwind.mdb",
| "QuerySQL":"select p.CategoryID,t.CategoryName, c.City, sum(d.UnitPrice*d.Quantity) as Amount\r\nfrom (Orders m inner join \r\n(OrderDetails as d inner join (Products p inner join Categories t on p.CategoryID=t.CategoryID)\r\non P.ProductID=D.ProductID) on m.OrderId=d.OrderId)\r\nleft join Customers c on c.CustomerID=m.CustomerID\r\nwhere m.OrderDate between #1/1/1997# and #12/31/1997#\r\ngroup by p.CategoryID,t.CategoryName, c.City\r\norder by c.City,t.CategoryName",
| "Field":[
| {
| "Name":"CategoryID",
| "Type":"Integer"
| },
| {
| "Name":"CategoryName"
| },
| {
| "Name":"City"
| },
| {
| "Name":"Amount",
| "Type":"Currency"
| }
| ]
| },
| "XAxis":{
| "TextFormat":"0.##",
| "CoordLinePen":{
| "Color":"FFFF00"
| }
| },
| "YAxis":{
| "Label":"销售额",
| "TextFormat":"0.##",
| "CoordLinePen":{
| "Color":"FFFF00"
| }
| },
| "Y2Axis":{
| "TextFormat":"0.##",
| "CoordLinePen":{
| "Color":"FFC4C4"
| }
| },
| "ChartSeries":[
| {
| "YValueField":"Amount",
| "ValueFormat":"0.00,",
| "LabelText":"[#ChartVar(YVal):#,##0.00#]",
| "LabelInBar":true,
| "TooltipText":"[#ChartVar(SeriesLabel)#]:[#ChartVar(YVal)#]"
| }
| ]
| }
| ]
| }
| ]
| }
|
|
