Telerik Forums / UI for ASP.NET AJAX
This is a migrated thread and some comments may be shown as answers.

Grid not expanding to show detail tables after latest update

1 Answer 154 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jonah
Top achievements
Rank 1
Jonah asked on 23 Jun 2013, 04:42 PM
I have a radgrid with 4 levels of detail tables that worked fine prior to updating my project to the latest ajax release. Now the detail tables will not expand. Here is the code for the Grid sorry for the messy code, formatter was having issues.

 

 

 

 

<telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" Width="950px" runat="server"

AutoGenerateColumns="False" AllowSorting="True" AllowMultiRowSelection="False" MasterTableView-RowIndicatorColumn-Resizable="false"

ShowHeader="true" OnBiffExporting="RadGrid1_BiffExporting" OnItemCreated="RadGrid1_ItemCreated" OnItemDataBound="RadGrid1_ItemDataBound">

<ExportSettings ExportOnlyData="true" />

<ClientSettings>

<Resizing AllowRowResize="false" ShowRowIndicatorColumn="false" />

</ClientSettings>

<PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>

<MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true"

DataKeyNames="CustomerID" PageSize="7" HierarchyLoadMode="ServerOnDemand" CommandItemDisplay="Top" RowIndicatorColumn-Display="false">

<CommandItemTemplate>

<div style="height: 25px; width: 940px; padding-top: 7px;">

<div style="float: left; width: 800px; text-align: left; margin-left: 10px;">

<asp:Label ID="Label2" runat="server" Text="Completed/Declined" CssClass="labelTelerik" Font-Size="Medium" Font-Bold="true"></asp:Label>

</div>

<div style="float: left; margin-right: 15px;">

<asp:ImageButton ImageUrl="../Admin/Images/print.png" ToolTip="Print Grid" ID="ImageButton1" AlternateText="Print" runat="server" OnClientClick="PrintRadGrid()" Height="20px" />

</div>

<div style="float: left; margin-right: 15px;">

<asp:Button runat="server" ID="buttonRefresh" CommandName="Rebind" CssClass="rgRefresh" Text=" " ToolTip="Refresh Grid" />

<asp:LinkButton runat="server" ID="linkbuttionRefresh" CommandName="Rebind" Text="Refresh"></asp:LinkButton>

</div>

<div style="margin-left: 10px;">

<asp:Button runat="server" ID="button1" CommandName="ExportToExcel" CssClass="rgExpXLS" Text=" " ToolTip="Export To Excel" /></div>

</div>

</CommandItemTemplate>

<DetailTables>

<telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="StoreID" DataSourceID="SqlDataSource2" Width="100%">

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="CustomerID" MasterKeyField="CustomerID"></telerik:GridRelationFields>

</ParentTableRelation>

<DetailTables>

<telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="AgentID" DataSourceID="SqlDataSource3" Width="100%">

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="StoreID" MasterKeyField="StoreID"></telerik:GridRelationFields>

</ParentTableRelation>

<DetailTables>

<telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="AgentID" DataSourceID="SqlDataSource4" Width="100%">

<ParentTableRelation>

<telerik:GridRelationFields MasterKeyField="AgentID" DetailKeyField="AgentID" />

</ParentTableRelation>

<Columns>

<telerik:GridBoundColumn SortExpression="JobName" HeaderText="Job Name" HeaderButtonType="TextButton" DataField="JobName" HeaderStyle-Width="150" />

<telerik:GridBoundColumn SortExpression="JobStatus" HeaderText="Job Status" HeaderButtonType="TextButton" HeaderStyle-Width="340" DataField="JobStatus" />

<telerik:GridBoundColumn SortExpression="EntryDate" DataFormatString="{0:MM/dd/yyyy}" HeaderText="EntryDate" HeaderStyle-Width="80" HeaderButtonType="TextButton" DataField="EntryDate" />

