{ "Version":"6.7.5.1", "Title":"3a.交叉表起步", "Author":"锐浪报表软件", "Description":"演示一个最基本的交叉报表\r\n\r\n1、设定明细网格的“交叉表方式”属性为“是”指定本报表为一个交叉报表,此时明细网格具有了一个交叉表子对象,在报表对象浏览窗口的明细网格下可以找到“交叉表”节点,选中此节点让交叉表成为当前选中字段。 \r\n2、设定纵向交叉字段:设置交叉表的“纵向交叉字段”属性为“CustomerId”。 \r\n3、设定横向交叉字段:设置交叉表的“横向交叉字段”属性为“ProductID”。 \r\n4、设定纵向交叉列:设置交叉表的“项目列数”属性为“2”,这样指定明细网格的前两列为纵向交叉列,紧随其后的“金额”列为横向交叉列。 \r\n5、设定横向交叉列的标题,在标题格中插入字段框来实现动态的表格标题:选中“金额”列的标题格,设置其“自由格”属性为“是”;删除格中的静态框,然后插入一个字段框,字段框的“数据字段”属性为“ProductName”;最后设定字段框的“停靠”属性为“充满”。 \r\n", "Font":{ "Name":"宋体", "Size":90000, "Weight":400, "Charset":134 }, "Printer":{ "Size":256, "LeftMargin":1.5, "RightMargin":1.5 }, "DetailGrid":{ "CenterView":true, "IsCrossTab":true, "FixCols":2, "PrintAdaptMethod":"ToNewPage", "ColLine":{ "Color":"646F71" }, "RowLine":{ "Color":"646F71" }, "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 m.CustomerId,c.CompanyName,d.ProductID,p.ProductName,\r\nd.Quantity, d.UnitPrice*d.Quantity as Amount\r\nfrom (Orders m inner join \r\n(OrderDetails d inner join Products p \r\non P.ProductID=D.ProductID) on m.OrderId=d.OrderId)\r\nleft join Customers c on c.CustomerID=m.CustomerID\r\nwhere d.ProductID<8\r\norder by m.CustomerId, d.ProductID", "Field":[ { "Name":"CustomerId" }, { "Name":"CompanyName" }, { "Name":"ProductID", "Type":"Integer" }, { "Name":"ProductName" }, { "Name":"Quantity", "Type":"Integer", "Format":"0.#########;;#" }, { "Name":"Amount", "Type":"Currency", "Format":"#,##0.00;;#" } ] }, "Column":[ { "Name":"CustomerID", "Width":1.56104 }, { "Name":"CustomerName", "Width":2.67229 }, { "Name":"Amount", "Width":1.74625 } ], "ColumnContent":{ "Height":0.608542, "ColumnContentCell":[ { "Column":"CustomerID", "DataField":"CustomerId" }, { "Column":"CustomerName", "DataField":"CompanyName" }, { "Column":"Amount", "TextAlign":"MiddleRight", "DataField":"Amount" } ] }, "ColumnTitle":{ "Height":0.79375, "Font":{ "Name":"宋体", "Size":90000, "Bold":true, "Charset":134 }, "RepeatStyle":"OnPage", "ColumnTitleCell":[ { "GroupTitle":false, "Column":"CustomerID", "TextAlign":"MiddleCenter", "Text":"客户编号" }, { "GroupTitle":false, "Column":"CustomerName", "TextAlign":"MiddleCenter", "Text":"客户名称" }, { "GroupTitle":false, "Column":"Amount", "FreeCell":true, "Control":[ { "Type":"FieldBox", "Name":"FieldBox1", "Dock":"Fill", "TextAlign":"MiddleCenter", "DataField":"ProductName" } ] } ] }, "CrossTab":{ "PercentFormat":"0.##%", "HCrossFields":"ProductID", "VCrossFields":"CustomerId", "ListCols":2 } }, "PageHeader":{ "Height":1.32292, "Control":[ { "Type":"MemoBox", "Name":"MemoBox2", "Anchor":"[Top|Right]", "Left":4.15396, "Top":0.396875, "Width":13.7054, "Height":0.47625, "Font":{ "Name":"楷体", "Size":120000, "Bold":true, "Charset":134 }, "Text":"欢迎访问Grid++Report网站www.rubylong.cn,了解最新产品信息。" }, { "Type":"Line", "Name":"Line1", "Anchor":"[Left|Top|Right]", "Top":1.00542, "Width":17.9652, "Pen":{ "Width":2 } } ] }, "PageFooter":{ "Height":1.32292, "Control":[ { "Type":"MemoBox", "Name":"MemoBox4", "Anchor":"[Top|Right]", "Left":15.1606, "Top":0.396875, "Width":2.59292, "Height":0.608542, "Text":"第[#SystemVar(PageNumber)#]页 共[#SystemVar(PageCount)#]页" }, { "Type":"MemoBox", "Name":"MemoBox3", "Left":0.211667, "Top":0.396875, "Width":6.19125, "Height":0.608542, "Text":"打印时间:[#SystemVar(CurrentDateTime):yyyy年MM月dd日 HH:mm:ss#]" } ] }, "ReportHeader":[ { "Height":1.40229, "Control":[ { "Type":"StaticBox", "Name":"TitleBox", "Center":"Horizontal", "Left":5.60917, "Top":0.211667, "Width":6.74688, "Height":0.582083, "Font":{ "Name":"宋体", "Size":150000, "Bold":true, "Charset":134 }, "TextAlign":"MiddleCenter", "Text":"按客户与产品交叉分析报表" } ] } ] }