| ÎļþÃû´Ó public/static/grf/2a.grf ÐÞ¸Ä |
| | |
| | | { |
| | | "Version":"6.8.5.0", |
| | | "Version":"6.6.8.1", |
| | | "Title":"2a.åºæ¬åç»", |
| | | "Author":"éæµªæ¥è¡¨è½¯ä»¶", |
| | | "Description":"æ¼ç¤ºä¸ä¸ªæä¸è¬çåç»æ¥è¡¨:é¦å
å®ä¹ä¸ä¸ªåç»ï¼å¨æ¥è¡¨å¸å±çªå£ä¸ä¼èªå¨å å
¥åç»å¤´ä¸åç»å°¾ãéè¿è®¾å®åç»å¯¹è±¡çâ便®å段(ByFields)â屿§ï¼æå®åç»çæç便®å段ãå¨åç»å¤´ä¸åç»å°¾ä¸å å
¥ç¸åºçé¨ä»¶æ¡ï¼å®ç°åç»ä¿¡æ¯çæ¾ç¤ºã使ç¨ç»è®¡æ¡æMemoæ¡å®ç°æ°æ®çç»è®¡åæã", |
| | |
| | | }, |
| | | "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", |
| | |
| | | { |
| | | "Name":"Freight", |
| | | "Type":"Float", |
| | | "Format":"#,##0.00" |
| | | "Format":"$#,##0.00" |
| | | }, |
| | | { |
| | | "Name":"ProductID", |
| | |
| | | { |
| | | "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" |
| | | } |
| | | ] |
| | | }, |
| | |
| | | "Height":0.79375, |
| | | "TextAlign":"MiddleRight", |
| | | "DataField":"Amount", |
| | | "Format":"#,##0.00" |
| | | "Format":"$#,##0.00" |
| | | }, |
| | | { |
| | | "Type":"SummaryBox", |
| | |
| | | "Height":0.79375, |
| | | "TextAlign":"MiddleRight", |
| | | "DataField":"DiscountAmt", |
| | | "Format":"#,##0.00" |
| | | "Format":"$#,##0.00" |
| | | }, |
| | | { |
| | | "Type":"SummaryBox", |
| | |
| | | "Height":0.79375, |
| | | "TextAlign":"MiddleRight", |
| | | "DataField":"NetAmount", |
| | | "Format":"#,##0.00" |
| | | "Format":"$#,##0.00" |
| | | } |
| | | ] |
| | | } |
| | |
| | | } |
| | | ] |
| | | }, |
| | | "Parameter":[ |
| | | { |
| | | "Name":"Parameter1", |
| | | "Value":"æ¥èªæ¥è¡¨åæ°çæ¾ç¤ºæå" |
| | | } |
| | | ], |
| | | "ReportHeader":[ |
| | | { |
| | | "Height":1.37583, |