gridView.recordcount 1 gridView.inlineEdit connectionType 4 connectionString Driver={Microsoft Access Driver (*.mdb)};DBQ=|DataDirectory|NWind.mdb;DriverId=25;FIL=MS Access; tablename Orders tableKeyColumn OrderID gridView.pagerecord gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.editrecord gridview.deleterecord gridview.viewrecord gridview.insertrecord hidegridview hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_cancel gridEdit.isBinary binaryData.fileSytemDBPath networkCredential.userName networkCredential.passWord sqldeveloperwindowcb on importexportcb on gridView.importStopAfterErrorCount 10 gridedit.allowunecryptedquerystring gridView.gridDdlForm 0 gridView.ID gridEdit.ID gridEdit.sendToMail gridView.OrderBy RequiredDate DESC gridView.SqlWhere moduleHeader moduleFooter <font face="Georgia, Serif"> Average time to ship - planned time of all products in table:<span style="color: blue"> <command sql="SELECT ROUND(AVG((CDATE(RequiredDate)) - (CDATE(OrderDate))),2) FROM Orders "></command></span><BR>Average time to ship - planned time of all product in the grid (filtered if any grid filter applied):<span style="color: blue"> <command sql="SELECT ROUND(AVG((CDATE(RequiredDate)) - (CDATE(OrderDate))),2) FROM Orders [indoogrid:gridViewWhereClause]"></command></span><BR><br> Average time to ship - actual time of shipping for all products in the table: <span style="color: red"><command sql="SELECT ROUND(AVG((CDATE(ShippedDate)) - (CDATE(OrderDate))),2) FROM Orders WHERE NOT ISNULL(ShippedDate) "></command></span><BR>Average time to ship - actual time of shipping for all product in the grid (filtered if any grid filter applied): <span style="color: red"><command sql="SELECT Round(AVG(IIF(ISNULL(ShippedDate),NULL, CDate(ShippedDate) - CDate(OrderDate))),2) FROM Orders [indoogrid:gridViewWhereClause]"></command></span><BR></font> htmlHeadBlock <style> input.gv_ff { background-color:#FFE89E; color: black; } select.gv_fl, select.gv_vl{ background-color:#FFE89E; color: black; } /*filter button*/ .gridView TD.gv_cd2 { color:black; padding: 5px 1px 0px 0px; } /*header row*/ TABLE TD.gv_hcc { font-weight: bold; background: #FFD000; background-image: none; background-repeat: no-repeat; } /*basic row*/ TD.gv_cc { padding: 7px 3px 3px 5px; background: #FFF8E0; } TD.gv_cc DIV { font-size: 12px; font-family: Georgia, Serif; } /*alternate row*/ TD.gv_cc2 { padding: 7px 3px 3px 5px; background: #FFE89E; } TD.gv_cc2 DIV { font-size: 12px; font-family: Georgia, Serif; } /*header link*/ TD.gv_hcc A, TD.gv_hcc A:hover, TD.gv_hcc A:active, TD.gv_hcc A:link, TD.gv_hcc A:visited { font-weight:bold; } /*all empty*/ TD#dnn_ctr640_ContentPane { background: #FFF8E0; } </style> startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord createKeyColumn gridViewColumn.0.columnName CustomerID gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridEditColumn.0.columnName CustomerID gridEditColumn.0.Visible on gridEditColumn.0.Autovalidator on gridViewColumn.1.columnName EmployeeID gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 3 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridEditColumn.1.columnName EmployeeID gridEditColumn.1.Visible on gridEditColumn.1.Autovalidator on gridViewColumn.2.columnName OrderDate gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 2 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridEditColumn.2.columnName OrderDate gridEditColumn.2.Visible on gridEditColumn.2.Autovalidator on gridViewColumn.3.columnName RequiredDate gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 3 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridEditColumn.3.columnName RequiredDate gridEditColumn.3.Visible on gridEditColumn.3.Autovalidator on gridViewColumn.6.columnName ShippedDate gridViewColumn.6.Visible on gridViewColumn.6.allowExport on gridViewColumn.6.allowEdit on gridViewColumn.6.allowFilter 1 gridViewColumn.6.allowSort on gridViewColumn.6.allowImport on gridEditColumn.4.columnName ShippedDate gridEditColumn.4.Visible on gridEditColumn.4.Autovalidator on gridViewColumn.7.columnName ShipVia gridViewColumn.7.Visible on gridViewColumn.7.allowExport on gridViewColumn.7.allowEdit on gridViewColumn.7.allowFilter 1 gridViewColumn.7.allowSort on gridViewColumn.7.allowImport on gridEditColumn.5.columnName ShipVia gridEditColumn.5.Visible on gridEditColumn.5.Autovalidator on gridViewColumn.8.columnName Freight gridViewColumn.8.Visible on gridViewColumn.8.allowExport on gridViewColumn.8.allowEdit on gridViewColumn.8.allowFilter 1 gridViewColumn.8.allowSort on gridViewColumn.8.allowImport on gridEditColumn.6.columnName Freight gridEditColumn.6.Visible on gridEditColumn.6.Autovalidator on gridViewColumn.9.columnName ShipName gridViewColumn.9.Visible gridViewColumn.9.allowExport on gridViewColumn.9.allowEdit on gridViewColumn.9.allowFilter 1 gridViewColumn.9.allowSort on gridViewColumn.9.allowImport on gridEditColumn.7.columnName ShipName gridEditColumn.7.Visible on gridEditColumn.7.Autovalidator on gridViewColumn.10.columnName ShipAddress gridViewColumn.10.Visible gridViewColumn.10.allowExport on gridViewColumn.10.allowEdit on gridViewColumn.10.allowFilter 1 gridViewColumn.10.allowSort on gridViewColumn.10.allowImport on gridEditColumn.8.columnName ShipAddress gridEditColumn.8.Visible on gridEditColumn.8.Autovalidator on gridViewColumn.11.columnName ShipCity gridViewColumn.11.Visible gridViewColumn.11.allowExport on gridViewColumn.11.allowEdit on gridViewColumn.11.allowFilter 1 gridViewColumn.11.allowSort on gridViewColumn.11.allowImport on gridEditColumn.9.columnName ShipCity gridEditColumn.9.Visible on gridEditColumn.9.Autovalidator on gridViewColumn.12.columnName ShipRegion gridViewColumn.12.Visible gridViewColumn.12.allowExport on gridViewColumn.12.allowEdit on gridViewColumn.12.allowFilter 1 gridViewColumn.12.allowSort on gridViewColumn.12.allowImport on gridEditColumn.10.columnName ShipRegion gridEditColumn.10.Visible on gridEditColumn.10.Autovalidator on gridViewColumn.13.columnName ShipPostalCode gridViewColumn.13.Visible gridViewColumn.13.allowExport on gridViewColumn.13.allowEdit on gridViewColumn.13.allowFilter 1 gridViewColumn.13.allowSort on gridViewColumn.13.allowImport on gridEditColumn.11.columnName ShipPostalCode gridEditColumn.11.Visible on gridEditColumn.11.Autovalidator on gridViewColumn.14.columnName ShipCountry gridViewColumn.14.Visible on gridViewColumn.14.allowExport on gridViewColumn.14.allowEdit on gridViewColumn.14.allowFilter 1 gridViewColumn.14.allowSort on gridViewColumn.14.allowImport on gridEditColumn.12.columnName ShipCountry gridEditColumn.12.Visible on gridEditColumn.12.Autovalidator on gridViewColumn.0.caption Customer gridViewColumn.0.width gridViewColumn.0.defaultContent gridViewColumn.0.formatData gridViewColumn.0.importDefault gridViewColumn.0.filterAdditionalColumn gridViewColumn.0.defaultSortColumn gridViewColumn.0.isBoolean gridViewColumn.0.isLink gridViewColumn.0.isOther gridViewColumn.0.isBinary gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.0.navigateUrlTarget _blank gridViewColumn.0.joinTableName Customers gridViewColumn.0.joinTableIdColumnName CustomerID gridViewColumn.0.joinTableColumnName CompanyName gridViewColumn.1.caption Employee gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isOther gridViewColumn.1.isBinary gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.navigateUrlTarget _blank gridViewColumn.1.joinTableName Employees gridViewColumn.1.joinTableIdColumnName EmployeeID gridViewColumn.1.joinTableColumnName LastName gridViewColumn.2.caption Order Date gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData d;en-us gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isOther gridViewColumn.2.isBinary gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes gridViewColumn.3.caption Required Date gridViewColumn.3.width gridViewColumn.3.defaultContent gridViewColumn.3.formatData d;en-us gridViewColumn.3.importDefault gridViewColumn.3.filterAdditionalColumn gridViewColumn.3.defaultSortColumn gridViewColumn.3.isBoolean gridViewColumn.3.isLink gridViewColumn.3.isOther gridViewColumn.3.isBinary gridViewColumn.3.isJoin gridViewColumn.3.isHtmlAttributes gridViewColumn.6.caption Shipped Date gridViewColumn.6.width gridViewColumn.6.defaultContent gridViewColumn.6.formatData d;en-us gridViewColumn.6.importDefault gridViewColumn.6.filterAdditionalColumn gridViewColumn.6.defaultSortColumn gridViewColumn.6.isBoolean gridViewColumn.6.isLink gridViewColumn.6.isOther gridViewColumn.6.isBinary gridViewColumn.6.isJoin gridViewColumn.6.isHtmlAttributes gridViewColumn.9.caption gridViewColumn.9.width gridViewColumn.9.defaultContent gridViewColumn.9.formatData gridViewColumn.9.importDefault gridViewColumn.9.filterAdditionalColumn gridViewColumn.9.defaultSortColumn gridViewColumn.9.isBoolean gridViewColumn.9.isLink gridViewColumn.9.isOther gridViewColumn.9.isBinary gridViewColumn.9.isJoin gridViewColumn.9.isHtmlAttributes gridViewColumn.10.caption gridViewColumn.10.width gridViewColumn.10.defaultContent gridViewColumn.10.formatData gridViewColumn.10.importDefault gridViewColumn.10.filterAdditionalColumn gridViewColumn.10.defaultSortColumn gridViewColumn.10.isBoolean gridViewColumn.10.isLink gridViewColumn.10.isOther gridViewColumn.10.isBinary gridViewColumn.10.isJoin gridViewColumn.10.isHtmlAttributes gridViewColumn.11.caption gridViewColumn.11.width gridViewColumn.11.defaultContent gridViewColumn.11.formatData gridViewColumn.11.importDefault gridViewColumn.11.filterAdditionalColumn gridViewColumn.11.defaultSortColumn gridViewColumn.11.isBoolean gridViewColumn.11.isLink gridViewColumn.11.isOther gridViewColumn.11.isBinary gridViewColumn.11.isJoin gridViewColumn.11.isHtmlAttributes gridViewColumn.12.caption gridViewColumn.12.width gridViewColumn.12.defaultContent gridViewColumn.12.formatData gridViewColumn.12.importDefault gridViewColumn.12.filterAdditionalColumn gridViewColumn.12.defaultSortColumn gridViewColumn.12.isBoolean gridViewColumn.12.isLink gridViewColumn.12.isOther gridViewColumn.12.isBinary gridViewColumn.12.isJoin gridViewColumn.12.isHtmlAttributes gridViewColumn.13.caption gridViewColumn.13.width gridViewColumn.13.defaultContent gridViewColumn.13.formatData gridViewColumn.13.importDefault gridViewColumn.13.filterAdditionalColumn gridViewColumn.13.defaultSortColumn gridViewColumn.13.isBoolean gridViewColumn.13.isLink gridViewColumn.13.isOther gridViewColumn.13.isBinary gridViewColumn.13.isJoin gridViewColumn.13.isHtmlAttributes gridViewColumn.7.caption Ship Via gridViewColumn.7.width gridViewColumn.7.defaultContent gridViewColumn.7.formatData gridViewColumn.7.importDefault gridViewColumn.7.filterAdditionalColumn gridViewColumn.7.defaultSortColumn gridViewColumn.7.isBoolean gridViewColumn.7.isLink gridViewColumn.7.isOther gridViewColumn.7.isBinary gridViewColumn.7.isJoin on gridViewColumn.7.isHtmlAttributes gridViewColumn.7.navigateUrlTarget _blank gridViewColumn.7.joinTableName Shippers gridViewColumn.7.joinTableIdColumnName ShipperID gridViewColumn.7.joinTableColumnName CompanyName gridViewColumn.14.caption Ship Country gridViewColumn.14.width gridViewColumn.14.defaultContent gridViewColumn.14.formatData gridViewColumn.14.importDefault gridViewColumn.14.filterAdditionalColumn gridViewColumn.14.defaultSortColumn gridViewColumn.14.isBoolean gridViewColumn.14.isLink gridViewColumn.14.isOther gridViewColumn.14.isBinary gridViewColumn.14.isJoin gridViewColumn.14.isHtmlAttributes gridViewColumn.4.Visible on gridViewColumn.4.allowExport gridViewColumn.4.allowEdit on gridViewColumn.4.allowFilter 0 gridViewColumn.4.allowSort gridViewColumn.4.allowImport gridViewColumn.4.columnName CustomerID gridViewColumn.4.caption Planned gridViewColumn.4.width gridViewColumn.4.defaultContent gridViewColumn.4.formatData gridViewColumn.4.importDefault gridViewColumn.4.filterAdditionalColumn gridViewColumn.4.defaultSortColumn gridViewColumn.4.isBoolean gridViewColumn.4.isLink gridViewColumn.4.isOther on gridViewColumn.4.isBinary gridViewColumn.4.isJoin gridViewColumn.4.isHtmlAttributes gridViewColumn.4.rowDataColumn.1 RequiredDate gridViewColumn.4.rowDataPrefix.1 <div align="center"><font color="blue"><script language="javascript"> var rd= Date.parse(' gridViewColumn.4.rowDataSuffix.1 '); gridViewColumn.4.rowDataRegexSearch.1 gridViewColumn.4.rowDataRegexReplace.1 gridViewColumn.4.rowDataConditionColumn.1 gridViewColumn.4.rowDataCondition.1 gridviewcolumn.13.rowdatahtmlencode.1 gridviewcolumn.13.rowdataurlencode.1 gridViewColumn.4.rowDataColumn.2 OrderDate gridViewColumn.4.rowDataPrefix.2 var od=Date.parse(' gridViewColumn.4.rowDataSuffix.2 ');var d=((rd-od)/86400000); d=d.toFixed(0);document.write(d);</script></font></div> gridViewColumn.4.rowDataRegexSearch.2 gridViewColumn.4.rowDataRegexReplace.2 gridViewColumn.4.rowDataConditionColumn.2 gridViewColumn.4.rowDataCondition.2 gridviewcolumn.13.rowdatahtmlencode.2 gridviewcolumn.13.rowdataurlencode.2 gridViewColumn.4.rowDataColumn.3 gridViewColumn.4.rowDataPrefix.3 gridViewColumn.4.rowDataSuffix.3 gridViewColumn.4.rowDataRegexSearch.3 gridViewColumn.4.rowDataRegexReplace.3 gridViewColumn.4.rowDataConditionColumn.3 gridViewColumn.4.rowDataCondition.3 gridviewcolumn.13.rowdatahtmlencode.3 gridviewcolumn.13.rowdataurlencode.3 gridViewColumn.4.rowDataColumn.4 gridViewColumn.4.rowDataPrefix.4 gridViewColumn.4.rowDataSuffix.4 gridViewColumn.4.rowDataRegexSearch.4 gridViewColumn.4.rowDataRegexReplace.4 gridViewColumn.4.rowDataConditionColumn.4 gridViewColumn.4.rowDataCondition.4 gridviewcolumn.13.rowdatahtmlencode.4 gridviewcolumn.13.rowdataurlencode.4 gridViewColumn.4.rowDataColumn.5 gridViewColumn.4.rowDataPrefix.5 gridViewColumn.4.rowDataSuffix.5 gridViewColumn.4.rowDataRegexSearch.5 gridViewColumn.4.rowDataRegexReplace.5 gridViewColumn.4.rowDataConditionColumn.5 gridViewColumn.4.rowDataCondition.5 gridviewcolumn.13.rowdatahtmlencode.5 gridviewcolumn.13.rowdataurlencode.5 gridViewColumn.4.rowDataColumn.6 gridViewColumn.4.rowDataPrefix.6 gridViewColumn.4.rowDataSuffix.6 gridViewColumn.4.rowDataRegexSearch.6 gridViewColumn.4.rowDataRegexReplace.6 gridViewColumn.4.rowDataConditionColumn.6 gridViewColumn.4.rowDataCondition.6 gridviewcolumn.13.rowdatahtmlencode.6 gridviewcolumn.13.rowdataurlencode.6 gridViewColumn.4.rowDataColumn.7 gridViewColumn.4.rowDataPrefix.7 gridViewColumn.4.rowDataSuffix.7 gridViewColumn.4.rowDataRegexSearch.7 gridViewColumn.4.rowDataRegexReplace.7 gridViewColumn.4.rowDataConditionColumn.7 gridViewColumn.4.rowDataCondition.7 gridviewcolumn.13.rowdatahtmlencode.7 gridviewcolumn.13.rowdataurlencode.7 gridViewColumn.4.rowDataColumn.8 gridViewColumn.4.rowDataPrefix.8 gridViewColumn.4.rowDataSuffix.8 gridViewColumn.4.rowDataRegexSearch.8 gridViewColumn.4.rowDataRegexReplace.8 gridViewColumn.4.rowDataConditionColumn.8 gridViewColumn.4.rowDataCondition.8 gridviewcolumn.13.rowdatahtmlencode.8 gridviewcolumn.13.rowdataurlencode.8 gridViewColumn.4.rowDataColumn.9 gridViewColumn.4.rowDataPrefix.9 gridViewColumn.4.rowDataSuffix.9 gridViewColumn.4.rowDataRegexSearch.9 gridViewColumn.4.rowDataRegexReplace.9 gridViewColumn.4.rowDataConditionColumn.9 gridViewColumn.4.rowDataCondition.9 gridviewcolumn.13.rowdatahtmlencode.9 gridviewcolumn.13.rowdataurlencode.9 gridViewColumn.4.rowDataColumn.10 gridViewColumn.4.rowDataPrefix.10 gridViewColumn.4.rowDataSuffix.10 gridViewColumn.4.rowDataRegexSearch.10 gridViewColumn.4.rowDataRegexReplace.10 gridViewColumn.4.rowDataConditionColumn.10 gridViewColumn.4.rowDataCondition.10 gridviewcolumn.13.rowdatahtmlencode.10 gridviewcolumn.13.rowdataurlencode.10 gridviewcolumn.4.rowdatahtmlencode.1 gridviewcolumn.4.rowdataurlencode.1 gridviewcolumn.4.rowdatahtmlencode.2 gridviewcolumn.4.rowdataurlencode.2 gridviewcolumn.4.rowdatahtmlencode.3 gridviewcolumn.4.rowdataurlencode.3 gridviewcolumn.4.rowdatahtmlencode.4 gridviewcolumn.4.rowdataurlencode.4 gridviewcolumn.4.rowdatahtmlencode.5 gridviewcolumn.4.rowdataurlencode.5 gridviewcolumn.4.rowdatahtmlencode.6 gridviewcolumn.4.rowdataurlencode.6 gridviewcolumn.4.rowdatahtmlencode.7 gridviewcolumn.4.rowdataurlencode.7 gridviewcolumn.4.rowdatahtmlencode.8 gridviewcolumn.4.rowdataurlencode.8 gridviewcolumn.4.rowdatahtmlencode.9 gridviewcolumn.4.rowdataurlencode.9 gridviewcolumn.4.rowdatahtmlencode.10 gridviewcolumn.4.rowdataurlencode.10 gridViewColumn.5.Visible on gridViewColumn.5.allowExport gridViewColumn.5.allowEdit gridViewColumn.5.allowFilter 0 gridViewColumn.5.allowSort gridViewColumn.5.allowImport gridViewColumn.5.columnName CustomerID gridViewColumn.5.caption Actual gridViewColumn.5.width gridViewColumn.5.defaultContent gridViewColumn.5.formatData gridViewColumn.5.importDefault gridViewColumn.5.filterAdditionalColumn gridViewColumn.5.defaultSortColumn gridViewColumn.5.isBoolean gridViewColumn.5.isLink gridViewColumn.5.isOther on gridViewColumn.5.isBinary gridViewColumn.5.isJoin gridViewColumn.5.isHtmlAttributes gridViewColumn.5.rowDataColumn.1 OrderDate gridViewColumn.5.rowDataPrefix.1 <div align="center"><font color="blue"><script language="javascript"> var od= Date.parse(' gridViewColumn.5.rowDataSuffix.1 '); gridViewColumn.5.rowDataRegexSearch.1 gridViewColumn.5.rowDataRegexReplace.1 gridViewColumn.5.rowDataConditionColumn.1 ShippedDate gridViewColumn.5.rowDataCondition.1 <> gridviewcolumn.14.rowdatahtmlencode.1 gridviewcolumn.14.rowdataurlencode.1 gridViewColumn.5.rowDataColumn.2 ShippedDate gridViewColumn.5.rowDataPrefix.2 var sd=Date.parse(' gridViewColumn.5.rowDataSuffix.2 ');var d1=((sd-od)/86400000);d1=d1.toFixed(0);document.write(d1);</script></font></div> gridViewColumn.5.rowDataRegexSearch.2 gridViewColumn.5.rowDataRegexReplace.2 gridViewColumn.5.rowDataConditionColumn.2 ShippedDate gridViewColumn.5.rowDataCondition.2 <> gridviewcolumn.14.rowdatahtmlencode.2 gridviewcolumn.14.rowdataurlencode.2 gridViewColumn.5.rowDataColumn.3 gridViewColumn.5.rowDataPrefix.3 <div align="center"><font color="red">n/a</font></div> gridViewColumn.5.rowDataSuffix.3 gridViewColumn.5.rowDataRegexSearch.3 gridViewColumn.5.rowDataRegexReplace.3 gridViewColumn.5.rowDataConditionColumn.3 ShippedDate gridViewColumn.5.rowDataCondition.3 = gridviewcolumn.14.rowdatahtmlencode.3 gridviewcolumn.14.rowdataurlencode.3 gridViewColumn.5.rowDataColumn.4 gridViewColumn.5.rowDataPrefix.4 gridViewColumn.5.rowDataSuffix.4 gridViewColumn.5.rowDataRegexSearch.4 gridViewColumn.5.rowDataRegexReplace.4 gridViewColumn.5.rowDataConditionColumn.4 gridViewColumn.5.rowDataCondition.4 gridviewcolumn.14.rowdatahtmlencode.4 gridviewcolumn.14.rowdataurlencode.4 gridViewColumn.5.rowDataColumn.5 gridViewColumn.5.rowDataPrefix.5 gridViewColumn.5.rowDataSuffix.5 gridViewColumn.5.rowDataRegexSearch.5 gridViewColumn.5.rowDataRegexReplace.5 gridViewColumn.5.rowDataConditionColumn.5 gridViewColumn.5.rowDataCondition.5 gridviewcolumn.14.rowdatahtmlencode.5 gridviewcolumn.14.rowdataurlencode.5 gridViewColumn.5.rowDataColumn.6 gridViewColumn.5.rowDataPrefix.6 gridViewColumn.5.rowDataSuffix.6 gridViewColumn.5.rowDataRegexSearch.6 gridViewColumn.5.rowDataRegexReplace.6 gridViewColumn.5.rowDataConditionColumn.6 gridViewColumn.5.rowDataCondition.6 gridviewcolumn.14.rowdatahtmlencode.6 gridviewcolumn.14.rowdataurlencode.6 gridViewColumn.5.rowDataColumn.7 gridViewColumn.5.rowDataPrefix.7 gridViewColumn.5.rowDataSuffix.7 gridViewColumn.5.rowDataRegexSearch.7 gridViewColumn.5.rowDataRegexReplace.7 gridViewColumn.5.rowDataConditionColumn.7 gridViewColumn.5.rowDataCondition.7 gridviewcolumn.14.rowdatahtmlencode.7 gridviewcolumn.14.rowdataurlencode.7 gridViewColumn.5.rowDataColumn.8 gridViewColumn.5.rowDataPrefix.8 gridViewColumn.5.rowDataSuffix.8 gridViewColumn.5.rowDataRegexSearch.8 gridViewColumn.5.rowDataRegexReplace.8 gridViewColumn.5.rowDataConditionColumn.8 gridViewColumn.5.rowDataCondition.8 gridviewcolumn.14.rowdatahtmlencode.8 gridviewcolumn.14.rowdataurlencode.8 gridViewColumn.5.rowDataColumn.9 gridViewColumn.5.rowDataPrefix.9 gridViewColumn.5.rowDataSuffix.9 gridViewColumn.5.rowDataRegexSearch.9 gridViewColumn.5.rowDataRegexReplace.9 gridViewColumn.5.rowDataConditionColumn.9 gridViewColumn.5.rowDataCondition.9 gridviewcolumn.14.rowdatahtmlencode.9 gridviewcolumn.14.rowdataurlencode.9 gridViewColumn.5.rowDataColumn.10 gridViewColumn.5.rowDataPrefix.10 gridViewColumn.5.rowDataSuffix.10 gridViewColumn.5.rowDataRegexSearch.10 gridViewColumn.5.rowDataRegexReplace.10 gridViewColumn.5.rowDataConditionColumn.10 gridViewColumn.5.rowDataCondition.10 gridviewcolumn.14.rowdatahtmlencode.10 gridviewcolumn.14.rowdataurlencode.10 gridviewcolumn.5.rowdatahtmlencode.1 gridviewcolumn.5.rowdataurlencode.1 gridviewcolumn.5.rowdatahtmlencode.2 gridviewcolumn.5.rowdataurlencode.2 gridviewcolumn.5.rowdatahtmlencode.3 gridviewcolumn.5.rowdataurlencode.3 gridviewcolumn.5.rowdatahtmlencode.4 gridviewcolumn.5.rowdataurlencode.4 gridviewcolumn.5.rowdatahtmlencode.5 gridviewcolumn.5.rowdataurlencode.5 gridviewcolumn.5.rowdatahtmlencode.6 gridviewcolumn.5.rowdataurlencode.6 gridviewcolumn.5.rowdatahtmlencode.7 gridviewcolumn.5.rowdataurlencode.7 gridviewcolumn.5.rowdatahtmlencode.8 gridviewcolumn.5.rowdataurlencode.8 gridviewcolumn.5.rowdatahtmlencode.9 gridviewcolumn.5.rowdataurlencode.9 gridviewcolumn.5.rowdatahtmlencode.10 gridviewcolumn.5.rowdataurlencode.10 gridEditColumn.4.caption gridEditColumn.4.separator gridEditColumn.4.helpText gridEditColumn.4.Readonly gridEditColumn.4.isHtmlAttributes version 02.00.12 gridViewColumn.6.ddlType 2 gridViewColumn.6.ddlList gridViewColumn.6.ddlDefaultValue gridViewColumn.6.ddlNullText gridViewColumn.6.ddlSortById gridViewColumn.6.ddlAllOption on gridViewColumn.3.ddlType 2 gridViewColumn.3.ddlList <>00;All time >=1/1/2007;This year >6/10/2007;Last month >7/3/2007;Last week >=7/11/2007;Today gridViewColumn.3.ddlDefaultValue >1/1/1900 gridViewColumn.3.ddlNullText gridViewColumn.3.ddlSortById gridViewColumn.3.ddlAllOption gridViewColumn.0.ddlType 1 gridViewColumn.0.ddlTable Customers gridViewColumn.0.ddlSQLWhere gridViewColumn.0.sourceValueColumnName CustomerID gridViewColumn.0.sourceTextColumnName CompanyName gridViewColumn.0.ddlDefaultValue gridViewColumn.0.ddlNullText gridViewColumn.0.ddlSortById gridViewColumn.0.ddlAllOption on gridViewColumn.1.ddlType 1 gridViewColumn.1.ddlList 1;First 2;Second 3;Third 4;Fourth gridViewColumn.1.ddlDefaultValue gridViewColumn.1.ddlNullText gridViewColumn.1.ddlSortById gridViewColumn.1.ddlAllOption on gridViewColumn.7.ddlType 1 gridViewColumn.7.ddlTable Shippers gridViewColumn.7.ddlSQLWhere gridViewColumn.7.sourceValueColumnName ShipperID gridViewColumn.7.sourceTextColumnName CompanyName gridViewColumn.7.ddlDefaultValue gridViewColumn.7.ddlNullText gridViewColumn.7.ddlSortById gridViewColumn.7.ddlAllOption gridViewColumn.3.filterAutoFire on gridViewColumn.15.Visible gridViewColumn.15.allowExport gridViewColumn.15.allowEdit gridViewColumn.15.allowFilter 0 gridViewColumn.15.allowSort gridViewColumn.15.allowImport gridViewColumn.15.columnName Freight gridViewColumn.15.caption Search all fields gridViewColumn.15.width gridViewColumn.15.defaultContent gridViewColumn.15.formatData gridViewColumn.15.importDefault gridViewColumn.15.filterAdditionalColumn CustomerID gridViewColumn.15.defaultSortColumn gridViewColumn.15.isBoolean gridViewColumn.15.isLink gridViewColumn.15.isOther gridViewColumn.15.isBinary gridViewColumn.15.isJoin gridViewColumn.15.isHtmlAttributes gridViewColumn.8.caption Freight gridViewColumn.8.width gridViewColumn.8.defaultContent gridViewColumn.8.formatData gridViewColumn.8.importDefault gridViewColumn.8.filterAdditionalColumn gridViewColumn.8.defaultSortColumn gridViewColumn.8.isBoolean gridViewColumn.8.isLink gridViewColumn.8.isOther gridViewColumn.8.isBinary gridViewColumn.8.isJoin gridViewColumn.8.isHtmlAttributes gridViewColumn.16.Visible gridViewColumn.16.allowExport gridViewColumn.16.allowEdit gridViewColumn.16.allowFilter 2 gridViewColumn.16.allowSort gridViewColumn.16.allowImport gridViewColumn.16.columnName CustomerID gridViewColumn.16.caption Search all fields gridViewColumn.16.width gridViewColumn.16.defaultContent gridViewColumn.16.formatData gridViewColumn.16.importDefault gridViewColumn.16.filterAdditionalColumn Emploxee,Order Date,Required Date, Shipped Date, Ship Via,Freight,Ship Country gridViewColumn.16.defaultSortColumn gridViewColumn.16.isBoolean gridViewColumn.16.isLink gridViewColumn.16.isOther gridViewColumn.16.isBinary gridViewColumn.16.isJoin gridViewColumn.16.isHtmlAttributes gridedit.isgridvieweditredirected gridViewColumn.1.filterAutoFire on gridViewColumn.1.ddlTable Employees gridViewColumn.1.ddlSQLWhere gridViewColumn.1.sourceValueColumnName EmployeeID gridViewColumn.1.sourceTextColumnName FirstName gridViewColumn.2.filterDateAsWholeDayRange on gridViewColumn.2.dateTimePicker 2 gridViewColumn.6.filterDateAsWholeDayRange on gridViewColumn.6.dateTimePicker 2 gridViewColumn.3.filterDateAsWholeDayRange on gridView.hideElement 0 gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit_customHTMLForm gridEditColumn.0.multiplePage 1 gridEditColumn.0.caption gridEditColumn.0.Readonly gridEditColumn.1.multiplePage 1 gridEditColumn.1.caption gridEditColumn.1.Readonly gridEditColumn.2.multiplePage 1 gridEditColumn.2.caption gridEditColumn.2.Readonly gridEditColumn.3.multiplePage 1 gridEditColumn.3.caption gridEditColumn.3.Readonly gridEditColumn.4.multiplePage 1 gridEditColumn.5.multiplePage 1 gridEditColumn.5.caption gridEditColumn.5.Readonly gridEditColumn.6.multiplePage 1 gridEditColumn.6.caption gridEditColumn.6.Readonly gridEditColumn.7.multiplePage 1 gridEditColumn.7.caption gridEditColumn.7.Readonly gridEditColumn.8.multiplePage 1 gridEditColumn.8.caption gridEditColumn.8.Readonly gridEditColumn.9.multiplePage 1 gridEditColumn.9.caption gridEditColumn.9.Readonly gridEditColumn.10.multiplePage 1 gridEditColumn.10.caption gridEditColumn.10.Readonly gridEditColumn.11.multiplePage 1 gridEditColumn.11.caption gridEditColumn.11.Readonly gridEditColumn.12.multiplePage 1 gridEditColumn.12.caption gridEditColumn.12.Readonly isEmptyCaptionReplaced on gridview.ispagenumbertextbox gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter sqlOnUpdateFinishRecord notSkipSqlOnImport on showGridView on showGridEdit on gridview.sqlstatementquery gridView.recordcount 1 gridView.inlineEdit connectionType 4 connectionString Driver={Microsoft Access Driver (*.mdb)};DBQ=|DataDirectory|NWind.mdb;DriverId=25;FIL=MS Access; tablename Orders tableKeyColumn OrderID gridView.pagerecord gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.editrecord gridview.deleterecord gridview.viewrecord gridview.insertrecord hidegridview hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_cancel gridEdit.isBinary binaryData.fileSytemDBPath |DataDirectory|indooGrid\ networkCredential.userName networkCredential.passWord sqldeveloperwindowcb on importexportcb on gridView.importStopAfterErrorCount 10 gridedit.allowunecryptedquerystring gridView.gridDdlForm 0 gridView.ID gridEdit.ID gridEdit.sendToMail gridView.OrderBy RequiredDate DESC gridView.SqlWhere moduleHeader moduleFooter <font face="Georgia, Serif"> Average time to ship - planned time of all products in table:<span style="color: blue"> <command sql="SELECT ROUND(AVG((CDATE(RequiredDate)) - (CDATE(OrderDate))),2) FROM Orders "></command></span><BR>Average time to ship - planned time of all product in the grid (filtered if any grid filter applied):<span style="color: blue"> <command sql="SELECT ROUND(AVG((CDATE(RequiredDate)) - (CDATE(OrderDate))),2) FROM Orders [indoogrid:gridViewWhereClause]"></command></span><BR><br> Average time to ship - actual time of shipping for all products in the table: <span style="color: red"><command sql="SELECT ROUND(AVG((CDATE(ShippedDate)) - (CDATE(OrderDate))),2) FROM Orders WHERE NOT ISNULL(ShippedDate) "></command></span><BR>Average time to ship - actual time of shipping for all product in the grid (filtered if any grid filter applied): <span style="color: red"><command sql="SELECT Round(AVG(IIF(ISNULL(ShippedDate),NULL, CDate(ShippedDate) - CDate(OrderDate))),2) FROM Orders [indoogrid:gridViewWhereClause]"></command></span><BR></font> htmlHeadBlock <style> input.gv_ff { background-color:#FFE89E; color: black; } select.gv_fl, select.gv_vl{ background-color:#FFE89E; color: black; } /*filter button*/ .gridView TD.gv_cd2 { color:black; padding: 5px 1px 0px 0px; } /*header row*/ TABLE TD.gv_hcc { font-weight: bold; background: #FFD000; background-image: none; background-repeat: no-repeat; } /*basic row*/ TD.gv_cc { padding: 7px 3px 3px 5px; background: #FFF8E0; } TD.gv_cc DIV { font-size: 12px; font-family: Georgia, Serif; } /*alternate row*/ TD.gv_cc2 { padding: 7px 3px 3px 5px; background: #FFE89E; } TD.gv_cc2 DIV { font-size: 12px; font-family: Georgia, Serif; } /*header link*/ TD.gv_hcc A, TD.gv_hcc A:hover, TD.gv_hcc A:active, TD.gv_hcc A:link, TD.gv_hcc A:visited { font-weight:bold; } /*all empty*/ TD#dnn_ctr640_ContentPane { background: #FFF8E0; } </style> startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord createKeyColumn gridViewColumn.0.columnName CustomerID gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridEditColumn.0.columnName CustomerID gridEditColumn.0.Visible on gridEditColumn.0.Autovalidator on gridViewColumn.1.columnName EmployeeID gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 3 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridEditColumn.1.columnName EmployeeID gridEditColumn.1.Visible on gridEditColumn.1.Autovalidator on gridViewColumn.2.columnName OrderDate gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 2 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridEditColumn.2.columnName OrderDate gridEditColumn.2.Visible on gridEditColumn.2.Autovalidator on gridViewColumn.3.columnName RequiredDate gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 3 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridEditColumn.3.columnName RequiredDate gridEditColumn.3.Visible on gridEditColumn.3.Autovalidator on gridViewColumn.6.columnName ShippedDate gridViewColumn.6.Visible on gridViewColumn.6.allowExport on gridViewColumn.6.allowEdit on gridViewColumn.6.allowFilter 1 gridViewColumn.6.allowSort on gridViewColumn.6.allowImport on gridEditColumn.4.columnName ShippedDate gridEditColumn.4.Visible on gridEditColumn.4.Autovalidator on gridViewColumn.7.columnName ShipVia gridViewColumn.7.Visible on gridViewColumn.7.allowExport on gridViewColumn.7.allowEdit on gridViewColumn.7.allowFilter 1 gridViewColumn.7.allowSort on gridViewColumn.7.allowImport on gridEditColumn.5.columnName ShipVia gridEditColumn.5.Visible on gridEditColumn.5.Autovalidator on gridViewColumn.8.columnName Freight gridViewColumn.8.Visible on gridViewColumn.8.allowExport on gridViewColumn.8.allowEdit on gridViewColumn.8.allowFilter 1 gridViewColumn.8.allowSort on gridViewColumn.8.allowImport on gridEditColumn.6.columnName Freight gridEditColumn.6.Visible on gridEditColumn.6.Autovalidator on gridViewColumn.9.columnName ShipName gridViewColumn.9.Visible gridViewColumn.9.allowExport on gridViewColumn.9.allowEdit on gridViewColumn.9.allowFilter 1 gridViewColumn.9.allowSort on gridViewColumn.9.allowImport on gridEditColumn.7.columnName ShipName gridEditColumn.7.Visible on gridEditColumn.7.Autovalidator on gridViewColumn.10.columnName ShipAddress gridViewColumn.10.Visible gridViewColumn.10.allowExport on gridViewColumn.10.allowEdit on gridViewColumn.10.allowFilter 1 gridViewColumn.10.allowSort on gridViewColumn.10.allowImport on gridEditColumn.8.columnName ShipAddress gridEditColumn.8.Visible on gridEditColumn.8.Autovalidator on gridViewColumn.11.columnName ShipCity gridViewColumn.11.Visible gridViewColumn.11.allowExport on gridViewColumn.11.allowEdit on gridViewColumn.11.allowFilter 1 gridViewColumn.11.allowSort on gridViewColumn.11.allowImport on gridEditColumn.9.columnName ShipCity gridEditColumn.9.Visible on gridEditColumn.9.Autovalidator on gridViewColumn.12.columnName ShipRegion gridViewColumn.12.Visible gridViewColumn.12.allowExport on gridViewColumn.12.allowEdit on gridViewColumn.12.allowFilter 1 gridViewColumn.12.allowSort on gridViewColumn.12.allowImport on gridEditColumn.10.columnName ShipRegion gridEditColumn.10.Visible on gridEditColumn.10.Autovalidator on gridViewColumn.13.columnName ShipPostalCode gridViewColumn.13.Visible gridViewColumn.13.allowExport on gridViewColumn.13.allowEdit on gridViewColumn.13.allowFilter 1 gridViewColumn.13.allowSort on gridViewColumn.13.allowImport on gridEditColumn.11.columnName ShipPostalCode gridEditColumn.11.Visible on gridEditColumn.11.Autovalidator on gridViewColumn.14.columnName ShipCountry gridViewColumn.14.Visible on gridViewColumn.14.allowExport on gridViewColumn.14.allowEdit on gridViewColumn.14.allowFilter 1 gridViewColumn.14.allowSort on gridViewColumn.14.allowImport on gridEditColumn.12.columnName ShipCountry gridEditColumn.12.Visible on gridEditColumn.12.Autovalidator on gridViewColumn.0.caption Customer gridViewColumn.0.width gridViewColumn.0.defaultContent gridViewColumn.0.formatData gridViewColumn.0.importDefault gridViewColumn.0.filterAdditionalColumn gridViewColumn.0.defaultSortColumn gridViewColumn.0.isBoolean gridViewColumn.0.isLink gridViewColumn.0.isOther gridViewColumn.0.isBinary gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.0.navigateUrlTarget _blank gridViewColumn.0.joinTableName Customers gridViewColumn.0.joinTableIdColumnName CustomerID gridViewColumn.0.joinTableColumnName CompanyName gridViewColumn.1.caption Employee gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isOther gridViewColumn.1.isBinary gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.navigateUrlTarget _blank gridViewColumn.1.joinTableName Employees gridViewColumn.1.joinTableIdColumnName EmployeeID gridViewColumn.1.joinTableColumnName LastName gridViewColumn.2.caption Order Date gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData d;en-us gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isOther gridViewColumn.2.isBinary gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes gridViewColumn.3.caption Required Date gridViewColumn.3.width gridViewColumn.3.defaultContent gridViewColumn.3.formatData d;en-us gridViewColumn.3.importDefault gridViewColumn.3.filterAdditionalColumn gridViewColumn.3.defaultSortColumn gridViewColumn.3.isBoolean gridViewColumn.3.isLink gridViewColumn.3.isOther gridViewColumn.3.isBinary gridViewColumn.3.isJoin gridViewColumn.3.isHtmlAttributes gridViewColumn.6.caption Shipped Date gridViewColumn.6.width gridViewColumn.6.defaultContent gridViewColumn.6.formatData d;en-us gridViewColumn.6.importDefault gridViewColumn.6.filterAdditionalColumn gridViewColumn.6.defaultSortColumn gridViewColumn.6.isBoolean gridViewColumn.6.isLink gridViewColumn.6.isOther gridViewColumn.6.isBinary gridViewColumn.6.isJoin gridViewColumn.6.isHtmlAttributes gridViewColumn.9.caption gridViewColumn.9.width gridViewColumn.9.defaultContent gridViewColumn.9.formatData gridViewColumn.9.importDefault gridViewColumn.9.filterAdditionalColumn gridViewColumn.9.defaultSortColumn gridViewColumn.9.isBoolean gridViewColumn.9.isLink gridViewColumn.9.isOther gridViewColumn.9.isBinary gridViewColumn.9.isJoin gridViewColumn.9.isHtmlAttributes gridViewColumn.10.caption gridViewColumn.10.width gridViewColumn.10.defaultContent gridViewColumn.10.formatData gridViewColumn.10.importDefault gridViewColumn.10.filterAdditionalColumn gridViewColumn.10.defaultSortColumn gridViewColumn.10.isBoolean gridViewColumn.10.isLink gridViewColumn.10.isOther gridViewColumn.10.isBinary gridViewColumn.10.isJoin gridViewColumn.10.isHtmlAttributes gridViewColumn.11.caption gridViewColumn.11.width gridViewColumn.11.defaultContent gridViewColumn.11.formatData gridViewColumn.11.importDefault gridViewColumn.11.filterAdditionalColumn gridViewColumn.11.defaultSortColumn gridViewColumn.11.isBoolean gridViewColumn.11.isLink gridViewColumn.11.isOther gridViewColumn.11.isBinary gridViewColumn.11.isJoin gridViewColumn.11.isHtmlAttributes gridViewColumn.12.caption gridViewColumn.12.width gridViewColumn.12.defaultContent gridViewColumn.12.formatData gridViewColumn.12.importDefault gridViewColumn.12.filterAdditionalColumn gridViewColumn.12.defaultSortColumn gridViewColumn.12.isBoolean gridViewColumn.12.isLink gridViewColumn.12.isOther gridViewColumn.12.isBinary gridViewColumn.12.isJoin gridViewColumn.12.isHtmlAttributes gridViewColumn.13.caption gridViewColumn.13.width gridViewColumn.13.defaultContent gridViewColumn.13.formatData gridViewColumn.13.importDefault gridViewColumn.13.filterAdditionalColumn gridViewColumn.13.defaultSortColumn gridViewColumn.13.isBoolean gridViewColumn.13.isLink gridViewColumn.13.isOther gridViewColumn.13.isBinary gridViewColumn.13.isJoin gridViewColumn.13.isHtmlAttributes gridViewColumn.7.caption Ship Via gridViewColumn.7.width gridViewColumn.7.defaultContent gridViewColumn.7.formatData gridViewColumn.7.importDefault gridViewColumn.7.filterAdditionalColumn gridViewColumn.7.defaultSortColumn gridViewColumn.7.isBoolean gridViewColumn.7.isLink gridViewColumn.7.isOther gridViewColumn.7.isBinary gridViewColumn.7.isJoin on gridViewColumn.7.isHtmlAttributes gridViewColumn.7.navigateUrlTarget _blank gridViewColumn.7.joinTableName Shippers gridViewColumn.7.joinTableIdColumnName ShipperID gridViewColumn.7.joinTableColumnName CompanyName gridViewColumn.14.caption Ship Country gridViewColumn.14.width gridViewColumn.14.defaultContent gridViewColumn.14.formatData gridViewColumn.14.importDefault gridViewColumn.14.filterAdditionalColumn gridViewColumn.14.defaultSortColumn gridViewColumn.14.isBoolean gridViewColumn.14.isLink gridViewColumn.14.isOther gridViewColumn.14.isBinary gridViewColumn.14.isJoin gridViewColumn.14.isHtmlAttributes gridViewColumn.4.Visible on gridViewColumn.4.allowExport gridViewColumn.4.allowEdit on gridViewColumn.4.allowFilter 0 gridViewColumn.4.allowSort gridViewColumn.4.allowImport gridViewColumn.4.columnName CustomerID gridViewColumn.4.caption Planned gridViewColumn.4.width gridViewColumn.4.defaultContent gridViewColumn.4.formatData gridViewColumn.4.importDefault gridViewColumn.4.filterAdditionalColumn gridViewColumn.4.defaultSortColumn gridViewColumn.4.isBoolean gridViewColumn.4.isLink gridViewColumn.4.isOther on gridViewColumn.4.isBinary gridViewColumn.4.isJoin gridViewColumn.4.isHtmlAttributes gridViewColumn.4.rowDataColumn.1 RequiredDate gridViewColumn.4.rowDataPrefix.1 <div align="center"><font color="blue"><script language="javascript"> var rd= Date.parse(' gridViewColumn.4.rowDataSuffix.1 '); gridViewColumn.4.rowDataRegexSearch.1 gridViewColumn.4.rowDataRegexReplace.1 gridViewColumn.4.rowDataConditionColumn.1 gridViewColumn.4.rowDataCondition.1 gridviewcolumn.13.rowdatahtmlencode.1 gridviewcolumn.13.rowdataurlencode.1 gridViewColumn.4.rowDataColumn.2 OrderDate gridViewColumn.4.rowDataPrefix.2 var od=Date.parse(' gridViewColumn.4.rowDataSuffix.2 ');var d=((rd-od)/86400000); d=d.toFixed(0);document.write(d);</script></font></div> gridViewColumn.4.rowDataRegexSearch.2 gridViewColumn.4.rowDataRegexReplace.2 gridViewColumn.4.rowDataConditionColumn.2 gridViewColumn.4.rowDataCondition.2 gridviewcolumn.13.rowdatahtmlencode.2 gridviewcolumn.13.rowdataurlencode.2 gridViewColumn.4.rowDataColumn.3 gridViewColumn.4.rowDataPrefix.3 gridViewColumn.4.rowDataSuffix.3 gridViewColumn.4.rowDataRegexSearch.3 gridViewColumn.4.rowDataRegexReplace.3 gridViewColumn.4.rowDataConditionColumn.3 gridViewColumn.4.rowDataCondition.3 gridviewcolumn.13.rowdatahtmlencode.3 gridviewcolumn.13.rowdataurlencode.3 gridViewColumn.4.rowDataColumn.4 gridViewColumn.4.rowDataPrefix.4 gridViewColumn.4.rowDataSuffix.4 gridViewColumn.4.rowDataRegexSearch.4 gridViewColumn.4.rowDataRegexReplace.4 gridViewColumn.4.rowDataConditionColumn.4 gridViewColumn.4.rowDataCondition.4 gridviewcolumn.13.rowdatahtmlencode.4 gridviewcolumn.13.rowdataurlencode.4 gridViewColumn.4.rowDataColumn.5 gridViewColumn.4.rowDataPrefix.5 gridViewColumn.4.rowDataSuffix.5 gridViewColumn.4.rowDataRegexSearch.5 gridViewColumn.4.rowDataRegexReplace.5 gridViewColumn.4.rowDataConditionColumn.5 gridViewColumn.4.rowDataCondition.5 gridviewcolumn.13.rowdatahtmlencode.5 gridviewcolumn.13.rowdataurlencode.5 gridViewColumn.4.rowDataColumn.6 gridViewColumn.4.rowDataPrefix.6 gridViewColumn.4.rowDataSuffix.6 gridViewColumn.4.rowDataRegexSearch.6 gridViewColumn.4.rowDataRegexReplace.6 gridViewColumn.4.rowDataConditionColumn.6 gridViewColumn.4.rowDataCondition.6 gridviewcolumn.13.rowdatahtmlencode.6 gridviewcolumn.13.rowdataurlencode.6 gridViewColumn.4.rowDataColumn.7 gridViewColumn.4.rowDataPrefix.7 gridViewColumn.4.rowDataSuffix.7 gridViewColumn.4.rowDataRegexSearch.7 gridViewColumn.4.rowDataRegexReplace.7 gridViewColumn.4.rowDataConditionColumn.7 gridViewColumn.4.rowDataCondition.7 gridviewcolumn.13.rowdatahtmlencode.7 gridviewcolumn.13.rowdataurlencode.7 gridViewColumn.4.rowDataColumn.8 gridViewColumn.4.rowDataPrefix.8 gridViewColumn.4.rowDataSuffix.8 gridViewColumn.4.rowDataRegexSearch.8 gridViewColumn.4.rowDataRegexReplace.8 gridViewColumn.4.rowDataConditionColumn.8 gridViewColumn.4.rowDataCondition.8 gridviewcolumn.13.rowdatahtmlencode.8 gridviewcolumn.13.rowdataurlencode.8 gridViewColumn.4.rowDataColumn.9 gridViewColumn.4.rowDataPrefix.9 gridViewColumn.4.rowDataSuffix.9 gridViewColumn.4.rowDataRegexSearch.9 gridViewColumn.4.rowDataRegexReplace.9 gridViewColumn.4.rowDataConditionColumn.9 gridViewColumn.4.rowDataCondition.9 gridviewcolumn.13.rowdatahtmlencode.9 gridviewcolumn.13.rowdataurlencode.9 gridViewColumn.4.rowDataColumn.10 gridViewColumn.4.rowDataPrefix.10 gridViewColumn.4.rowDataSuffix.10 gridViewColumn.4.rowDataRegexSearch.10 gridViewColumn.4.rowDataRegexReplace.10 gridViewColumn.4.rowDataConditionColumn.10 gridViewColumn.4.rowDataCondition.10 gridviewcolumn.13.rowdatahtmlencode.10 gridviewcolumn.13.rowdataurlencode.10 gridviewcolumn.4.rowdatahtmlencode.1 gridviewcolumn.4.rowdataurlencode.1 gridviewcolumn.4.rowdatahtmlencode.2 gridviewcolumn.4.rowdataurlencode.2 gridviewcolumn.4.rowdatahtmlencode.3 gridviewcolumn.4.rowdataurlencode.3 gridviewcolumn.4.rowdatahtmlencode.4 gridviewcolumn.4.rowdataurlencode.4 gridviewcolumn.4.rowdatahtmlencode.5 gridviewcolumn.4.rowdataurlencode.5 gridviewcolumn.4.rowdatahtmlencode.6 gridviewcolumn.4.rowdataurlencode.6 gridviewcolumn.4.rowdatahtmlencode.7 gridviewcolumn.4.rowdataurlencode.7 gridviewcolumn.4.rowdatahtmlencode.8 gridviewcolumn.4.rowdataurlencode.8 gridviewcolumn.4.rowdatahtmlencode.9 gridviewcolumn.4.rowdataurlencode.9 gridviewcolumn.4.rowdatahtmlencode.10 gridviewcolumn.4.rowdataurlencode.10 gridViewColumn.5.Visible on gridViewColumn.5.allowExport gridViewColumn.5.allowEdit gridViewColumn.5.allowFilter 0 gridViewColumn.5.allowSort gridViewColumn.5.allowImport gridViewColumn.5.columnName CustomerID gridViewColumn.5.caption Actual gridViewColumn.5.width gridViewColumn.5.defaultContent gridViewColumn.5.formatData gridViewColumn.5.importDefault gridViewColumn.5.filterAdditionalColumn gridViewColumn.5.defaultSortColumn gridViewColumn.5.isBoolean gridViewColumn.5.isLink gridViewColumn.5.isOther on gridViewColumn.5.isBinary gridViewColumn.5.isJoin gridViewColumn.5.isHtmlAttributes gridViewColumn.5.rowDataColumn.1 OrderDate gridViewColumn.5.rowDataPrefix.1 <div align="center"><font color="blue"><script language="javascript"> var od= Date.parse(' gridViewColumn.5.rowDataSuffix.1 '); gridViewColumn.5.rowDataRegexSearch.1 gridViewColumn.5.rowDataRegexReplace.1 gridViewColumn.5.rowDataConditionColumn.1 ShippedDate gridViewColumn.5.rowDataCondition.1 <> gridviewcolumn.14.rowdatahtmlencode.1 gridviewcolumn.14.rowdataurlencode.1 gridViewColumn.5.rowDataColumn.2 ShippedDate gridViewColumn.5.rowDataPrefix.2 var sd=Date.parse(' gridViewColumn.5.rowDataSuffix.2 ');var d1=((sd-od)/86400000);d1=d1.toFixed(0);document.write(d1);</script></font></div> gridViewColumn.5.rowDataRegexSearch.2 gridViewColumn.5.rowDataRegexReplace.2 gridViewColumn.5.rowDataConditionColumn.2 ShippedDate gridViewColumn.5.rowDataCondition.2 <> gridviewcolumn.14.rowdatahtmlencode.2 gridviewcolumn.14.rowdataurlencode.2 gridViewColumn.5.rowDataColumn.3 gridViewColumn.5.rowDataPrefix.3 <div align="center"><font color="red">n/a</font></div> gridViewColumn.5.rowDataSuffix.3 gridViewColumn.5.rowDataRegexSearch.3 gridViewColumn.5.rowDataRegexReplace.3 gridViewColumn.5.rowDataConditionColumn.3 ShippedDate gridViewColumn.5.rowDataCondition.3 = gridviewcolumn.14.rowdatahtmlencode.3 gridviewcolumn.14.rowdataurlencode.3 gridViewColumn.5.rowDataColumn.4 gridViewColumn.5.rowDataPrefix.4 gridViewColumn.5.rowDataSuffix.4 gridViewColumn.5.rowDataRegexSearch.4 gridViewColumn.5.rowDataRegexReplace.4 gridViewColumn.5.rowDataConditionColumn.4 gridViewColumn.5.rowDataCondition.4 gridviewcolumn.14.rowdatahtmlencode.4 gridviewcolumn.14.rowdataurlencode.4 gridViewColumn.5.rowDataColumn.5 gridViewColumn.5.rowDataPrefix.5 gridViewColumn.5.rowDataSuffix.5 gridViewColumn.5.rowDataRegexSearch.5 gridViewColumn.5.rowDataRegexReplace.5 gridViewColumn.5.rowDataConditionColumn.5 gridViewColumn.5.rowDataCondition.5 gridviewcolumn.14.rowdatahtmlencode.5 gridviewcolumn.14.rowdataurlencode.5 gridViewColumn.5.rowDataColumn.6 gridViewColumn.5.rowDataPrefix.6 gridViewColumn.5.rowDataSuffix.6 gridViewColumn.5.rowDataRegexSearch.6 gridViewColumn.5.rowDataRegexReplace.6 gridViewColumn.5.rowDataConditionColumn.6 gridViewColumn.5.rowDataCondition.6 gridviewcolumn.14.rowdatahtmlencode.6 gridviewcolumn.14.rowdataurlencode.6 gridViewColumn.5.rowDataColumn.7 gridViewColumn.5.rowDataPrefix.7 gridViewColumn.5.rowDataSuffix.7 gridViewColumn.5.rowDataRegexSearch.7 gridViewColumn.5.rowDataRegexReplace.7 gridViewColumn.5.rowDataConditionColumn.7 gridViewColumn.5.rowDataCondition.7 gridviewcolumn.14.rowdatahtmlencode.7 gridviewcolumn.14.rowdataurlencode.7 gridViewColumn.5.rowDataColumn.8 gridViewColumn.5.rowDataPrefix.8 gridViewColumn.5.rowDataSuffix.8 gridViewColumn.5.rowDataRegexSearch.8 gridViewColumn.5.rowDataRegexReplace.8 gridViewColumn.5.rowDataConditionColumn.8 gridViewColumn.5.rowDataCondition.8 gridviewcolumn.14.rowdatahtmlencode.8 gridviewcolumn.14.rowdataurlencode.8 gridViewColumn.5.rowDataColumn.9 gridViewColumn.5.rowDataPrefix.9 gridViewColumn.5.rowDataSuffix.9 gridViewColumn.5.rowDataRegexSearch.9 gridViewColumn.5.rowDataRegexReplace.9 gridViewColumn.5.rowDataConditionColumn.9 gridViewColumn.5.rowDataCondition.9 gridviewcolumn.14.rowdatahtmlencode.9 gridviewcolumn.14.rowdataurlencode.9 gridViewColumn.5.rowDataColumn.10 gridViewColumn.5.rowDataPrefix.10 gridViewColumn.5.rowDataSuffix.10 gridViewColumn.5.rowDataRegexSearch.10 gridViewColumn.5.rowDataRegexReplace.10 gridViewColumn.5.rowDataConditionColumn.10 gridViewColumn.5.rowDataCondition.10 gridviewcolumn.14.rowdatahtmlencode.10 gridviewcolumn.14.rowdataurlencode.10 gridviewcolumn.5.rowdatahtmlencode.1 gridviewcolumn.5.rowdataurlencode.1 gridviewcolumn.5.rowdatahtmlencode.2 gridviewcolumn.5.rowdataurlencode.2 gridviewcolumn.5.rowdatahtmlencode.3 gridviewcolumn.5.rowdataurlencode.3 gridviewcolumn.5.rowdatahtmlencode.4 gridviewcolumn.5.rowdataurlencode.4 gridviewcolumn.5.rowdatahtmlencode.5 gridviewcolumn.5.rowdataurlencode.5 gridviewcolumn.5.rowdatahtmlencode.6 gridviewcolumn.5.rowdataurlencode.6 gridviewcolumn.5.rowdatahtmlencode.7 gridviewcolumn.5.rowdataurlencode.7 gridviewcolumn.5.rowdatahtmlencode.8 gridviewcolumn.5.rowdataurlencode.8 gridviewcolumn.5.rowdatahtmlencode.9 gridviewcolumn.5.rowdataurlencode.9 gridviewcolumn.5.rowdatahtmlencode.10 gridviewcolumn.5.rowdataurlencode.10 gridEditColumn.4.caption gridEditColumn.4.separator gridEditColumn.4.helpText gridEditColumn.4.Readonly gridEditColumn.4.isHtmlAttributes version 02.00.12 gridViewColumn.6.ddlType 2 gridViewColumn.6.ddlList gridViewColumn.6.ddlDefaultValue gridViewColumn.6.ddlNullText gridViewColumn.6.ddlSortById gridViewColumn.6.ddlAllOption on gridViewColumn.3.ddlType 2 gridViewColumn.3.ddlList <>00;All time >=1/1/2007;This year >6/10/2007;Last month >7/3/2007;Last week >=7/11/2007;Today gridViewColumn.3.ddlDefaultValue >1/1/1900 gridViewColumn.3.ddlNullText gridViewColumn.3.ddlSortById gridViewColumn.3.ddlAllOption gridViewColumn.0.ddlType 1 gridViewColumn.0.ddlTable Customers gridViewColumn.0.ddlSQLWhere gridViewColumn.0.sourceValueColumnName CustomerID gridViewColumn.0.sourceTextColumnName CompanyName gridViewColumn.0.ddlDefaultValue gridViewColumn.0.ddlNullText gridViewColumn.0.ddlSortById gridViewColumn.0.ddlAllOption on gridViewColumn.1.ddlType 1 gridViewColumn.1.ddlList 1;First 2;Second 3;Third 4;Fourth gridViewColumn.1.ddlDefaultValue gridViewColumn.1.ddlNullText gridViewColumn.1.ddlSortById gridViewColumn.1.ddlAllOption on gridViewColumn.7.ddlType 1 gridViewColumn.7.ddlTable Shippers gridViewColumn.7.ddlSQLWhere gridViewColumn.7.sourceValueColumnName ShipperID gridViewColumn.7.sourceTextColumnName CompanyName gridViewColumn.7.ddlDefaultValue gridViewColumn.7.ddlNullText gridViewColumn.7.ddlSortById gridViewColumn.7.ddlAllOption gridViewColumn.3.filterAutoFire on gridViewColumn.15.Visible gridViewColumn.15.allowExport gridViewColumn.15.allowEdit gridViewColumn.15.allowFilter 0 gridViewColumn.15.allowSort gridViewColumn.15.allowImport gridViewColumn.15.columnName Freight gridViewColumn.15.caption Search all fields gridViewColumn.15.width gridViewColumn.15.defaultContent gridViewColumn.15.formatData gridViewColumn.15.importDefault gridViewColumn.15.filterAdditionalColumn CustomerID gridViewColumn.15.defaultSortColumn gridViewColumn.15.isBoolean gridViewColumn.15.isLink gridViewColumn.15.isOther gridViewColumn.15.isBinary gridViewColumn.15.isJoin gridViewColumn.15.isHtmlAttributes gridViewColumn.8.caption Freight gridViewColumn.8.width gridViewColumn.8.defaultContent gridViewColumn.8.formatData gridViewColumn.8.importDefault gridViewColumn.8.filterAdditionalColumn gridViewColumn.8.defaultSortColumn gridViewColumn.8.isBoolean gridViewColumn.8.isLink gridViewColumn.8.isOther gridViewColumn.8.isBinary gridViewColumn.8.isJoin gridViewColumn.8.isHtmlAttributes gridViewColumn.16.Visible gridViewColumn.16.allowExport gridViewColumn.16.allowEdit gridViewColumn.16.allowFilter 2 gridViewColumn.16.allowSort gridViewColumn.16.allowImport gridViewColumn.16.columnName CustomerID gridViewColumn.16.caption Search all fields gridViewColumn.16.width gridViewColumn.16.defaultContent gridViewColumn.16.formatData gridViewColumn.16.importDefault gridViewColumn.16.filterAdditionalColumn Emploxee,Order Date,Required Date, Shipped Date, Ship Via,Freight,Ship Country gridViewColumn.16.defaultSortColumn gridViewColumn.16.isBoolean gridViewColumn.16.isLink gridViewColumn.16.isOther gridViewColumn.16.isBinary gridViewColumn.16.isJoin gridViewColumn.16.isHtmlAttributes gridedit.isgridvieweditredirected gridViewColumn.1.filterAutoFire on gridViewColumn.1.ddlTable Employees gridViewColumn.1.ddlSQLWhere gridViewColumn.1.sourceValueColumnName EmployeeID gridViewColumn.1.sourceTextColumnName FirstName gridViewColumn.2.filterDateAsWholeDayRange on gridViewColumn.2.dateTimePicker 2 gridViewColumn.6.filterDateAsWholeDayRange on gridViewColumn.6.dateTimePicker 2 gridViewColumn.3.filterDateAsWholeDayRange on gridView.hideElement 0 gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit_customHTMLForm gridEditColumn.0.multiplePage 1 gridEditColumn.0.caption gridEditColumn.0.Readonly gridEditColumn.1.multiplePage 1 gridEditColumn.1.caption gridEditColumn.1.Readonly gridEditColumn.2.multiplePage 1 gridEditColumn.2.caption gridEditColumn.2.Readonly gridEditColumn.3.multiplePage 1 gridEditColumn.3.caption gridEditColumn.3.Readonly gridEditColumn.4.multiplePage 1 gridEditColumn.5.multiplePage 1 gridEditColumn.5.caption gridEditColumn.5.Readonly gridEditColumn.6.multiplePage 1 gridEditColumn.6.caption gridEditColumn.6.Readonly gridEditColumn.7.multiplePage 1 gridEditColumn.7.caption gridEditColumn.7.Readonly gridEditColumn.8.multiplePage 1 gridEditColumn.8.caption gridEditColumn.8.Readonly gridEditColumn.9.multiplePage 1 gridEditColumn.9.caption gridEditColumn.9.Readonly gridEditColumn.10.multiplePage 1 gridEditColumn.10.caption gridEditColumn.10.Readonly gridEditColumn.11.multiplePage 1 gridEditColumn.11.caption gridEditColumn.11.Readonly gridEditColumn.12.multiplePage 1 gridEditColumn.12.caption gridEditColumn.12.Readonly isEmptyCaptionReplaced on gridview.ispagenumbertextbox gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter sqlOnUpdateFinishRecord notSkipSqlOnImport on showGridView on showGridEdit on gridview.sqlstatementquery