This is a migrated thread and some comments may be shown as answers.

[Solved] Grouping Yielding Single Result

0 Answers 86 Views
Grid
This is a migrated thread and some comments may be shown as answers.
G
Top achievements
Rank 1
G asked on 20 Apr 2008, 08:03 PM
When attempting to group my GRID it always yeilds a single result. If I set the sort order to ascendning it gives me only the 1st result, descending gives me the last...Here is my code. 

<

form id="form1" runat="server">

<div>

<telerik:RadScriptManager ID="RadScriptManager1" Runat="server">

</telerik:RadScriptManager>

<br />

<asp:TextBox ID="TextBox1" runat="server">MMK</asp:TextBox>

<telerik:RadGrid ID="RadGrid1" runat="server" AllowCustomPaging="True"

AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"

DataSourceID="SqlDataSource1" GridLines="None" PageSize="20" Skin="WebBlue">

<PagerStyle Mode="Slider" />

<

MasterTableView datakeynames="WBS1,WBS2,WBS3" datasourceid="SqlDataSource1">

<

RowIndicatorColumn Visible="False">

<

HeaderStyle Width="20px"></HeaderStyle>

</

RowIndicatorColumn>

<

ExpandCollapseColumn Visible="False" Resizable="False">

<

HeaderStyle Width="20px"></HeaderStyle>

</

ExpandCollapseColumn>

<

GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

<telerik:GridGroupByField

FieldName="Fee"

HeaderText="Fee"

Aggregate="Sum" />

</SelectFields>

<GroupByFields>

<telerik:GridGroupByField

FieldName="Project"

SortOrder="Ascending" />

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

<Columns>

<telerik:GridBoundColumn DataField="Project" HeaderText="Project"

ReadOnly="True" SortExpression="Project" UniqueName="Project">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="WBS1" HeaderText="WBS1" ReadOnly="True"

SortExpression="WBS1" UniqueName="WBS1">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="WBS2" HeaderText="WBS2" ReadOnly="True"

SortExpression="WBS2" UniqueName="WBS2">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="WBS3" HeaderText="WBS3" ReadOnly="True"

SortExpression="WBS3" UniqueName="WBS3">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Status" HeaderText="Status"

SortExpression="Status" UniqueName="Status">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Name" HeaderText="Name"

SortExpression="Name" UniqueName="Name">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LongName" HeaderText="LongName"

SortExpression="LongName" UniqueName="LongName">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Fee" DataType="System.Decimal"

HeaderText="Fee" SortExpression="Fee" UniqueName="Fee">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PostedLabor" DataType="System.Decimal"

HeaderText="PostedLabor" SortExpression="PostedLabor" UniqueName="PostedLabor">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="AddServices" DataType="System.Decimal"

HeaderText="AddServices" SortExpression="AddServices" UniqueName="AddServices">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Period" DataType="System.Int32"

HeaderText="Period" SortExpression="Period" UniqueName="Period">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PM" HeaderText="PM" SortExpression="PM"

UniqueName="PM">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="BackLog" DataType="System.Decimal"

HeaderText="BackLog" ReadOnly="True" SortExpression="BackLog"

UniqueName="BackLog">

</telerik:GridBoundColumn>

</Columns>

 

<

EditFormSettings>

<

PopUpSettings ScrollBars="None"></PopUpSettings>

</

EditFormSettings>

 

</

MasterTableView>

</telerik:RadGrid>

<br />

</div>

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

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

SelectCommand="sp_PIC_getBackLog" SelectCommandType="StoredProcedure">

<SelectParameters>

<asp:ControlParameter ControlID="TextBox1" Name="PM" PropertyName="Text"

Type="String" />

</SelectParameters>

</asp:SqlDataSource>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server"

height="75px" Transparency="5" width="75px"><img alt="Loading..." src="../Images/loading.gif" style="border:0px;" /> </telerik:RadAjaxLoadingPanel>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadGrid1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid1"

LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

</form>

No answers yet. Maybe you can help?

Tags
Grid
Asked by
G
Top achievements
Rank 1
Share this question
or