[Solved] Column x doesnot belong to table GroupedTable0

[Milan Gurung]

Hi,

I am getting an error  "column orderNumber does not belong to table GroupedTable0" when trying to achieve grouping by drag and drop facility.

Please have a look into the following codesnippet.

....

        <Columns>

            <telerik:GridButtonColumn DataTextField="OrderNumber" CommandName="BtnLinkPO" HeaderText="Order No." UniqueName="BtnOrderNumber" Groupable="false" SortExpression="OrderNumber">

                <ItemStyle Font-Bold="True" ForeColor="Green" />

            </telerik:GridButtonColumn>

            <telerik:GridBoundColumn DataField="OrderDate" HeaderText="Order Date" UniqueName="OrderDate"  DataType="System.DateTime" DataFormatString="{0:dd/MM/yyyy}"></telerik:GridBoundColumn>

            <telerik:GridBoundColumn DataField="Cost" HeaderText="Cost" Aggregate="Sum"   DataFormatString="{0:###,##0.00}"  FooterAggregateFormatString="&lt;strong&gt;{0:###,##0.00}&lt;/strong&gt;"  UniqueName="GrossCost" Groupable="False">

                <FooterStyle HorizontalAlign="Right" />

                <ItemStyle HorizontalAlign="Right" />

            </telerik:GridBoundColumn>

            <telerik:GridBoundColumn DataField="ClientPO" HeaderText="Client PO No." UniqueName="ClientPO"></telerik:GridBoundColumn>

            <telerik:GridBoundColumn DataField="Authoriser" HeaderText="Authoriser" UniqueName="Authoriser"></telerik:GridBoundColumn>

            <telerik:GridBoundColumn DataField="ActivityID" HeaderText="Activity ID" UniqueName="ActivityID"></telerik:GridBoundColumn>

            <telerik:GridBoundColumn DataField="UserID" HeaderText="User ID" UniqueName="UserID"></telerik:GridBoundColumn>

            <telerik:GridBoundColumn DataField="Business" HeaderText="Business" UniqueName="Business"></telerik:GridBoundColumn>

            <telerik:GridBoundColumn DataField="Brand" HeaderText="Brand" UniqueName="Brand"></telerik:GridBoundColumn>

        </Columns>

...

Thanks in advance.

Milan G

[Tsvetoslav]

Hi Milan Gurung,

I could not reproduce this error. Please, review the attached sample for comparison and make sure that you have downloaded the latest build.

Thank you.

All the best,
Tsvetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Jason]

Hi, Tsvetoslav,

Could you tell me which version this was fixed in? We're currently running 2008.1.619,

Thanks,

Jason

[Sebastian]

Hello Jason,

We have not been able to reproduce the issue with previous versions of our controls as well as with the latest official release (2009.1.402). I suggest you verify that you have valid group by expressions defined for the grid itself and for template columns if you have such. See the help topics pointed below for more details: 

http://www.telerik.com/help/aspnet-ajax/grdgroupbydeclarativedefinition.html
http://www.telerik.com/help/aspnet-ajax/grdgroupbyprogrammaticdefinition.html

Best regards,

Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.