or

<telerik:RadGrid AutoGenerateColumns="False" ID="RadGrid1" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" runat="server" OnItemCommand="RadGrid1_ItemCommand" OnItemCreated="RadGrid1_ItemCreated" EnableLinqExpressions="true" HtmlEncode="true" OnNeedDataSource="RadGrid1_NeedDataSource" GroupByExpression="JobStatusID Group By JobStatusID" ShowGroupPanel="True" CellSpacing="-1" GridLines="Both" Skin="Office2010Silver" EnableViewState="true" Width="100%"> <PagerStyle Mode="NextPrevAndNumeric" /> <GroupingSettings CaseSensitive="false" /> <ClientSettings AllowKeyboardNavigation="true"> </ClientSettings> <ExportSettings OpenInNewWindow="true" FileName="i-Dispatch General Report"> <Pdf PageHeight="210mm" PageWidth="297mm" DefaultFontFamily="Arial Unicode MS" PageTopMargin="45mm" BorderStyle="Medium" BorderColor="#666666" PaperSize="A4"> </Pdf> </ExportSettings> <MasterTableView Width="100%" DataKeyNames="JobID" HierarchyLoadMode="ServerOnDemand"> <Columns> <telerik:GridMaskedColumn DataField="JobID" HeaderText="JobID#" FilterControlWidth="50px" AutoPostBackOnFilter="false" CurrentFilterFunction="EqualTo" FilterDelay="2000" ShowFilterIcon="false" Mask="#####"> <ColumnValidationSettings> <ModelErrorMessage Text=""></ModelErrorMessage> </ColumnValidationSettings> </telerik:GridMaskedColumn> <telerik:GridBoundColumn HeaderText="Customer Ref No" DataField="JobCustomerRefNo" UniqueName="JobCustomerRefNo" SortExpression="JobCustomerRefNo" HeaderStyle-Width="180px" FilterControlAltText="Filter JobCustomerRefNo column"> <ColumnValidationSettings> <ModelErrorMessage Text=""></ModelErrorMessage> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="JobTitle" FilterControlAltText="Filter JobTitle column" HeaderText="Job Title" SortExpression="JobTitle" UniqueName="JobTitle"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn DataField="JobBookedDate" PickerType="DatePicker" EnableTimeIndependentFiltering="true" DataFormatString="{0:dd/MM/yyyy HH:mm }" DataType="System.DateTime" FilterControlAltText="Filter JobBookedDate column" HeaderText="Job Booked Date" SortExpression="JobBookedDate" UniqueName="JobBookedDate"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridDateTimeColumn> <telerik:GridBoundColumn DataField="JobAddress1" FilterControlAltText="Filter JobAddress1 column" HeaderText="Address" SortExpression="JobAddress1" UniqueName="JobAddress1"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="JobSuburb" FilterControlAltText="Filter JobSuburb column" HeaderText="Suburb" SortExpression="JobSuburb" UniqueName="JobSuburb"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="JobPostCode" FilterControlAltText="Filter JobPostCode column" HeaderText="PostCode" SortExpression="JobPostCode" UniqueName="JobPostCode"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="JobState" FilterControlAltText="Filter JobState column" HeaderText="State" SortExpression="JobState" UniqueName="JobState"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridTemplateColumn DataField="JobStatusID" HeaderText="Status Type" UniqueName="JobStatusID" HeaderStyle-Width="200px" SortExpression="JobStatusID"> <FilterTemplate> <telerik:RadComboBox ID="comboJobStatus" DataTextField="JobStatusName" DataValueField="JobStatusID" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("JobStatusID").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="JobStatusIndexChanged"> <Items> <telerik:RadComboBoxItem Text="All" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server"> <script type="text/javascript"> function JobStatusIndexChanged(sender, args) { var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); tableView.filter("JobStatusID", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> <ItemTemplate> <%# Eval("JobStatus") %> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="ClientID" HeaderText="Client" UniqueName="ClientID" HeaderStyle-Width="200px" SortExpression="ClientID"> <FilterTemplate> <telerik:RadComboBox ID="comboClient" DataTextField="ClientName" DataValueField="ClientID" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ClientID").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="ClientIndexChanged"> <Items> <telerik:RadComboBoxItem Text="All" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server"> <script type="text/javascript"> function ClientIndexChanged(sender, args) { var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); tableView.filter("ClientID", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> <ItemTemplate> <%# Eval("Client") %> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="AssignedStaffID" HeaderText="Staff" UniqueName="AssignedStaffID" HeaderStyle-Width="200px" SortExpression="AssignedStaffID"> <FilterTemplate> <telerik:RadComboBox ID="comboStaff" DataTextField="StaffName" DataValueField="StaffID" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssignedStaffID").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="StaffIndexChanged"> <Items> <telerik:RadComboBoxItem Text="All" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock10" runat="server"> <script type="text/javascript"> function StaffIndexChanged(sender, args) { var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); tableView.filter("AssignedStaffID", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> <ItemTemplate> <%# Eval("AssignedStaff") %> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <NestedViewTemplate> <asp:Panel runat="server" ID="InnerContainer" CssClass="viewWrap" Visible="false"> <telerik:RadGrid runat="server" ID="JobStatusGrid" OnNeedDataSource="JobStatusGrid_NeedDataSource"> <MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true" DataKeyNames="JobStatusHistoryID" PageSize="7" HierarchyLoadMode="Client"> <Columns> <telerik:GridBoundColumn HeaderText="Status Type" HeaderButtonType="TextButton" DataField="JobStatus" UniqueName="JobStatusID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Created By" HeaderButtonType="TextButton" DataField="CreatedBy" UniqueName="CreatedBy"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Created On" HeaderButtonType="TextButton" DataField="CreatedOn" UniqueName="CreatedOn"> </telerik:GridBoundColumn> </Columns> </MasterTableView> </telerik:RadGrid> </asp:Panel> </NestedViewTemplate> </MasterTableView> <ClientSettings AllowDragToGroup="true"> <Scrolling AllowScroll="True" UseStaticHeaders="True" /> </ClientSettings> </telerik:RadGrid>protected void btnGeneralReportPDF_Click(object sender, ImageClickEventArgs e) { //RadGrid1.ExportSettings.ExportOnlyData = true; RadGrid1.ExportSettings.OpenInNewWindow = true; //RadGrid1.ExportSettings.IgnorePaging = true; headerMiddleCell = headerMiddleCell.Replace("<$companyname$>", "company name"); headerMiddleCell = headerMiddleCell.Replace("<$reportname$>", "Report"); headerMiddleCell = headerMiddleCell.Replace("<$daterange$>", "1-1-2015 / 2-2-2015"); RadGrid1.ExportSettings.Pdf.PageHeader.MiddleCell.Text = headerMiddleCell; // to get lanscape orientation RadGrid1.ExportSettings.Pdf.PageHeight = Unit.Parse("162mm"); RadGrid1.ExportSettings.Pdf.PageWidth = Unit.Parse("600mm"); foreach (GridDataItem gi in RadGrid1.MasterTableView.Items) { gi.Expanded = true; if (gi.HasChildItems) { RadGrid rgHeader = (RadGrid)gi.ChildItem.NestedViewCell.Controls[0].Controls[1].Controls[1]; rgHeader.Rebind(); } } RadGrid1.MasterTableView.HierarchyDefaultExpanded = true; //RadGrid1.Rebind(); RadGrid1.MasterTableView.ExportToPdf(); }001.<telerik:RadGrid ID="radProject3" runat="server"002. AutoGenerateColumns="False"003. AllowSorting="True"004. AllowPaging="True"005. ShowFooter="True"006. ShowGroupPanel="true"007. AllowFilteringByColumn="False"008. EnableGroupsExpandAll="True"009. EnableHeaderContextMenu="true"010. EnableHeaderContextFilterMenu="False"011. CellSpacing="0"012. PageSize="25"013. >014. <ExportSettings HideStructureColumns="true"015. ExportOnlyData="true"016. IgnorePaging="true"017. OpenInNewWindow="true"018. FileName="TaskSheet"019. >020. <Csv RowDelimiter="Tab" />021. <Excel Format="Html" AutoFitImages="true" />022. <Pdf FontType="Link" ForceTextWrap="true" BorderColor="#000000" BorderStyle="Thin" BorderType="AllBorders" DefaultFontFamily="Arial" >023. <PageHeader>024. <LeftCell Text="" TextAlign="Left" />025. <RightCell Text="" TextAlign="Right" />026. </PageHeader>027. </Pdf>028. </ExportSettings>029. <MasterTableView DataKeyNames="FullJobNo, t_Briefno, t_BriefVersionNo, t_BriefRevisionNo"030. ClientDataKeyNames="FullJobNo, t_Briefno, t_BriefVersionNo, t_BriefRevisionNo"031. AllowMultiColumnSorting="True"032. EnableHierarchyExpandAll="true"033. GroupLoadMode="Server"034. Name="ARMPROJECT"035. FilterItemStyle-Height="10px"036. CommandItemDisplay="top"037. CommandItemStyle-Height="5px"038. >039. <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" PageSizes="{20, 25, 50, 75, 100, 200, 250, 500, 750, 1000, 1000}"></PagerStyle>040. <GroupByExpressions>041. <telerik:GridGroupByExpression>042. <SelectFields>043. <telerik:GridGroupByField FieldName="assignedto" HeaderText="Assigned To" />044. </SelectFields>045. <GroupByFields>046. <telerik:GridGroupByField FieldName="assignedto" SortOrder="Ascending" />047. </GroupByFields>048. </telerik:GridGroupByExpression>049. </GroupByExpressions>050. <CommandItemSettings051. ShowExportToExcelButton="false"052. ShowRefreshButton="true"053. ShowAddNewRecordButton="false" />054. <Columns>055. <telerik:GridTemplateColumn DataField="Fav" GroupByExpression="Fav Group By Fav" UniqueName="Fav" HeaderText="Fav" SortExpression="Fav" ItemStyle-Width="16px" AllowFiltering="false" HeaderStyle-Width="16px">056. <ItemTemplate>057. <asp:ImageButton runat="server" ID="ImgFav" ImageUrl='<%# String.Format("~/images/icons/{0}", Eval("imgFav"))%>' Width="16px" Height="16px" />058. <asp:HiddenField runat="server" ID="hdnFav" Value='<%#Eval("Fav") %>' />059. <asp:HiddenField runat="server" ID="hdnIntRev" Value='<%#Eval("InternalReview1") %>' />060. <asp:HiddenField runat="server" ID="hdnClPr" Value='<%#Eval("ClientPresentation1") %>' />061. <asp:HiddenField runat="server" ID="hdnDead" Value='<%#Eval("Deadline1") %>' />062. </ItemTemplate>063. </telerik:GridTemplateColumn>064. <telerik:GridBoundColumn DataField="FavText" UniqueName="FavText" HeaderText="Fav" SortExpression="FavText" AllowFiltering="false" Visible="false" ItemStyle-Width="30px" HeaderStyle-Width="30px">065. <ColumnValidationSettings>066. <ModelErrorMessage Text=""></ModelErrorMessage>067. </ColumnValidationSettings>068. </telerik:GridBoundColumn>069. <telerik:GridBoundColumn DataField="FullJobNo" UniqueName="FullJobNo" HeaderText="Job No" SortExpression="FullJobNo" ItemStyle-Width="90px" AllowFiltering="false">070. <ColumnValidationSettings>071. <ModelErrorMessage Text=""></ModelErrorMessage>072. </ColumnValidationSettings>073. </telerik:GridBoundColumn>074. <telerik:GridTemplateColumn GroupByExpression="FullBriefNo Group By FullBriefNo" UniqueName="FullBriefNo" HeaderText="Brief No" SortExpression="FullBriefNo" AllowFiltering="false" ItemStyle-Width="70px">075. <ItemTemplate>076. <asp:Label runat="server" ID="lblFullBriefNoWithD" Text='<%#Eval("FullBriefNoWithD")%>' Width="70px"></asp:Label>077. <asp:Label runat="server" ID="lblFullBriefNo" Text='<%#Eval("FullBriefNo") %>' Visible="false"></asp:Label>078. <asp:HiddenField runat="server" ID="hdnCostCentreCode" Value='<%#Eval("t_costcentrecode") %>' />079. </ItemTemplate>080. </telerik:GridTemplateColumn>081. <telerik:GridBoundColumn DataField="t_BriefType" UniqueName="t_BriefType" HeaderText="Brief Type" SortExpression="t_BriefType" AllowFiltering="false">082. <ColumnValidationSettings>083. <ModelErrorMessage Text=""></ModelErrorMessage>084. </ColumnValidationSettings>085. </telerik:GridBoundColumn>086. <telerik:GridBoundColumn DataField="t_briefdescription" UniqueName="t_briefdescription" HeaderText="Brief Title" SortExpression="t_briefdescription" AllowFiltering="false"087. ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left">088. <ColumnValidationSettings>089. <ModelErrorMessage Text=""></ModelErrorMessage>090. </ColumnValidationSettings>091. </telerik:GridBoundColumn>092. <telerik:GridBoundColumn DataField="t_jobdescription" UniqueName="t_jobdescription" HeaderText="Job Description" SortExpression="t_jobdescription" AllowFiltering="false"093. ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" HeaderStyle-width="200px">094. <ColumnValidationSettings>095. <ModelErrorMessage Text=""></ModelErrorMessage>096. </ColumnValidationSettings>097. </telerik:GridBoundColumn>098. <telerik:GridBoundColumn DataField="brieffeed" UniqueName="t_brieffeed" HeaderText="Feed" SortExpression="brieffeed" AllowFiltering="false">099. <ColumnValidationSettings>100. <ModelErrorMessage Text=""></ModelErrorMessage>101. </ColumnValidationSettings>102. </telerik:GridBoundColumn>103. <telerik:GridBoundColumn DataField="t_taskname" UniqueName="t_taskname" HeaderText="Task Name" SortExpression="t_taskname" AllowFiltering="false">104. <ColumnValidationSettings>105. <ModelErrorMessage Text=""></ModelErrorMessage>106. </ColumnValidationSettings>107. </telerik:GridBoundColumn>108. <telerik:GridBoundColumn DataField="assignedto" UniqueName="t_assignedto" HeaderText="Assigned To" SortExpression="assignedto" AllowFiltering="false">109. <ColumnValidationSettings>110. <ModelErrorMessage Text=""></ModelErrorMessage>111. </ColumnValidationSettings>112. </telerik:GridBoundColumn>113. <telerik:GridBoundColumn DataField="ClientName" UniqueName="ClientName" HeaderText="Client Name" SortExpression="ClientName" AllowFiltering="false">114. <ColumnValidationSettings>115. <ModelErrorMessage Text=""></ModelErrorMessage>116. </ColumnValidationSettings>117. </telerik:GridBoundColumn>118. <telerik:GridBoundColumn DataField="BrandName" UniqueName="BrandName" HeaderText="Brand Name" SortExpression="BrandName" AllowFiltering="false">119. <ColumnValidationSettings>120. <ModelErrorMessage Text=""></ModelErrorMessage>121. </ColumnValidationSettings>122. </telerik:GridBoundColumn>123. <telerik:GridTemplateColumn GroupByExpression="t_OriginalFileName Group By t_OriginalFileName" UniqueName="t_FileName" HeaderText="File Name" SortExpression="t_OriginalFileName"124. AllowFiltering="false"125. Exportable="false">126. <ItemTemplate>127. <%-- <asp:LinkButton runat="server" ID="lnkViewFile" OnClick="lnkViewFile_Click" Text='<%#Eval("t_FileName") %>'></asp:LinkButton>--%>128. <asp:Label runat="server" ID="lblViewFile" Text='<%#Eval("t_OriginalFileName")%>' Visible="true" ></asp:Label>129. </ItemTemplate>130. </telerik:GridTemplateColumn>131. <telerik:GridBoundColumn DataField="InternalReview" UniqueName="InternalReview" HeaderText="Internal Review" SortExpression="InternalReview1" AllowFiltering="false"132. HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left">133. <ColumnValidationSettings>134. <ModelErrorMessage Text=""></ModelErrorMessage>135. </ColumnValidationSettings>136. </telerik:GridBoundColumn>137. <telerik:GridBoundColumn DataField="Deadline" UniqueName="Deadline" HeaderText="Deadline" SortExpression="Deadline1" AllowFiltering="false"138. HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left">139. <ColumnValidationSettings>140. <ModelErrorMessage Text=""></ModelErrorMessage>141. </ColumnValidationSettings>142. </telerik:GridBoundColumn>143. <telerik:GridBoundColumn DataField="ClientPresentation" UniqueName="ClientPresentation" HeaderText="Client Presentation" SortExpression="ClientPresentation1" AllowFiltering="false"144. HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left">145. <ColumnValidationSettings>146. <ModelErrorMessage Text=""></ModelErrorMessage>147. </ColumnValidationSettings>148. </telerik:GridBoundColumn>149. <telerik:GridBoundColumn DataField="t_UploadedBy" UniqueName="t_UploadedBy" HeaderText="Created By" SortExpression="t_UploadedBy" AllowFiltering="false">150. <ColumnValidationSettings>151. <ModelErrorMessage Text=""></ModelErrorMessage>152. </ColumnValidationSettings>153. </telerik:GridBoundColumn>154. <telerik:GridBoundColumn DataField="t_UploadedOn" UniqueName="t_UploadedOn" HeaderText="Created Date" SortExpression="t_UploadedOn" DataFormatString="{0:dd-MM-yyyy HH:mm:ss}" AllowFiltering="false" ItemStyle-Width="110px">155. <ColumnValidationSettings>156. <ModelErrorMessage Text=""></ModelErrorMessage>157. </ColumnValidationSettings>158. </telerik:GridBoundColumn>159. <telerik:GridBoundColumn DataField="t_ApprovalStatus" UniqueName="t_ApprovalStatus" HeaderText="Brief Status" SortExpression="t_ApprovalStatus" AllowFiltering="false">160. <ColumnValidationSettings>161. <ModelErrorMessage Text=""></ModelErrorMessage>162. </ColumnValidationSettings>163. </telerik:GridBoundColumn>164. <telerik:GridBoundColumn DataField="t_flowstatusname" UniqueName="t_flowstatusname" HeaderText="Flow Status" SortExpression="t_flowstatusname" AllowFiltering="false">165. <ColumnValidationSettings>166. <ModelErrorMessage Text=""></ModelErrorMessage>167. </ColumnValidationSettings>168. </telerik:GridBoundColumn>169. <telerik:GridBoundColumn DataField="CreativeDirectorName" UniqueName="t_CreativeDirectorCode" HeaderText="Creative Director" SortExpression="CreativeDirectorName" AllowFiltering="false">170. <ColumnValidationSettings>171. <ModelErrorMessage Text=""></ModelErrorMessage>172. </ColumnValidationSettings>173. </telerik:GridBoundColumn>174. <telerik:GridBoundColumn DataField="taskstatus" UniqueName="taskstatus" HeaderText="Status" SortExpression="taskstatus" AllowFiltering="false">175. <ColumnValidationSettings>176. <ModelErrorMessage Text=""></ModelErrorMessage>177. </ColumnValidationSettings>178. </telerik:GridBoundColumn>179. </Columns>180. </MasterTableView>181. 182. <ClientSettings AllowDragToGroup="true" AllowColumnsReorder="true"183. ReorderColumnsOnClient="true" ColumnsReorderMethod="Reorder">184. <Resizing EnableRealTimeResize="True" ResizeGridOnColumnResize="True"185. AllowColumnResize="True" ClipCellContentOnResize="false" AllowResizeToFit="true" />186. <ClientEvents OnRowDblClick="RowDblClick"187. OnRowContextMenu="RowContextMenu" />188. </ClientSettings>189. <GroupingSettings ShowUnGroupButton="true"></GroupingSettings>190. </telerik:RadGrid>01.Private Sub radProject_NeedDataSource(sender As Object, e As GridNeedDataSourceEventArgs) Handles radProject3.NeedDataSource02. Try03. Dim dsData As DataSet = New DataSet04. dsData = LoadBrief()05. radProject3.DataSource = dsData06. Catch ex As Exception07. 08. End Try09. End Sub01.Exception information: 02. Exception type: ArgumentException 03. Exception message: Column 'assignedto' does not belong to table Table.04. at System.Data.DataRow.GetDataColumn(String columnName)05. at System.Data.DataRow.get_Item(String columnName)06. at lambda_method(Closure , DataRowView )07. at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)08. at System.Linq.GroupedEnumerable`3.GetEnumerator()09. at System.Linq.Buffer`1..ctor(IEnumerable`1 source)10. at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__0.MoveNext()11. at Telerik.Web.UI.GridLinqGroupingHelper.CreateAllGroups(IEnumerable enumerable, List`1 groupFields, GridGroup parentGroup, Int32 level)12. at Telerik.Web.UI.GridLinqGroupingHelper.GetGroupedItemsForCurrentPage(IQueryable queryable)13. at Telerik.Web.UI.GridDataTableFromEnumerable.FillData35()14. at Telerik.Web.UI.GridDataTableFromEnumerable.FillData()15. at Telerik.Web.UI.GridResolveEnumerable.Initialize()16. at Telerik.Web.UI.GridResolveEnumerable.EnsureInitialized()17. at Telerik.Web.UI.GridEnumerableFromDataView..ctor(GridTableView owner, DataView dataView, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)18. at Telerik.Web.UI.GridDataSourceHelper.CreateGridEnumerable(GridTableView owner, IEnumerable enumerable, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)19. at Telerik.Web.UI.GridDataSourceHelper.GetResolvedDataSource(GridTableView owner, Object dataSource, String dataMember, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)20. at Telerik.Web.UI.GridTableView.get_ResolvedDataSource()21. at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)22. at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)23. at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)24. at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)25. at System.Web.UI.WebControls.DataBoundControl.PerformSelect()26. at Telerik.Web.UI.GridTableView.PerformSelect()27. at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()28. at Telerik.Web.UI.GridTableView.DataBind()29. at Telerik.Web.UI.RadGrid.DataBind()30. at Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason)31. at Telerik.Web.UI.RadGrid.OnLoad(EventArgs e)32. at System.Web.UI.Control.LoadRecursive()33. at System.Web.UI.Control.LoadRecursive()34. at System.Web.UI.Control.LoadRecursive()35. at System.Web.UI.Control.LoadRecursive()36. at System.Web.UI.Control.LoadRecursive()37. at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<telerik:RadGrid AutoGenerateColumns="False" ID="RadGrid4" AllowFilteringByColumn="True" AllowSorting="True" runat="server" OnItemCommand="RadGrid4_ItemCommand" OnItemCreated="RadGrid4_ItemCreated" EnableLinqExpressions="false" HtmlEncode="true" OnNeedDataSource="RadGrid4_NeedDataSource" GroupingSettings-RetainGroupFootersVisibility="true" ShowGroupPanel="True" CellSpacing="-1" GridLines="Both" Skin="Office2010Silver" EnableViewState="true" Width="100%"> <PagerStyle Mode="NextPrevAndNumeric" /> <GroupingSettings CaseSensitive="false" /> <ClientSettings AllowKeyboardNavigation="true"> </ClientSettings> <ExportSettings OpenInNewWindow="true" FileName="i-Dispatch Job Part Used Report" ExportOnlyData="true"> <Pdf PageHeight="210mm" PageWidth="297mm" DefaultFontFamily="Arial Unicode MS" PageTopMargin="45mm" BorderStyle="Medium" BorderColor="#666666" PaperSize="A4"> </Pdf> </ExportSettings> <MasterTableView Width="100%" DataKeyNames="JobID" HierarchyLoadMode="ServerOnDemand" ShowGroupFooter="true" AllowMultiColumnSorting="true"> <Columns> <telerik:GridMaskedColumn DataField="JobID" HeaderText="JobID#" FilterControlWidth="50px" AutoPostBackOnFilter="false" CurrentFilterFunction="EqualTo" FilterDelay="2000" ShowFilterIcon="false" Mask="#####" GroupByExpression="JobID Group By JobID"> <ColumnValidationSettings> <ModelErrorMessage Text=""></ModelErrorMessage> </ColumnValidationSettings> </telerik:GridMaskedColumn> <telerik:GridBoundColumn DataField="JobTitle" FilterControlAltText="Filter JobTitle column" HeaderText="Job Title" SortExpression="JobTitle" UniqueName="JobTitle"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn DataField="JobBookedDate" PickerType="DatePicker" EnableTimeIndependentFiltering="true" DataFormatString="{0:dd/MM/yyyy HH:mm }" DataType="System.DateTime" FilterControlAltText="Filter JobBookedDate column" HeaderText="Job Booked Date" SortExpression="JobBookedDate" UniqueName="JobBookedDate"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridDateTimeColumn> <telerik:GridTemplateColumn DataField="AssignedStaffID" HeaderText="Mobile Staff" UniqueName="AssignedStaffID" HeaderStyle-Width="200px" SortExpression="AssignedStaffID"> <FilterTemplate> <telerik:RadComboBox ID="comboStaff" DataTextField="StaffName" DataValueField="StaffID" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssignedStaffID").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="StaffIndexChanged"> <Items> <telerik:RadComboBoxItem Text="All" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock10" runat="server"> <script type="text/javascript"> function StaffIndexChanged(sender, args) { var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); tableView.filter("AssignedStaffID", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> <ItemTemplate> <%# Eval("Staff") %> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="CreatedBy" HeaderText="Added By" UniqueName="CreatedBy" HeaderStyle-Width="200px" SortExpression="CreatedBy"> <FilterTemplate> <telerik:RadComboBox ID="comboAdded" DataTextField="StaffName" DataValueField="StaffID" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("CreatedBy").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="AddedByIndexChanged"> <Items> <telerik:RadComboBoxItem Text="All" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock11" runat="server"> <script type="text/javascript"> function AddedByIndexChanged(sender, args) { var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); tableView.filter("CreatedBy", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> <ItemTemplate> <%# Eval("AddedBy") %> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="PartCode" FilterControlAltText="Filter PartCode column" HeaderText="Part Code" SortExpression="PartCode" UniqueName="PartCode"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PartName" Aggregate="Count" FooterText="Total parts: " FilterControlAltText="Filter PartName column" HeaderText="Part Name" SortExpression="PartName" UniqueName="Part Name"> <ColumnValidationSettings> <ModelErrorMessage Text="" /> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="PartPurchasePrice" DataType="System.Double" NumericType="Currency" HeaderText="Purchase Price" SortExpression="PartPurchasePrice" UniqueName="PartPurchasePrice" Aggregate="Sum" FooterText="Total : " FooterAggregateFormatString="{0:C}"> <FooterStyle Font-Bold="true"></FooterStyle> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="PartSalePrice" DataType="System.Double" NumericType="Currency" HeaderText="Recommended Sale Price" SortExpression="PartSalePrice" UniqueName="PartSalePrice" FooterText="Total: " Aggregate="Sum" FooterAggregateFormatString="{0:C}"> <FooterStyle Font-Bold="true"></FooterStyle> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="JobPartUnitPrice" DataType="System.Double" NumericType="Currency" HeaderText="Sale Price Charged" SortExpression="JobPartUnitPrice" UniqueName="JobPartUnitPrice" Aggregate="Sum" FooterAggregateFormatString="{0:C}"> <FooterStyle Font-Bold="true"></FooterStyle> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="JobPartQuantity" DataType="System.Double" HeaderText="Quantity" SortExpression="JobPartQuantity" UniqueName="JobPartQuantity" Aggregate="Sum" FooterAggregateFormatString="{0:n}"> <FooterStyle Font-Bold="true"></FooterStyle> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="JobPartGST" DataType="System.Double" NumericType="Currency" HeaderText="GST Charged" SortExpression="JobPartGST" UniqueName="JobPartGST" Aggregate="Sum" FooterAggregateFormatString="{0:C}"> <FooterStyle Font-Bold="true"></FooterStyle> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="JobPartTotal" DataType="System.Double" NumericType="Currency" HeaderText="Total" SortExpression="JobPartTotal" UniqueName="JobPartTotal" Aggregate="Sum" FooterAggregateFormatString="{0:C}"> <FooterStyle Font-Bold="true"></FooterStyle> </telerik:GridNumericColumn> <telerik:GridCalculatedColumn HeaderText="Gross Margin" UniqueName="GrossMargin" DataType="System.Double" DataFormatString="{0:$###,##0.00}" DataFields="JobPartUnitPrice, PartPurchasePrice" Expression="{0}-{1}" FooterText="Total : " Aggregate="Sum"> </telerik:GridCalculatedColumn> <telerik:GridCalculatedColumn HeaderText="Gross Margin Percentage" UniqueName="GrossMarginPercentage" DataType="System.Double" DataFormatString="{0:P}" DataFields="JobPartUnitPrice, PartPurchasePrice" Expression="iif({0}=0,0,iif(({0}-{1})=0,0,(({0}-{1})/{0})*100))" FooterText="Total : " Aggregate="Sum"> </telerik:GridCalculatedColumn> </Columns> <GroupByExpressions> <telerik:GridGroupByExpression> <GroupByFields> <telerik:GridGroupByField FieldName="JobID"></telerik:GridGroupByField> </GroupByFields> <SelectFields> <telerik:GridGroupByField FieldName="JobID" HeaderText="JobID#"></telerik:GridGroupByField> </SelectFields> </telerik:GridGroupByExpression> </GroupByExpressions> </MasterTableView> <ClientSettings AllowDragToGroup="true"> <Scrolling AllowScroll="True" UseStaticHeaders="True" /> </ClientSettings> <GroupingSettings ShowUnGroupButton="true"></GroupingSettings> </telerik:RadGrid><%#Container.ItemIndex%><asp:ImageButton ID="imgAdmin" runat="server" OnCommand="verCalendarioAdmin"<br> CommandArgument='<%#Container.ItemIndex%>' ImageUrl="./Img/Perfil/administrar.png" ToolTip='<%$ Resources: GridAdministrar %>'/> 

