Hi Pavlina
firstly my apologies, I pasted in the wrong source, the problem I am having is a three level master-detail-detail below (no errors in console).
protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
if ((string)e.CommandName == "ExpandCollapse")
{
string keyValues = ((GridEditableItem)e.Item).KeyValues;
if (e.Item.OwnerTableView.Name == "MasterTable")
{
GridDataItem item = (GridDataItem)e.Item;
Session["PractitionerIDKey"] = item["PractitionerID"].Text; // set the primary key of the details table before thebind of the expand
}
else if (e.Item.OwnerTableView.Name == "DetailsTable")
{
GridDataItem item = (GridDataItem)e.Item;
Session["SubmissionDate"] = item["SubmissionDate"].Text;
Session["PractitionerIDKey"] = item["PractitionerID"].Text;
}
}
}
<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateHierarchy="True" DataSourceID="SqlDataSource2"
CssClass="MyGridView"
ShowFooter="true"
OnItemCommand="RadGrid1_ItemCommand"
OnItemDataBound="RadGrid1_ItemDataBound"
AutoGenerateColumns="False" PageSize="20">
<GroupingSettings CollapseAllTooltip="Collapse all groups"></GroupingSettings>
<MasterTableView DataKeyNames="PractitionerID" DataSourceID="SqlDataSource2" CommandItemDisplay="Top" Name="MasterTable">
<CommandItemSettings ShowAddNewRecordButton="False" ShowExportToExcelButton="True" ShowExportToPdfButton="True" ShowRefreshButton="true" />
<Columns>
<telerik:GridBoundColumn DataField="PractitionerID" DataType="System.Int16" HeaderText="PractitionerID" SortExpression="PractitionerID" UniqueName="PractitionerID" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="flname" DataType="System.String" HeaderText="Practitioner" SortExpression="flname" UniqueName="flname">
</telerik:GridBoundColumn>
</Columns>
<DetailTables>
<telerik:GridTableView runat="server" DataKeyNames="PractitionerID" DataSourceID="SqlDataSource3" Name="DetailsTable" NoDetailRecordsText="No submissions to display." NoMasterRecordsText="No submissions to display." CommandItemDisplay="Top" CommandItemSettings-ShowAddNewRecordButton="false" AllowNaturalSort="False">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="PractitionerID" MasterKeyField="PractitionerID"></telerik:GridRelationFields>
</ParentTableRelation>
<ExpandCollapseColumn Resizable="False">
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<CommandItemSettings ShowAddNewRecordButton="False" ShowRefreshButton="False"></CommandItemSettings>
<Columns>
<telerik:GridBoundColumn DataField="SubmissionDate" DataType="System.String" HeaderText="SubmissionDate" SortExpression="SubmissionDate" UniqueName="SubmissionDate" DataFormatString="{0:D}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PractitionerID" DataType="System.Int16" HeaderText="PractitionerID" SortExpression="PractitionerID" UniqueName="PractitionerID" Display="false">
</telerik:GridBoundColumn>
</Columns>
<DetailTables>
<telerik:GridTableView DataKeyNames="PractitionerID" DataSourceID="SqlDataSource1" Width="100%"
runat="server"
Name="DetailsDetailsTable"
CommandItemDisplay="Top" CommandItemSettings-ShowAddNewRecordButton="false">
<ExpandCollapseColumn Resizable="False" Visible="false">
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="PractitionerID" DataType="System.Int16" HeaderText="PractitionerID" SortExpression="PractitionerID" UniqueName="PractitionerID" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PatientName" FilterControlAltText="Filter PatientName column" HeaderText="Patient" SortExpression="PatientName" UniqueName="PatientName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="InsuranceClaimBatchIDX" DataType="System.Int32" FilterControlAltText="Filter InsuranceClaimBatchIDX column" HeaderText="InsuranceClaimBatchIDX" SortExpression="InsuranceClaimBatchIDX" UniqueName="InsuranceClaimBatchIDX" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="InsuranceClaimsIDX" DataType="System.Int32" FilterControlAltText="Filter InsuranceClaimsIDX column" HeaderText="InsuranceClaimsIDX" ReadOnly="True" SortExpression="InsuranceClaimsIDX" UniqueName="InsuranceClaimsIDX" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ClientID" DataType="System.Int32" FilterControlAltText="Filter ClientID column" HeaderText="ClientID" SortExpression="ClientID" UniqueName="ClientID" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="InsuredIDNumber" FilterControlAltText="Filter InsuredIDNumber column" HeaderText="Insured ID" SortExpression="InsuredIDNumber" UniqueName="InsuredIDNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="DOB" DataType="System.DateTime" FilterControlAltText="Filter DOB column" HeaderText="DOB" SortExpression="DOB" UniqueName="DOB" DataFormatString="{0:MM/dd/yyyy}" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ICD10Code" FilterControlAltText="Filter ICD10Code column" HeaderText="ICD10Code" SortExpression="ICD10Code" UniqueName="ICD10Code" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="APTCPTCode" DataType="System.Int32" FilterControlAltText="Filter APTCPTCode column" HeaderText="CPT" SortExpression="APTCPTCode" UniqueName="APTCPTCode">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PayID" DataType="System.Int32" FilterControlAltText="Filter PayID column" HeaderText="PayID" SortExpression="PayID" UniqueName="PayID" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="RenderingNPI" FilterControlAltText="Filter RenderingNPI column" HeaderText="RenderingNPI" SortExpression="RenderingNPI" UniqueName="RenderingNPI" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="GroupNPI" FilterControlAltText="Filter GroupNPI column" HeaderText="GroupNPI" SortExpression="GroupNPI" UniqueName="GroupNPI" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ServiceDate" DataType="System.DateTime" FilterControlAltText="Filter ServiceDate column" HeaderText="Service Date" SortExpression="ServiceDate" UniqueName="ServiceDate" DataFormatString="{0:MM/dd/yyyy}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Units" DataType="System.Int32" FilterControlAltText="Filter Units column" HeaderText="Units" SortExpression="Units" UniqueName="Units">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ServiceAmount" DataType="System.Decimal" FilterControlAltText="Filter ServiceAmount column" HeaderText="Service Amount" SortExpression="ServiceAmount" UniqueName="ServiceAmount" DataFormatString="{0:c}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Total" DataType="System.Decimal" FilterControlAltText="Filter Total column" HeaderText="Total" SortExpression="Total" UniqueName="Total" DataFormatString="{0:c}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="InvoiceAmountPaid" DataType="System.Decimal" FilterControlAltText="Filter InvoiceAmountPaid column" HeaderText="Invoice Amount Paid" SortExpression="InvoiceAmountPaid" UniqueName="InvoiceAmountPaid" DataFormatString="{0:c}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ClaimAmt" DataType="System.Decimal" FilterControlAltText="Filter ClaimAmt column" HeaderText="Claim Amt" SortExpression="ClaimAmt" UniqueName="ClaimAmt" DataFormatString="{0:c}" Aggregate="Sum" FooterText="$">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SubmissionDate" DataType="System.DateTime" FilterControlAltText="Filter SubmissionDate column" HeaderText="Submission Date" SortExpression="SubmissionDate" UniqueName="SubmissionDate" DataFormatString="{0:MM/dd/yyyy}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ERA_ServiceInfokey" DataType="System.Int32" FilterControlAltText="Filter ERA_ServiceInfokey column" HeaderText="ERA_ServiceInfokey" SortExpression="ERA_ServiceInfokey" UniqueName="ERA_ServiceInfokey" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Adjudicated" FilterControlAltText="Filter Adjudicated column" HeaderText="Adjudicated" ReadOnly="True" SortExpression="Adjudicated" UniqueName="Adjudicated">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PaymentDate" DataType="System.DateTime" FilterControlAltText="Filter PaymentDate column" HeaderText="Cheque / EFT Date" SortExpression="PaymentDate" UniqueName="PaymentDate" DataFormatString="{0:MM/dd/yyyy}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ClaimAmtPaid" DataType="System.Decimal" FilterControlAltText="Filter ClaimAmtPaid column" HeaderText="Claim Amt Paid" SortExpression="ClaimAmtPaid" UniqueName="ClaimAmtPaid" DataFormatString="{0:c}" Aggregate="Sum" FooterText="$">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ClaimAdjustmentGroupCode" FilterControlAltText="Filter ClaimAdjustmentGroupCode column" HeaderText="Adj Group Code" SortExpression="ClaimAdjustmentGroupCode" UniqueName="ClaimAdjustmentGroupCode">
<ItemStyle Width="100px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="AdjustmentAmount" DataType="System.Decimal" FilterControlAltText="Filter AdjustmentAmount column" HeaderText="Adj Amount" SortExpression="AdjustmentAmount" UniqueName="AdjustmentAmount" DataFormatString="{0:c}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ClassAmtUnpaid" DataType="System.Decimal" FilterControlAltText="Filter ClassAmtUnpaid column" HeaderText="Claim Amt Unpaid" SortExpression="ClassAmtUnpaid" UniqueName="ClassAmtUnpaid" DataFormatString="{0:c}" Aggregate="Sum" FooterText="$">
</telerik:GridBoundColumn>
</Columns>
<PagerStyle Position="TopAndBottom" />
</telerik:GridTableView>
</DetailTables>
<PagerStyle Position="TopAndBottom" />
</telerik:GridTableView>
</DetailTables>
</MasterTableView>
<PagerStyle Mode="NextPrev" PageSizes="10;20;50;100" Position="TopAndBottom" />
</telerik:RadGrid>