float: left;\r
padding: 5px;\r
}\r
-\r
-div.ricoLG_cell {\r
- font-size: 8pt;\r
- height: 12px;\r
- white-space: nowrap;\r
-}\r
</style>\r
\r
</head>\r
\r
<div class='gridcontainer' style='height:39%'>\r
\r
-<Rico:LiveGrid runat='server' id='customer' caption='Customers' rows='-4' frozenColumns='2' TableName='customers' DefaultSort='CustomerID' menuEvent='contextmenu' DisplayTimer='false' highlightElem='menuRow' dblclick="Rico.eventHandle(window,'customerDrillDown')">\r
- <Rico:Column runat='server' heading='Customer#' colname='CustomerID' width='60' />\r
- <Rico:Column runat='server' heading='Company' colname='CompanyName' width='150' />\r
- <Rico:Column runat='server' heading='Contact' colname='ContactName' width='115' />\r
- <Rico:Column runat='server' heading='Address' colname='Address' width='130' />\r
- <Rico:Column runat='server' heading='City' colname='City' width='90' />\r
- <Rico:Column runat='server' heading='Region' colname='Region' width='60' />\r
- <Rico:Column runat='server' heading='Postal Code' colname='PostalCode' width='90' />\r
- <Rico:Column runat='server' heading='Country' colname='Country' width='100' />\r
- <Rico:Column runat='server' heading='Phone' colname='Phone' width='115' />\r
- <Rico:Column runat='server' heading='Fax' colname='Fax' width='115' />\r
+<Rico:LiveGrid runat='server' id='customer' caption='Customers' rows='-4' frozenColumns='2' DefaultSort='CustomerID' menuEvent='contextmenu' DisplayTimer='false' highlightElem='menuRow' dblclick="Rico.eventHandle(window,'customerDrillDown')">\r
+ <Rico:DefaultGridStyle runat='server' fontsize="8" />\r
+ <Rico:Table runat='server' TblName='customers' />\r
+ <Rico:TableCol runat='server' heading='Cust ID' colname='CustomerID' width='60' />\r
+ <Rico:TableCol runat='server' heading='Company' colname='CompanyName' width='150' />\r
+ <Rico:TableCol runat='server' heading='Contact' colname='ContactName' width='115' />\r
+ <Rico:TableCol runat='server' heading='Address' colname='Address' width='130' />\r
+ <Rico:TableCol runat='server' heading='City' colname='City' width='90' />\r
+ <Rico:TableCol runat='server' heading='Region' colname='Region' width='60' />\r
+ <Rico:TableCol runat='server' heading='Postal Code' colname='PostalCode' width='90' />\r
+ <Rico:TableCol runat='server' heading='Country' colname='Country' width='100' />\r
+ <Rico:TableCol runat='server' heading='Phone' colname='Phone' width='115' />\r
+ <Rico:TableCol runat='server' heading='Fax' colname='Fax' width='115' />\r
</Rico:LiveGrid>\r
\r
</div>\r
<div class='gridcontainer' style='height:30%'>\r
\r
-<Rico:LiveGrid runat='server' id='order' caption='' rows='-4' prefetchBuffer='false' TableName='orders' DefaultSort='OrderID' menuEvent='contextmenu' DisplayTimer='false' highlightElem='menuRow' dblclick="Rico.eventHandle(window,'orderDrillDown')">\r
- <Rico:Column runat='server' heading='Customer#' colname='CustomerID' width='60' canSort='false' visible='false'/>\r
- <Rico:Column runat='server' heading='Order#' colname='OrderID' width='60' />\r
- <Rico:Column runat='server' heading='Ship Name' colname='ShipName' width='150' />\r
- <Rico:Column runat='server' heading='Ship City' colname='ShipCity' width='80' />\r
- <Rico:Column runat='server' heading='Ship Country' colname='ShipCountry' width='90' />\r
- <Rico:Column runat='server' heading='Order Date' colname='OrderDate' width='100' datatype='date' />\r
- <Rico:Column runat='server' heading='Ship Date' colname='ShippedDate' width='100' datatype='date' />\r
+<Rico:LiveGrid runat='server' id='order' caption='' rows='-4' prefetchBuffer='false' DefaultSort='OrderID' menuEvent='contextmenu' DisplayTimer='false' highlightElem='menuRow' dblclick="Rico.eventHandle(window,'orderDrillDown')">\r
+ <Rico:DefaultGridStyle runat='server' fontsize="8" />\r
+ <Rico:Table runat='server' TblName='orders' />\r
+ <Rico:TableCol runat='server' heading='Cust ID' colname='CustomerID' width='60' canSort='false' visible='false' />\r
+ <Rico:TableCol runat='server' heading='Order#' colname='OrderID' width='60' />\r
+ <Rico:TableCol runat='server' heading='Ship Name' colname='ShipName' width='150' />\r
+ <Rico:TableCol runat='server' heading='Ship City' colname='ShipCity' width='80' />\r
+ <Rico:TableCol runat='server' heading='Ship Country' colname='ShipCountry' width='90' />\r
+ <Rico:TableCol runat='server' heading='Order Date' colname='OrderDate' width='100' datatype='date' />\r
+ <Rico:TableCol runat='server' heading='Ship Date' colname='ShippedDate' width='100' datatype='date' />\r
</Rico:LiveGrid>\r
\r
</div>\r
<div class='gridcontainer' style='height:30%'>\r
\r
-<Rico:LiveGrid runat='server' id='detail' caption='' rows='-4' prefetchBuffer='false' TableName='order_details' menuEvent='contextmenu' DisplayTimer='false' highlightElem='menuRow'>\r
- <Rico:AltTable runat='server' TblName='products' TblAlias='p' JoinCondition='t.ProductId=p.ProductId' />\r
- <Rico:Column runat='server' heading='Order#' colname='OrderID' width='60' canSort='false' visible='false' />\r
- <Rico:Column runat='server' heading='Description' colname='ProductName' width='150' AltTable='products' />\r
- <Rico:Column runat='server' heading='Unit Quantity' colname='QuantityPerUnit' width='125' AltTable='products' />\r
- <Rico:Column runat='server' heading='Unit Price' colname='UnitPrice' width='80' format='Dollar' AltTable='products' />\r
- <Rico:Column runat='server' heading='Qty' colname='Quantity' width='50' format='Qty' />\r
- <Rico:Column runat='server' heading='Total' formula='t.UnitPrice*t.Quantity' width='80' format='Dollar' />\r
- <Rico:Column runat='server' heading='Discount' colname='Discount' width='80' format='Percent' />\r
- <Rico:Column runat='server' heading='Net Price' formula='t.UnitPrice*t.Quantity*(1.0-Discount)' width='90' format='Dollar' />\r
+<Rico:LiveGrid runat='server' id='detail' caption='' rows='-4' prefetchBuffer='false' menuEvent='contextmenu' DisplayTimer='false' highlightElem='menuRow'>\r
+ <Rico:DefaultGridStyle runat='server' fontsize="8" />\r
+ <Rico:Table runat='server' TblName='order_details' TblAlias='t' />\r
+ <Rico:Table runat='server' TblName='products' TblAlias='p' JoinCondition='t.ProductId=p.ProductId' />\r
+ <Rico:TableCol runat='server' heading='Order#' colname='OrderID' width='60' canSort='false' visible='false' />\r
+ <Rico:TableCol runat='server' heading='Description' colname='ProductName' width='150' AltTable='products' />\r
+ <Rico:TableCol runat='server' heading='Unit Quantity' colname='QuantityPerUnit' width='125' AltTable='products' />\r
+ <Rico:TableCol runat='server' heading='Unit Price' colname='UnitPrice' width='80' datatype='Dollar' AltTable='products' />\r
+ <Rico:TableCol runat='server' heading='Qty' colname='Quantity' width='50' datatype='number' />\r
+ <Rico:FormulaCol runat='server' heading='Total' formula='t.UnitPrice*t.Quantity' width='80' datatype='Dollar' />\r
+ <Rico:TableCol runat='server' heading='Discount' colname='Discount' width='80' datatype='Percent' />\r
+ <Rico:FormulaCol runat='server' heading='Net Price' formula='t.UnitPrice*t.Quantity*(1.0-Discount)' width='90' datatype='Dollar' />\r
</Rico:LiveGrid>\r
\r
</div>\r