Hi,

I have a WebHierarchicalDataGrid that has parent-child tables.  It works great on my localhost, but once I post it to my server the parent rows do not exapand.  below is my code

Source:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

<ig:WebHierarchicalDataGrid ID="wdgCorrList" runat="server" EnableDataViewState="True" EnableViewState="True" Width="100%" AutoGenerateBands="False" Height="375px" AutoGenerateColumns="False" DataKeyFields="ocd_control_number" DataMember="dsCorrList_DefaultView" DataSourceID="WebHierarchicalDataSource1" Key="dsCorrList_DefaultView" OnDataFiltered="wdgCorrList_DataFiltered" oncolumnsorted="wdgCorrList_ColumnSorted">

 

 

 

<Bands>

 

 

 

<ig:Band AutoGenerateColumns="False" DataKeyFields="ocd_control_number,ocd_submission" DataMember="dsSubDates_DefaultView" Key="dsSubDates_DefaultView">

 

 

 

<Columns>

 

 

 

<ig:BoundDataField DataFieldName="ocd_control_number" Hidden="True"

 

 

 

Key="ocd_control_number" DataType="System.Double">

 

 

 

<Header Text="ocd_control_number" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_submission" Key="ocd_submission"

 

 

 

Width="100px">

<Header Text="Submission #" Tooltip="Submission #" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_doc_date" Key="ocd_doc_date"

 

 

 

Width="150px">

 

 

 

<Header Text="Document Date" Tooltip="Document Date" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_received_date" Key="ocd_received_date"

 

 

 

Width="150px">

 

 

 

<Header Text="Received Date" Tooltip="Received Date" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_due_date" Key="ocd_due_date"

 

 

 

Width="150px">

 

 

 

<Header Text="Due Date" Tooltip="Due Date" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_completion_code"

 

 

 

Key="ocd_completion_code" Width="200px">

 

 

 

<Header Text="Action" Tooltip="Action" />

 

 

 

</ig:BoundDataField>

 

 

 

</Columns>

 

 

 

</ig:Band>

 

 

 

</Bands>

 

 

 

<Columns>

 

 

 

<ig:BoundDataField DataFieldName="ocd_control_number" Key="ocd_control_number"

 

 

 

Width="75px">

 

 

 

<Header Text="Control #" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_document_type" Key="ocd_document_type"

 

 

 

Width="75px">

 

 

 

<Header Text="Doc. Type" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_from" Key="ocd_from" Width"125px">

 

 

 

<Header Text="From" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_to" Key="ocd_to" Width="125px">

 

 

 

<Header Text="To" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_author" Key="ocd_author" Width="125px">

 

 

 

<Header Text="Author" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="ocd_subject" Key="ocd_subject" Width="315px">

 

 

 

<Header Text="Subject" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="UserID" Hidden="True" Key="UserID">

 

 

 

<Header Text="UserID" />

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="FY" Key="FY" DataType="System.Int32"

 

 

 

Width="50px">

 

 

 

<Header Text="FY" />

 

 

 

 

</ig:BoundDataField>

 

 

 

<ig:BoundDataField DataFieldName="completion_date" Hidden="True"

 

 

 

Key="completion_date" Width="100px">

 

 

 

<Header Text="comp date"/>

 

 

 

</ig:BoundDataField>

 

 

 

 

</Columns>

 

 

 

<ClientEvents DoubleClick="onDblClick" />

 

 

 

<Behaviors>

 

 

 

<ig:EditingCore AutoCRUD="False">

 

 

 

<Behaviors>

 

 

 

<ig:RowDeleting EnableInheritance="True" />

 

 

 

</Behaviors>

 

 

 

</ig:EditingCore>

 

 

 

<ig:Selection CellClickAction="Row" RowSelectType="Single">

 

 

 

<SelectionClientEvents RowSelectionChanged="onRowSelectionChanged" />

 

 

 

</ig:Selection>

 

 

 

<ig:RowSelectors>

 

 

 

</ig:RowSelectors>

 

 

 

<ig:Filtering EnableInheritance="True">

 

 

 

</ig:Filtering>

 

 

 

<ig:Sorting SortingMode="Multi">

 

 

 

<ColumnSettings>

 

 

 

<ig:SortingColumnSetting ColumnKey="ocd_control_number" />

 

 

 

</ColumnSettings>

 

 

 

</ig:Sorting>

 

 

 

<ig:Activation>

 

 

 

</ig:Activation>

 

 

 

</Behaviors>

 

 

 

 

</ig:WebHierarchicalDataGrid>

　

 

 

 

<ig:WebHierarchicalDataSource ID="WebHierarchicalDataSource1" runat="server">

 

 

 

<dataviews>

 

 

 

<ig:DataView ID="dsCorrList_DefaultView" DataMember="DefaultView"

 

 

 

DataSourceID="dsCorrList" />

 

 

 

<ig:DataView ID="dsSubDates_DefaultView" DataMember="DefaultView"

 

 

 

DataSourceID="dsSubDates" />

 

 

 

</dataviews>

 

 

 

<datarelations>

 

 

 

<ig:DataRelation ChildColumns="ocd_control_number"

 

 

 

ChildDataViewID="dsSubDates_DefaultView" ParentColumns="ocd_control_number"

 

 

 

ParentDataViewID="dsCorrList_DefaultView" />

 

 

 

</datarelations>

 

 

 

</ig:WebHierarchicalDataSource>

 

 

 

 

 

<br />

 

 

 

 

<br />

 

 

 

<br />

 

 

 

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

 

 

 

ConnectionString="<%$ ConnectionStrings:NCHS_OMO_MISDATAConnectionString %>"

 

 

 

SelectCommand="[OcdCorr].[usp_GetSubDates]"

 

 

 

SelectCommandType="StoredProcedure">

 

 

 

 

</asp:SqlDataSource>

 

 

 

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

 

 

 

ConnectionString="<%$ ConnectionStrings:NCHS_OMO_MISDATAConnectionString %>"

 

 

 

DeleteCommand="[OcdCorr].[usp_DeleteCorr]" DeleteCommandType="StoredProcedure"

 

 

 

SelectCommand="[OcdCorr].[usp_SelectCorrList]"

 

 

 

SelectCommandType="StoredProcedure">

 

 

 

<DeleteParameters>

 

 

 

<asp:Parameter Name="ocd_control_number" Type="Decimal" />

 

 

 

</DeleteParameters>

 

 

 

</asp:SqlDataSource>