loulijun2021
2022-07-08 5b12ae51e0f42a1f17e81afa5385f3df57ea8810
public/static/grf/group.grf
ÎļþÃû´Ó public/static/grf/2a.grf ÐÞ¸Ä
@@ -1,5 +1,5 @@
{
   "Version":"6.8.5.0",
   "Version":"6.6.8.1",
   "Title":"2a.基本分组",
   "Author":"锐浪报表软件",
   "Description":"演示一个最一般的分组报表:首先定义一个分组,在报表布局窗口中会自动加入分组头与分组尾。通过设定分组对象的‘依据字段(ByFields)’属性,指定分组生成的依据字段。在分组头与分组尾中加入相应的部件框,实现分组信息的显示。使用统计框或Memo框实现数据的统计分析。",
@@ -13,15 +13,18 @@
   },
   "DetailGrid":{
      "CenterView":true,
      "Border":{
         "ShadowColor":"800000"
      },
      "ColLine":{
         "Color":"646F71"
         "Color":"800000"
      },
      "RowLine":{
         "Color":"646F71"
         "Color":"800000"
      },
      "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.OrderID,m.CustomerId,c.CompanyName,m.OrderDate,M.Freight,\r\nd.ProductID,p.ProductName,d.UnitPrice,d.Quantity,d.Discount,\r\nd.UnitPrice*d.Quantity as Amount, Amount*d.Discount as DiscountAmt, Amount-DiscountAmt as NetAmount\r\nfrom (Orders m inner join \r\n(OrderDetails d inner join Products p on P.ProductID=D.ProductID) on m.OrderId=d.OrderId)\r\nleft join Customers c on c.CustomerID=m.CustomerID\r\nwhere m.OrderID<=10300\r\norder by m.OrderDate, m.OrderID",
         "ConnectionString":"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\\rubylong\\DragonReport6.0\\Samples\\Data\\NorthWind.mdb;",
         "QuerySQL":"select m.OrderID,m.CustomerId,c.CompanyName,m.OrderDate,M.Freight,\r\nd.ProductID,p.ProductName,d.UnitPrice,d.Quantity,d.Discount,\r\nd.UnitPrice*d.Quantity as Amount, Amount*d.Discount as DiscountAmt, Amount-DiscountAmt as NetAmount\r\nfrom (Orders m inner join \r\n(OrderDetails as d inner join Products p on P.ProductID=D.ProductID) on m.OrderId=d.OrderId)\r\nleft join Customers c on c.CustomerID=m.CustomerID\r\nwhere m.OrderID<=10300\r\norder by m.OrderDate, m.OrderID",
         "Field":[
            {
               "Name":"OrderID",
@@ -41,7 +44,7 @@
            {
               "Name":"Freight",
               "Type":"Float",
               "Format":"#,##0.00"
               "Format":"$#,##0.00"
            },
            {
               "Name":"ProductID",
@@ -68,17 +71,17 @@
            {
               "Name":"Amount",
               "Type":"Float",
               "Format":"#,##0.00"
               "Format":"$#,##0.00"
            },
            {
               "Name":"DiscountAmt",
               "Type":"Float",
               "Format":"#,##0.00"
               "Format":"$#,##0.00"
            },
            {
               "Name":"NetAmount",
               "Type":"Float",
               "Format":"#,##0.00"
               "Format":"$#,##0.00"
            }
         ]
      },
@@ -275,7 +278,7 @@
                     "Height":0.79375,
                     "TextAlign":"MiddleRight",
                     "DataField":"Amount",
                     "Format":"#,##0.00"
                     "Format":"$#,##0.00"
                  },
                  {
                     "Type":"SummaryBox",
@@ -287,7 +290,7 @@
                     "Height":0.79375,
                     "TextAlign":"MiddleRight",
                     "DataField":"DiscountAmt",
                     "Format":"#,##0.00"
                     "Format":"$#,##0.00"
                  },
                  {
                     "Type":"SummaryBox",
@@ -299,7 +302,7 @@
                     "Height":0.79375,
                     "TextAlign":"MiddleRight",
                     "DataField":"NetAmount",
                     "Format":"#,##0.00"
                     "Format":"$#,##0.00"
                  }
               ]
            }
@@ -347,6 +350,12 @@
         }
      ]
   },
   "Parameter":[
      {
         "Name":"Parameter1",
         "Value":"来自报表参数的显示文字"
      }
   ],
   "ReportHeader":[
      {
         "Height":1.37583,