<telerik:GridBoundColumn SortExpression="invTotal" DataFormatString="{0:C}" HeaderText="Invoice Total" HeaderStyle-Width="80" HeaderButtonType="TextButton" DataField="invTotal" />

<telerik:GridTemplateColumn UniqueName="TemplateEditColumn" DataField="JobID" HeaderStyle-Width="50">

<ItemTemplate>

<asp:HyperLink ID="ViewLink" runat="server" Text="View"></asp:HyperLink>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<Columns>

<telerik:GridBoundColumn SortExpression="AgentID" HeaderText="AgentID" HeaderButtonType="TextButton" DataField="AgentID" Display="false" />

<telerik:GridBoundColumn SortExpression="AgentName" HeaderButtonType="TextButton" HeaderText="Agent Name" DataField="AgentName" HeaderStyle-Width="160">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Comp" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="Comp">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Decl" HeaderText="Declined" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="Decl">

</telerik:GridBoundColumn>

<telerik:GridCalculatedColumn HeaderText="Total" UniqueName="Total" DataType="System.Int32" HeaderStyle-Width="80"

DataFields="comp, decl" Expression="{0} + {1}" />

<telerik:GridNumericColumn SortExpression="Perc" HeaderText="Average" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="Perc" DataFormatString="{0:P}">

</telerik:GridNumericColumn>

<telerik:GridBoundColumn SortExpression="TLCount" HeaderText="Total Loss" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="TLCount">

</telerik:GridBoundColumn>

<telerik:GridNumericColumn SortExpression="InvTot" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="InvTot" DataFormatString="{0:C}">

</telerik:GridNumericColumn>

<telerik:GridNumericColumn SortExpression="CompAv" HeaderText="Average Job" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="CompAv" DataFormatString="{0:C}">

</telerik:GridNumericColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<Columns>

<telerik:GridBoundColumn SortExpression="LocationName" HeaderButtonType="TextButton" HeaderText="Location Name" HeaderStyle-Width="180"

DataField="LocationName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Comp" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80" DataField="Comp">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Decl" HeaderText="Declined" HeaderButtonType="TextButton" HeaderStyle-Width="80" DataField="Decl">

</telerik:GridBoundColumn>

<telerik:GridCalculatedColumn HeaderText="Total" UniqueName="Total" DataType="System.Int32" HeaderStyle-Width="80"

DataFields="comp, decl" Expression="{0} + {1}" />

<telerik:GridNumericColumn SortExpression="Perc" HeaderText="Average" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="Perc" DataFormatString="{0:P}">

</telerik:GridNumericColumn>

<telerik:GridBoundColumn SortExpression="TLCount" HeaderText="Total Loss" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="TLCount">

</telerik:GridBoundColumn>

<telerik:GridNumericColumn SortExpression="InvTot" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="InvTot" DataFormatString="{0:C}">

</telerik:GridNumericColumn>

<telerik:GridNumericColumn SortExpression="CompAv" HeaderText="Average Job" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="CompAv" DataFormatString="{0:C}">

</telerik:GridNumericColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<Columns>

<telerik:GridBoundColumn SortExpression="CompanyName" HeaderStyle-Width="200" HeaderButtonType="TextButton" HeaderText="Company Name"

DataField="CompanyName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Comp" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="Comp">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn SortExpression="Decl" HeaderText="Declined" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="Decl">

</telerik:GridBoundColumn>

<telerik:GridCalculatedColumn HeaderText="Total" UniqueName="Total" DataType="System.Int32" HeaderStyle-Width="80"

DataFields="comp, decl" Expression="{0} + {1}" />

<telerik:GridNumericColumn SortExpression="Perc" HeaderText="Average" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="Perc" DataFormatString="{0:P}">

</telerik:GridNumericColumn>

<telerik:GridBoundColumn SortExpression="TLCount" HeaderText="Total Loss" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="TLCount">

</telerik:GridBoundColumn>

