[Solved] Footer Aggregate data not display but Group Footer Data is

[bradley baker]

Trying to display a total footer row and I could of swore it was working fine until today and I made a master page

As you can see in the screen shot the total footer only displays "Count: " but no data ... but all the group by footers are just fine.  Ideas?

http://mmo-rpg.com/footermiss.png

<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register assembly="Telerik.Web.UI, Version=2009.2.701.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" namespace="Telerik.Charting" tagprefix="telerik" %>
<asp:Content ID="Content1" ContentPlaceHolderID="Header" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="PrimaryContent" Runat="Server">
    <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="Default_ShipGrid">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="Default_ShipGrid" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManagerProxy>
<telerik:RadTabStrip ID="RadTabStrip1" runat="server" SelectedIndex="0"
                        MultiPageID="RadMultiPage1" Width="100%">
                <Tabs>
                    <telerik:RadTab runat="server" Text="Welcome" Selected="True">
                    </telerik:RadTab>
                    <telerik:RadTab runat="server" Text="Shipping">
                    </telerik:RadTab>
                </Tabs>
            </telerik:RadTabStrip>
                <telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0"
                        Width="100%">
                <telerik:RadPageView ID="RadPageView1" runat="server" Width="100%">
                <h2><a href="#">Welcome</a></h2>
                <p>This is a development site to test things out.  Its ASP.NET and VB and RadContorls.<br />
                    <br />
                    <br />
                    <br />
                    <br />
                    <br />
                    The Bacground ends about here yay!<br />
                    <br />
                </p>
                </telerik:RadPageView>
                <telerik:RadPageView ID="RadPageView2" runat="server" Width="100%">
                    <asp:SqlDataSource ID="ShipChartSQL" runat="server"
                        ConnectionString="<%$ ConnectionStrings:ERPLXFConnectionString %>"
                        SelectCommand="SELECT ILDATE, ILPFAC, SUM(ILQTY * ILNET) AS TTL, SUBSTRING(CAST(ILDATE AS char(8)), 5, 2) + '-' + SUBSTRING(CAST(ILDATE AS char(8)), 7, 2) AS NomDate FROM SIL WHERE (ILPFAC &lt;&gt; '') AND (CAST(SUBSTRING(CAST(ILDATE AS char(8)), 5, 2) AS int) = MONTH(GETDATE())) AND (CAST(SUBSTRING(CAST(ILDATE AS char(8)), 1, 4) AS int) = YEAR(GETDATE())) AND (ILPROD &lt;&gt; 'FREIGHT') GROUP BY ILDATE, ILPFAC ORDER BY ILDATE, ILPFAC"
                        DataSourceMode="DataReader"></asp:SqlDataSource>
                   <div align="center">
                    <telerik:RadChart ID="RadChart2" runat="server" AutoLayout="True"
                        AutoTextWrap="True" DataGroupColumn="ILPFAC" DataSourceID="ShipChartSQL"
                        Height="400px" Skin="Office2007" Width="850px"
                        IntelligentLabelsEnabled="True">
                        <Series>
                            <telerik:ChartSeries DataYColumn="TTL" Name="010"><Appearance><FillStyle FillType="Solid" MainColor="69, 115, 167"></FillStyle><LabelAppearance Visible="False"></LabelAppearance><TextAppearance TextProperties-Color="Black"></TextAppearance><Border Color="69, 115, 167" /></Appearance></telerik:ChartSeries>
                            <telerik:ChartSeries DataYColumn="TTL" Name="040"><Appearance><FillStyle FillType="Solid" MainColor="107, 70, 68"></FillStyle><LabelAppearance Visible="False"></LabelAppearance><TextAppearance TextProperties-Color="Black"></TextAppearance><Border Color="107, 70, 68" /></Appearance></telerik:ChartSeries>
                            <telerik:ChartSeries DataYColumn="TTL" Name="050"><Appearance><FillStyle FillType="Solid" MainColor="136, 166, 78"></FillStyle><LabelAppearance Visible="False"></LabelAppearance><TextAppearance TextProperties-Color="Black"></TextAppearance><Border Color="136, 166, 78" /></Appearance></telerik:ChartSeries>
                            <telerik:ChartSeries DataYColumn="TTL" Name="070"><Appearance><FillStyle FillType="Solid" MainColor="113, 88, 143"></FillStyle><LabelAppearance Visible="False"></LabelAppearance><TextAppearance TextProperties-Color="Black"></TextAppearance><Border Color="113, 88, 143" /></Appearance></telerik:ChartSeries>
                            <telerik:ChartSeries DataYColumn="TTL" Name="080"><Appearance><FillStyle FillType="Solid" MainColor="66, 152, 175"></FillStyle><LabelAppearance Visible="False"></LabelAppearance><TextAppearance TextProperties-Color="Black"></TextAppearance><Border Color="66, 152, 175" /></Appearance></telerik:ChartSeries>
                        </Series>
                        <PlotArea>
                            <DataTable>
                                <Appearance Position-AlignedPosition="Bottom" RenderType="AutoSize">
                                </Appearance>
                            </DataTable>
                            <XAxis AutoScale="False" DataLabelsColumn="NomDate" MaxValue="20090911"
                                MinValue="20090901" Step="1">
                                <Appearance Color="134, 134, 134" MajorTick-Color="134, 134, 134"
                                    ValueFormat="ShortDate">
                                    <MajorGridLines Color="134, 134, 134" Width="0" />
                                    <TextAppearance TextProperties-Color="Black">
                                    </TextAppearance>
                                </Appearance>
                                <AxisLabel>
                                    <TextBlock Text="Date">
                                        <Appearance TextProperties-Color="Black">
                                        </Appearance>
                                    </TextBlock>
                                </AxisLabel>
                                <Items>
                                    <telerik:ChartAxisItem Value="20090901"><TextBlock Text="9/1/2009 12:00:00 AM"></TextBlock></telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="20090902"><TextBlock Text="9/2/2009 12:00:00 AM"></TextBlock></telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="20090903"><TextBlock Text="9/3/2009 12:00:00 AM"></TextBlock></telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="20090904"><TextBlock Text="9/4/2009 12:00:00 AM"></TextBlock></telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="20090908"><TextBlock Text="9/8/2009 12:00:00 AM"></TextBlock></telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="20090909"><TextBlock Text="9/9/2009 12:00:00 AM"></TextBlock></telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="20090910"><TextBlock Text="9/10/2009 12:00:00 AM"></TextBlock></telerik:ChartAxisItem>
                                    <telerik:ChartAxisItem Value="20090911"><TextBlock Text="9/11/2009 12:00:00 AM"></TextBlock></telerik:ChartAxisItem>
                                </Items>
                            </XAxis>
                            <YAxis>
                                <Appearance Color="134, 134, 134" MajorTick-Color="134, 134, 134"
                                    MinorTick-Color="134, 134, 134" ValueFormat="Currency">
                                    <MajorGridLines Color="134, 134, 134" />
                                    <MinorGridLines Color="134, 134, 134" />
                                    <TextAppearance TextProperties-Color="Black">
                                    </TextAppearance>
                                </Appearance>
                                <AxisLabel>
                                    <TextBlock Text="$">
                                        <Appearance TextProperties-Color="Black">
                                        </Appearance>
                                    </TextBlock>
                                </AxisLabel>
                            </YAxis>
                            <Appearance>
                                <FillStyle FillType="Solid" MainColor="">
                                </FillStyle>
                            </Appearance>
                        </PlotArea>
                        <Appearance>
                            <Border Color="134, 134, 134" />
                        </Appearance>
                        <ChartTitle>
                            <Appearance Position-AlignedPosition="Top">
                                <FillStyle MainColor="">
                                </FillStyle>
                            </Appearance>
                            <TextBlock Text="Shipments by $ by Facility by Day">
                                <Appearance TextProperties-Color="Black" TextProperties-Font="Arial, 18px">
                                </Appearance>
                            </TextBlock>
                        </ChartTitle>
                        <Legend>
                            <Appearance Dimensions-Margins="15%, 2%, 1px, 1px"
                                Dimensions-Paddings="2px, 8px, 6px, 3px">
                                <ItemTextAppearance TextProperties-Color="Black">
                                </ItemTextAppearance>
                                <ItemMarkerAppearance Figure="Diamond">
                                </ItemMarkerAppearance>
                            </Appearance>
                        </Legend>
                    </telerik:RadChart>
                    </div>
                    <asp:SqlDataSource ID="ShipGridSQL" runat="server"
                        ConnectionString="<%$ ConnectionStrings:ERPLXFConnectionString %>"
                        SelectCommand="SELECT top 500 ILDATE, ILPFAC, ILQTY * ILNET AS TTL, SUBSTRING(CAST(ILDATE AS char(8)), 5, 2) + '-' + SUBSTRING(CAST(ILDATE AS char(8)), 7, 2) AS NomDate, ILPROD, ILQTY, ILNET, ILWHS, ILORD, ILCUST FROM SIL WHERE (ILPFAC &lt;&gt; '') AND (CAST(SUBSTRING(CAST(ILDATE AS char(8)), 5, 2) AS int) = MONTH(GETDATE())) AND (CAST(SUBSTRING(CAST(ILDATE AS char(8)), 1, 4) AS int) = YEAR(GETDATE())) AND (ILPROD &lt;&gt; 'FREIGHT') ORDER BY ILDATE DESC, ILPFAC"
                        DataSourceMode="DataReader"></asp:SqlDataSource>
                        <div>
                    <telerik:RadGrid ID="Default_ShipGrid" runat="server" AllowFilteringByColumn="True"
                        AllowSorting="True" DataSourceID="ShipGridSQL"
                        GridLines="None" ShowGroupPanel="True" ShowFooter="True">
                        <MasterTableView AutoGenerateColumns="False" GroupsDefaultExpanded="False" ShowGroupFooter="True" ShowFooter="True">
                            <RowIndicatorColumn>
                                <HeaderStyle Width="20px" />
                            </RowIndicatorColumn>
                            <ExpandCollapseColumn>
                                <HeaderStyle Width="20px" />
                            </ExpandCollapseColumn>
                            <Columns>
                                <telerik:GridBoundColumn DataField="NomDate" HeaderText="Date"
                                    ReadOnly="True" SortExpression="NomDate" UniqueName="NomDate" Aggregate="Count">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ILPFAC" HeaderText="Facility"
                                    SortExpression="ILPFAC" UniqueName="ILPFAC">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ILORD" DataType="System.Decimal"
                                    HeaderText="Order No." SortExpression="ILORD" UniqueName="ILORD">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ILCUST" DataType="System.Decimal"
                                    HeaderText="Cust No." SortExpression="ILCUST" UniqueName="ILCUST">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ILPROD" HeaderText="Prod"
                                    SortExpression="ILPROD" UniqueName="ILPROD">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ILQTY" DataType="System.Decimal"
                                    HeaderText="Qty" SortExpression="ILQTY" UniqueName="ILQTY"
                                    DataFormatString="{0:n}" Aggregate="Sum"
                                    FooterAggregateFormatString="{0:n}">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ILNET" DataType="System.Decimal"
                                    HeaderText="Net $" SortExpression="ILNET" UniqueName="ILNET"
                                    DataFormatString="{0:c}">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TTL" DataType="System.Decimal"
                                    HeaderText="Total" ReadOnly="True" SortExpression="TTL" UniqueName="TTL"
                                    DataFormatString="{0:c}" Aggregate="Sum">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="ILWHS" HeaderText="Warehouse"
                                    SortExpression="ILWHS" UniqueName="ILWHS">
                                </telerik:GridBoundColumn>
                            </Columns>
                <GroupByExpressions>
                    <telerik:GridGroupByExpression>
                       <GroupByFields>
                            <telerik:GridGroupByField FieldName="ILPFAC" />
                       </GroupByFields>
                       <SelectFields>
                            <telerik:GridGroupByField FieldName="ILPFAC" HeaderText="Facility" />
                       </SelectFields>
                    </telerik:GridGroupByExpression>
                    <telerik:GridGroupByExpression>
                       <GroupByFields>
                            <telerik:GridGroupByField FieldName="NomDate" />
                       </GroupByFields>
                       <SelectFields>
                            <telerik:GridGroupByField FieldName="NomDate" HeaderText="Date" />
                       </SelectFields>
                    </telerik:GridGroupByExpression>
                </GroupByExpressions>
                        </MasterTableView>
                        <FooterStyle Font-Bold="True" Font-Size="Small" Font-Italic="True" />
                        <ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True">
                            <Selecting AllowRowSelect="True" />
                        </ClientSettings>
                        <GroupingSettings ShowUnGroupButton="true" />
                    </telerik:RadGrid>
                </div>
                </telerik:RadPageView>
            </telerik:RadMultiPage>
</asp:Content>

[Pavlina]

Hi Bradley,

I went through your code and it looks fine to me. At this point I will ask you to open a formal support ticket and send us a working project with reproduced this erroneous behavior. Thus I could help you further in resolving it.

All the best,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[bradley baker]

I changed the SQL from DataReader to DataSet and its working agian ... You got me :)

[Pavlina]

Hello Bradley,

I am happy to hear you have found a solution for your case.
Do not hesitate to contact us if other questions arise.

Sincerely yours,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.