<telerik:GridNumericColumn SortExpression="InvTot" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="InvTot" DataFormatString="{0:C}">

</telerik:GridNumericColumn>

<telerik:GridNumericColumn SortExpression="CompAv" HeaderText="Average Job" HeaderButtonType="TextButton" HeaderStyle-Width="80"

DataField="CompAv" DataFormatString="{0:C}">

</telerik:GridNumericColumn>

</Columns>

</MasterTableView>

<ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True" AllowColumnsReorder="True">

<Selecting AllowRowSelect="True"></Selecting>

<Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True"

ResizeGridOnColumnResize="False"></Resizing>

</ClientSettings>

<GroupingSettings ShowUnGroupButton="true"></GroupingSettings>

</telerik:RadGrid>


DataSources

<asp:SqlDataSource ID="SqlDataSource1" ProviderName="System.Data.SqlClient" runat="server"

SelectCommand="Shine.dbo.CustomerJobStatus" SelectCommandType="StoredProcedure">

<SelectParameters>

<asp:SessionParameter Name="CustomerID" SessionField="CustomerID" Type="Int32"></asp:SessionParameter>

<asp:ControlParameter Name="StartDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calStartDate" />

<asp:ControlParameter Name="EndDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calEndDate" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" ProviderName="System.Data.SqlClient" runat="server" SelectCommand="Shine.dbo.LocationJobStatus" SelectCommandType="StoredProcedure">

<SelectParameters>

<asp:SessionParameter Name="CustomerID" SessionField="CustomerID" Type="Int32"></asp:SessionParameter>

<asp:ControlParameter Name="StartDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calStartDate" />

<asp:ControlParameter Name="EndDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calEndDate" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource3" ProviderName="System.Data.SqlClient" runat="server" SelectCommand="Shine.dbo.AgentJobStatus" SelectCommandType="StoredProcedure">

<SelectParameters>

<asp:SessionParameter Name="StoreID" SessionField="StoreID" Type="Int32"></asp:SessionParameter>

<asp:ControlParameter Name="StartDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calStartDate" />

<asp:ControlParameter Name="EndDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calEndDate" />

</SelectParameters>

</asp:SqlDataSource>

 

　

 

<asp:SqlDataSource ID="SqlDataSource4" runat="server"

ProviderName="System.Data.SqlClient" SelectCommand="Select EU.FirstName + ' ' + EU.LastName as JobName, J.EntryDate, J.AgentID,

 

 

 

JS.JobStatus + ' (' + SS.SubStatusName + ')' as JobStatus, ISNULL(J.InvoiceTotal, 0) as invTotal, J.JobID

From Shine.dbo.job J

JOIN Shine.dbo.EndUser EU ON EU.EndUserID = J.EndUserID

JOIN Shine.dbo.JobStatus JS ON JS.JobStatusID = J.JobStatusID

JOIN Shine.dbo.JobSubStatus SS ON SS.JobSubStatusID = J.JobSubStatusID

Where j.JobStatusID IN (4,5,6) AND J.LastUpdateDate > @StartDate AND J.LastUpdateDate < DateAdd(day, 1, @EndDate) AND J.AgentID = @AgentID">

 

 

 

<SelectParameters>

<asp:SessionParameter Name="AgentID" SessionField="AgentID" Type="Int32"></asp:SessionParameter>

<asp:ControlParameter Name="StartDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calStartDate" />

<asp:ControlParameter Name="EndDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calEndDate" />

</SelectParameters>

</asp:SqlDataSource>

 

 

1 Answer, 1 is accepted

Sort by
0
Jonah
Top achievements
Rank 1
answered on 25 Jun 2013, 01:26 AM
Another post addressed this same issue, the connection string had been set in the page load even. I moved it to the page init and everything works fine now.
Tags
Grid
Asked by
Jonah
Top achievements
Rank 1
Answers by
Jonah
Top achievements
Rank 1
Share this question
or