Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
60 views
I see the RadGrid have Filter feature for every column. Sometimes I want a filter feature like Excel. It means the filter dropdown menu only show those distinct value instead of filter expression. Whether the RagGrid implement the feature?
Kostadin
Telerik team
 answered on 15 Aug 2012
1 answer
93 views

Telerik Support,


I am receiving the following error “The operation could not be completed. Invalid FORMATETC structurewhen trying to add the “RADEDITOR” Telerik Control to my page. Please find the environment details below with the mail. Also, I have attached the snapshot of the error.  


Environment Details:

OS: Windows-7

IDE: Visual Studio 2008

Project using: .NET Framework 3.5

Ajax Control Toolkit Version: 3.5.50731.0

Thanks & Regards,
Varun

 

Petar
Telerik team
 answered on 15 Aug 2012
1 answer
39 views
Hi everyone

I have a update panel that I use along with jQuery, what happens is that a panel is shown on a click of a radio button and then the user can add data into grid. This works 100% in FireFox and Chrome. The problem is that when I use IE8 I first get an error
Message: Unexpected call to method or property access.
Line: 1063
Char: 32442
Code: 0
URI: http://localhost:3895/..../Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d3.5.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3a553a4a13-b3a5-4e6b-a152-b131051f1788%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%3aen-US%3a99e38628-ac51-4787-84f7-90d827ba8fe8%3a16e4e7cd%3af7645509%3a22a6274a%3a24ee1bba%3af46195d3%3a2003d0b8%3a1e771326%3aaa288e2d%3a7165f74%3a58366029%3a874f8ea2%3ac172ae1e%3a9cdfc6e7%3ae330518b%3ac8618e41%3ae4f8f289

Then when I do the post back, it adds a record, but the panel never shows again and when I click on the Add button again it does nothing, almost as if the button has been disabled. Here is the stripped code of the page
<asp:Content ID="Step1Content" ContentPlaceHolderID="ContentHolder" Runat="Server">
    <asp:UpdatePanel ID="uxInformationPanel" runat="server">
        <ContentTemplate>       
        <div class="form1">
            .
            .
            <div id="uxBlackOwnershipPanel" style="display:none;"
                .
                .
                <asp:UpdatePanel ID="updateBlackOwnership" runat="server">
                    <ContentTemplate>
                        .
                        .
                        .
                        <div class="input_slide">
                            <telerik:RadButton ID="uxBlackOwnershipAdd" OnClick="uxBlackOwnershipAdd_Click" Text="Add" EnableEmbeddedSkins="false" Skin="CustomButton" runat="server" />
                        </div>
                        <div class="input_slide">
                            <telerik:RadGrid ID="uxBlackOwnershipGrid">
                                .
                                .
                            </telerik:RadGrid>
                        </div>
                    </ContentTemplate>
                </asp:UpdatePanel>
                .
                .
            </div>           
        </ContentTemplate>
    </asp:UpdatePanel
<script type="text/javascript">
    window.jQuery = window.$ = $telerik.$;
    function pageLoad(sender, args) {
        $("#<%=uxBlackOwnershipYes.ClientID%>").click(function() { $("#uxBlackOwnershipPanel").show(); });
        $("#<%=uxBlackOwnershipNo.ClientID%>").click(function() { $("#uxBlackOwnershipPanel").hide(); });       
 
        var blackOwnership = $("#<%=uxBlackOwnershipYes.ClientID%>");
        if (blackOwnership.attr("checked") != "undefined" && blackOwnership.attr("checked") == "checked") {
            $("#uxBlackOwnershipPanel").show();
        }      
    }
</script>
</asp:Content>
I have this in my MasterPage
<telerik:RadScriptManager runat="server" ID="RadScriptManager1">
     <Scripts>
         <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
         <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
         <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />
     </Scripts>
 </telerik:RadScriptManager>

Why would this not work in IE if it works in all the other browsers I have tested?

Any ideas?

Thanks
Jako
Top achievements
Rank 1
 answered on 15 Aug 2012
12 answers
1.1K+ views
Something strange is happening with a RadMenu control on my page that was previously working just fine.

Here's my menu code:

<telerik:RadMenu ID="RadMenu1"   
                 Runat="server"   
                 Skin="Web20_PL"   
                 EnableEmbeddedSkins="False"   
                 CssClass="MasterMenu"   
                 ForeColor="#467464">  
                 <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> 
                 <Items> 
                   <telerik:RadMenuItem runat="server"   
                                        NavigateUrl="Default.aspx"   
                                        Text="Home"   
                                        ForeColor="#467464">  
                   </telerik:RadMenuItem> 
                   <telerik:RadMenuItem runat="server"   
                                        NavigateUrl="Exposure.aspx"   
                                        Text="Exposure"   
                                        AccessKey="E" 
                                        ForeColor="#467464">  
                   </telerik:RadMenuItem> 
                   <telerik:RadMenuItem runat="server"   
                                        Text="Cash"   
                                        ForeColor="#467464" 
                                        AccessKey="C">  
                              <Items> 
                                <telerik:RadMenuItem runat="server"   
                                                     NavigateUrl="CashSummary.aspx" 
                                                     Text="Summary" 
                                                     AccessKey="S">  
                                </telerik:RadMenuItem> 
                                <telerik:RadMenuItem runat="server"   
                                                     NavigateUrl="CashAuthorisation.aspx"   
                                                     Text="Authorisation" 
                                                     AccessKey="A">  
                                </telerik:RadMenuItem> 
                              </Items> 
                   </telerik:RadMenuItem> 
                 </Items> 
</telerik:RadMenu> 
          
 

At design time the menu, which previously was looking just fine, is now replaced with a glyph that contains the following message:

Error Creating Control - RadMenu1

'Items' could not be initialized.   
Details:   
Unable to cast object of type 'Telerik.Web.UI.RadMenuItemCollection' to type   
'Telerik.Web.UI.RadMenuItemCollection'.<BR> 

Very strange, because the menu works at run time.

Any thoughts?
Petar
Telerik team
 answered on 15 Aug 2012
5 answers
61 views
  • I am using MS Visual Studio 2010 in a 3.5 environment.
  • I am using Microsoft Vista (32 bit)
  • The database is currently located on an SQL 2008 server.
  • I am using RadGrid & tools, version 2012.2.724.35
  • I am using Internet Explorer (9.0.8112.16421)
  • I am programming in VB.net


I think this will be an easy one to solve.  I want to set the sort order of a grid based on who is logged in.  Basically if it's person A, then sort by X, Y.  If it's anyone else, sort by Z.

I have a radGrid with 1 nested detail table.

I had tried to put this on the Page_load using an exit sub if it's a postback, but as you may have guessed, this has many side effects:

  1. Go to another page produces a blank page (no grid at all because it's empty.)
  2. Trying to edit a row in the top table makes the grid disappear.

If I remove the postback exit sub, editing a record just causes an error.


So I think I'm just not setting the data source in the right place or I'm just doing it wrong.  

My Page Load code
Private Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
 
    If Page.IsPostBack Then Exit Sub
    Dim sSQLText As String = "SELECT Currency_CountryCode, Currency_CountryDesc, CurrencyTarget_CountryCode, Currency_LastUpdated, Currency_DisplayOrder FROM Currency_LatestConversions_TBL LEFT OUTER JOIN Currency_CurrentlyTracked ON Currency_LatestConversions_TBL.Currency_CountryCode = Currency_CurrentlyTracked.CurrencyTarget_CountryCode "
 
    If Page.User.Identity.Name.ToString.ToUpper = "RSCOTT" Then
        sSQLText &= "ORDER BY Existing, Currency_LatestConversions_TBL.Currency_CountryDesc"
 
    Else
        sSQLText &= "ORDER BY Currency_DisplayOrder"
 
    End If
 
    SqlDataSource1.SelectCommand = sSQLText
    RadGrid1.DataBind()
 
End Sub



I think you'll know how to solve this without my HTML, but I'll give it to you anyway.


My HTML
<body>
    <form id="form1" runat="server">
        <div>
            <asp:Label ID="Label1" runat="server" Text="Don Beaty's Foreign Currency Tracker" Font-Bold="False" Font-Names="Calibri" Font-Size="XX-Large"></asp:Label>
            <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager>
            <telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0"
                  
                DataSourceID="SqlDataSource1"
                GridLines="None"
                AllowAutomaticInserts="True"
                AllowAutomaticUpdates="True"
                AllowAutomaticDeletes="True"
                BorderColor="Gray"
                BorderStyle="Inset" Skin="Office2010Silver" >
             
                <MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
                    commanditemdisplay="None"
                    allowpaging="True" 
                    EditMode="InPlace"
                    PageSize="30"
                    Width="100%"
                    Name="Currency"
                    showgroupfooter="True" BorderColor="#E0E0E0" BorderStyle="Solid"
                    BorderWidth="1px" GridLines="Vertical" DataKeyNames="Currency_CountryCode, Currency_BriefcaseUsed, Currency_HomeOfficeUsed, Currency_OneHundUsed, Currency_LastUpdated">
 
                    <Columns>
                        <telerik:GridTemplateColumn
                            FilterControlAltText="Filter EditCommandColumn column"
                            Groupable="False"
                            UniqueName="EditCommandColumn">
 
                            <ItemTemplate>
                                <asp:LinkButton ID="lbuEditP" runat="server" CausesValidation="false" CommandName="Edit" Text="Edit"></asp:LinkButton>
                            </ItemTemplate>
 
                            <EditItemTemplate>
                                <asp:LinkButton ID="lbuUpdateP" runat="server" CommandName="Update" Text="Update"></asp:LinkButton
                                <asp:LinkButton ID="lbuCancelUpdateP" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
                            </EditItemTemplate>
 
                        </telerik:GridTemplateColumn>
                        <telerik:GridBoundColumn DataField="Currency_CountryDesc"
                            FilterControlAltText="Filter Currency_CountryDesc column"
                            HeaderText="Currency" SortExpression="Currency_CountryDesc"
                            UniqueName="Currency_CountryDesc"
                            ReadOnly="True">
                            <HeaderStyle VerticalAlign="Bottom"></HeaderStyle>
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="ExchangeRate"
                            DataType="System.Decimal"
                            FilterControlAltText="Filter Currency_Conversion column"
                            HeaderText="Exchange Rate" SortExpression="ExchangeRate"
                            ItemStyle-HorizontalAlign="Right"  HeaderStyle-HorizontalAlign="Center"
                            UniqueName="ExchangeRate"
                            ReadOnly="True">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Right"></ItemStyle>
                        </telerik:GridBoundColumn>
                        <telerik:GridTemplateColumn HeaderText="Flag Briefcase<br/>(With DLB)" FilterControlAltText="Filter Currency_BriefcaseUsed column"
                            UniqueName="Currency_BriefcaseUsed">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                            <EditItemTemplate>
                                <asp:CheckBox ID="CheckBoxA" runat="server" Checked='<%# Bind("Currency_BriefcaseUsed") %>' />
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBoxB" runat="server" Checked='<%# Bind("Currency_BriefcaseUsed") %>' OnCheckedChanged="UpdateBriefcaseFlag" autopostback="true"/>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="Flag Home<br/>(With DLB)" FilterControlAltText="Filter Currency_HomeOfficeUsed column"
                            UniqueName="Currency_HomeOfficeUsed">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                            <EditItemTemplate>
                                <asp:CheckBox ID="CheckBoxC" runat="server" Checked='<%# Bind("Currency_HomeOfficeUsed") %>' />
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBoxD" runat="server" Checked='<%# Bind("Currency_HomeOfficeUsed") %>' OnCheckedChanged="UpdateHomeOfficeFlag" autopostback="true"/>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="Flag 100<br/>(With DLB)" FilterControlAltText="Filter Currency_OneHundUsed column"
                            UniqueName="Currency_OneHundUsed">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                            <EditItemTemplate>
                                <asp:CheckBox ID="CheckBoxE" runat="server" Checked='<%# Bind("Currency_OneHundUsed") %>' />
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBoxF" runat="server" Checked='<%# Bind("Currency_OneHundUsed") %>' OnCheckedChanged="UpdateOneHundFlag" autopostback="true"/>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridBoundColumn DataField="Currency_EnvelopeCount500"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_EnvelopeCount500 column"
                            HeaderText="500 Env. Count<br/>Needed<br/>(With Accounting)"
                            SortExpression="Currency_EnvelopeCount500"
                            UniqueName="Currency_EnvelopeCount500">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Currency_EnvelopeCount100"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_EnvelopeCount100 column"
                            HeaderText="100 Env. Count<br/>Needed<br/>(With Accounting)"
                            SortExpression="Currency_EnvelopeCount100"
                            UniqueName="Currency_EnvelopeCount100">
                            <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
                         <telerik:GridBoundColumn DataField="Currency_EnvelopeCount500_Ready"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_EnvelopeCount500_Ready column"
                            HeaderText="500 Env. Count<br/>On Hand<br/>(With Accounting)"
                            SortExpression="Currency_EnvelopeCount500_Ready"
                            UniqueName="Currency_EnvelopeCount500_Ready">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
 
                        <telerik:GridBoundColumn DataField="Currency_EnvelopeCount100_Ready"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_EnvelopeCount100_Ready column"
                            HeaderText="100 Env. Count<br/>On Hand<br/>(With Accounting)"
                            SortExpression="Currency_EnvelopeCount100_Ready"
                            UniqueName="Currency_EnvelopeCount100_Ready">
                            <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Currency_DisplayOrder"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_DisplayOrder column"
                            HeaderText="Display<br/>Order"
                            SortExpression="Currency_DisplayOrder"
                            UniqueName="Currency_DisplayOrder">
                            <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
                    </Columns>
 
                    <DetailTables>
                        <telerik:GridTableView runat="server"  DataKeyNames="Currency_ID"
                            EditMode="InPlace" CommandItemDisplay="Bottom" Width="100%"
                            DataSourceID="SqlDataSource2" AutoGenerateColumns="False"
                            ShowGroupFooter="True" >
                         
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="Currency_CountryCode" MasterKeyField="Currency_CountryCode" />
                            </ParentTableRelation>
 
                            <CommandItemSettings ExportToPdfText="Export to PDF" />
                            <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
                            <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
 
                            <Columns>
                                <telerik:GridEditCommandColumn FilterControlAltText="Filter EditCommandColumn column" InsertText="Save">
                                    <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle>
                                </telerik:GridEditCommandColumn>
                                <telerik:GridTemplateColumn DataField="CurrencyTarget_ForeignDenomination"
                                    DataType="System.Int32"
                                    FilterControlAltText="Filter CurrencyTarget_ForeignDenomination column"
                                    HeaderText="Foreign<br/>Currency<br/>Denomination"
                                    SortExpression="CurrencyTarget_ForeignDenomination"
                                    UniqueName="CurrencyTarget_ForeignDenomination">
                                    <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle>
                                    <InsertItemTemplate>
                                        <asp:TextBox ID="CurrencyTarget_ForeignDenomination" runat="server"
                                            Text='<%# Bind("CurrencyTarget_ForeignDenomination") %>'></asp:TextBox>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CurrencyTarget_ForeignDenominationLabel" runat="server"
                                            Text='<%# Eval("CurrencyTarget_ForeignDenomination") %>'></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:Label ID="CurrencyTarget_ForeignDenominationLabel2" runat="server"
                                            Text='<%# Eval("CurrencyTarget_ForeignDenomination") %>'></asp:Label>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridBoundColumn DataField="USDEquivalent"
                                    HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDEquivalent" UniqueName="USDEquivalent" FilterControlAltText="Filter USDEquivalent column"
                                    DataType="System.Decimal" DataFormatString="${0:#}"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn
                                    DataField="CurrencyTarget_FCNeeded"
                                    HeaderText="Enter<br/>Quantity to be Included<br/>for 1 '500'<br/>Envelope" SortExpression="CurrencyTarget_FCNeeded" UniqueName="CurrencyTarget_FCNeeded" FilterControlAltText="Filter CurrencyTarget_FCNeeded column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
                                    <ItemStyle HorizontalAlign="Center" BackColor="#CCFFCC" BorderColor="Green" CssClass="maximize"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="USDValue"
                                    HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDValue" UniqueName="USDValue" FilterControlAltText="Filter USDValue column"
                                    DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Right" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalFor500Envelopes"
                                    HeaderText="Total<br/>For '500'<br/>Envelopes<br/>On Hand" SortExpression="TotalFor500Envelopes" UniqueName="TotalFor500Envelopes" FilterControlAltText="Filter TotalFor500Envelopes column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="CurrencyTarget_FCNeeded_100"
                                    HeaderText="Enter<br/>Quantity to be Included<br/>for 1 '100'<br/>Envelope" SortExpression="CurrencyTarget_FCNeeded_100" UniqueName="CurrencyTarget_FCNeeded_100" FilterControlAltText="Filter CurrencyTarget_FCNeeded_100 column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
                                    <ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF" CssClass="maximize"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="USDValue_100"
                                    HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDValue_100" UniqueName="USDValue_100" FilterControlAltText="Filter USDValue_100 column"
                                    DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum"
                                    ReadOnly="True">
                                    <ItemStyle HorizontalAlign="Right" BackColor="#CCCCFF" BorderColor="#6666FF"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalFor100Envelopes"
                                    HeaderText="Total<br/>For '100'<br/>Envelopes<br/>On Hand" SortExpression="TotalFor100Envelopes" UniqueName="TotalFor100Envelopes" FilterControlAltText="Filter TotalFor100Envelopes column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalForAllEnvelopes"
                                    HeaderText="Total<br/>All<br/>Envelopes<br/>On Hand" SortExpression="TotalForAllEnvelopes" UniqueName="TotalForAllEnvelopes" FilterControlAltText="Filter TotalForAllEnvelopes column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="CurrencyTarget_OutsideEnvelope"
                                    HeaderText="Enter<br/>Total<br/>Outside<br/>the Envelope" SortExpression="CurrencyTarget_OutsideEnvelope" UniqueName="CurrencyTarget_OutsideEnvelope" FilterControlAltText="Filter CurrencyTarget_OutsideEnvelope column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666" CssClass="maximize"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="AccountingTotalOnHand"
                                    HeaderText="Total<br/>Quantity<br/>On Hand<br/>In Accounting" SortExpression="AccountingTotalOnHand" UniqueName="AccountingTotalOnHand" FilterControlAltText="Filter AccountingTotalOnHand column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalAllEnvelopesNeeded"
                                    HeaderText="Total<br/>All<br/>Envelopes<br/>Needed" SortExpression="TotalAllEnvelopesNeeded" UniqueName="TotalAllEnvelopesNeeded" FilterControlAltText="Filter TotalAllEnvelopesNeeded column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="QuantityToOrder"
                                    HeaderText="Quantity<br/>To<br/>Order" SortExpression="QuantityToOrder" UniqueName="QuantityToOrder" FilterControlAltText="Filter QuantityToOrder column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666" ForeColor="Crimson" Font-Bold="true"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalFCValue"
                                    HeaderText="Total<br/>Foreign<br/>Currency<br/>Value" SortExpression="TotalFCValue" UniqueName="TotalFCValue" FilterControlAltText="Filter TotalFCValue column"
                                    DataType="System.Int32" DataFormatString="{0:###,##0}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Right" BackColor="#FFCCCC" BorderColor="#FF6666" ></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalUSDValue"
                                    HeaderText="Total<br/>USD<br/>Value" SortExpression="TotalUSDValue" UniqueName="TotalUSDValue" FilterControlAltText="Filter TotalUSDValue column"
                                    DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum"
                                    ReadOnly="True">
                                    <ItemStyle HorizontalAlign="Right" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
                                </telerik:GridBoundColumn>
                            </Columns>
 
                            <GroupByExpressions>
                                <telerik:GridGroupByExpression>
                                    <SelectFields>
                                        <telerik:GridGroupByField FieldAlias="CountryCode"  FieldName="Currency_CountryCode" HeaderText="Country Code"  />
                                    </SelectFields>
                                    <GroupByFields>
                                        <telerik:GridGroupByField FieldAlias="Currency_CountryCode"  FieldName="Currency_CountryCode" />
                                    </GroupByFields>
                         
                                </telerik:GridGroupByExpression>
                            </GroupByExpressions>
                             <FooterStyle Font-Bold="true" />
                            <EditFormSettings>
                                <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                                </EditColumn>
                            </EditFormSettings>
                        </telerik:GridTableView>
                    </DetailTables>
 
                    <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
                    <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
                    <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
 
                    <EditFormSettings>
                        <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
                    </EditFormSettings>
 
                    <PagerStyle AlwaysVisible="True"  />
                    <HeaderStyle Font-Bold="True" />
                </MasterTableView>
 
                <FilterMenu EnableImageSprites="False"></FilterMenu>
            </telerik:RadGrid>
     
        </div>
 
        <br />
        <telerik:RadButton ID="btnReport" runat="server" style="top: 0px; left: 0px"
            Text="Summary Report">
        </telerik:RadButton>
 
        <telerik:RadEditor ID="radPDFReport" Runat="server" Height="114px"
            Width="685px" ExportSettings-FileName="ForeignCurrencyTotals"
            Visible="False" Font-Names="Calibri">
            <ExportSettings OpenInNewWindow="True">
                <Pdf PageHeight="8.5in" PageWidth="11in" AllowAdd="True" AllowCopy="True"
                    AllowModify="True" Title="Foreign Curency Totals" Author="Accounting"
                    Creator="Accounting" PageBottomMargin="45px" PageFooterMargin="18px"
                    PageHeaderMargin="18px" PageLeftMargin="18px" PageRightMargin="18px"
                    PageTopMargin="37px" />
            </ExportSettings>
            <Content>CONTENT</Content>
 
            <TrackChangesSettings CanAcceptTrackChanges="False"></TrackChangesSettings>
        </telerik:RadEditor>
 
 
         
 
 
 
 
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>"
 
        
        UpdateCommand="UPDATE [Currency_LatestConversions_TBL]
                        SET [Currency_EnvelopeCount500] = @Currency_EnvelopeCount500, [Currency_EnvelopeCount100] = @Currency_EnvelopeCount100, [Currency_EnvelopeCount500_Ready] = @Currency_EnvelopeCount500_Ready, [Currency_EnvelopeCount100_Ready] = @Currency_EnvelopeCount100_Ready, [Currency_BriefcaseUsed] = @Currency_BriefcaseUsed, [Currency_HomeOfficeUsed] = @Currency_HomeOfficeUsed, [Currency_OneHundUsed] = @Currency_OneHundUsed, Currency_DisplayOrder = @Currency_DisplayOrder, Currency_LastEdited = GetDate() 
                        WHERE [Currency_CountryCode]=@Currency_CountryCode">
 
        <UpdateParameters>
            <asp:Parameter Name="Currency_CountryCode" />
        </UpdateParameters>
 
    </asp:SqlDataSource>
 
 
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>"
 
        SelectCommand="SELECT Currency_Grid.*
                        FROM Currency_Grid
                        WHERE([Currency_CountryCode]=@Currency_CountryCode)
                        ORDER BY CurrencyTarget_ForeignDenomination"
 
        UpdateCommand="UPDATE [Currency_TargetAmounts_TBL]
                        SET [CurrencyTarget_FCNeeded] = @CurrencyTarget_FCNeeded, [CurrencyTarget_FCNeeded_100] = @CurrencyTarget_FCNeeded_100, [CurrencyTarget_OutsideEnvelope] = @CurrencyTarget_OutsideEnvelope, [CurrencyTarget_DateUpdated] = GetDate()
                        WHERE [Currency_ID] = @Currency_ID"
 
         
        InsertCommand="INSERT INTO Currency_TargetAmounts_TBL(Currency_Location, CurrencyTarget_CountryCode, CurrencyTarget_ForeignDenomination, CurrencyTarget_FCNeeded, CurrencyTarget_FCNeeded_100, CurrencyTarget_OutsideEnvelope)
                        SELECT 'Accounting' AS Expr1, @Currency_CountryCode AS Expr2, @CurrencyTarget_ForeignDenomination AS Expr3, @CurrencyTarget_FCNeeded AS Expr4, @CurrencyTarget_FCNeeded_100 AS Expr5, @CurrencyTarget_OutsideEnvelope AS Expr6" >
 
        <SelectParameters>
            <asp:SessionParameter DefaultValue="XXX" Name="Currency_CountryCode" SessionField="@Currency_CountryCode" Type="String" />
        </SelectParameters>
 
        <UpdateParameters>
            <asp:Parameter Name="CurrencyTarget_FCNeeded" />
            <asp:Parameter Name="CurrencyTarget_FCNeeded_100" />
            <asp:Parameter Name="CurrencyTarget_OutsideEnvelope" />
            <asp:Parameter Name="CurrencyTarget_DateUpdated" />
            <asp:Parameter Name="Currency_ID" />
        </UpdateParameters>
 
        <InsertParameters>
            <asp:Parameter Type="Int32" Name="CurrencyTarget_ForeignDenomination" />
            <asp:Parameter Type="Int32" Name="CurrencyTarget_FCNeeded"   />
            <asp:Parameter Type="Int32" Name="CurrencyTarget_FCNeeded_100"  />
            <asp:Parameter Type="Int32" Name="CurrencyTarget_OutsideEnvelope"  />
            <asp:Parameter Type="DateTime" Name="CurrencyTarget_DateCreated"  />
        </InsertParameters>
 
    </asp:SqlDataSource>
 
    </form>
</body>


Rick
Top achievements
Rank 1
 answered on 15 Aug 2012
2 answers
162 views
Is there a way to add an icon in select button?
Jin
Top achievements
Rank 1
 answered on 15 Aug 2012
5 answers
311 views
Hi,

I have radgrid,for which I am using inbuilt edit functionality.
Edit Template contains some controls along with the Button. on click of this button,another set of same controls should be added in the edit template. Please refer edittemplate.png and edittemplate1.png 


Also after saving these detail from Edit template we need to display TWO record inside the RadGrid row.Please refer radgrid.png
Kostadin
Telerik team
 answered on 15 Aug 2012
2 answers
71 views
I have a menu with a checkboxlist inside of an ItemTemplate.  When the menu expands, the user can check whatever boxes they want and close the menu.

But the checkbox list will be created dynamically so I want to know if I can get the width of the template to grow with the size of it's contents.

Thanks
Javier
Top achievements
Rank 1
 answered on 15 Aug 2012
1 answer
74 views
I'm evaluating Telerik controls and have a question on the best grid type control to use to lay out certain data. I've attached an image of the layout I'm trying to achieve.

Can this be done? The challenge here would be to sum up groups of data in the same control. I'm assuming that the grand total at the bottom of the grid could be done within a footer.

Thank you for your help on this. 

Terry
Kostadin
Telerik team
 answered on 15 Aug 2012
1 answer
170 views
I have a button and a RadProgressArea button in one page to execute a batch job. When I click the button and wait for some time, I click the cancel button, it have no any response. Anybody know why?

  protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                RadProgressArea1.Localization.UploadedFiles = "Completed Steps: ";
                RadProgressArea1.Localization.CurrentFileName = "Step: ";
                RadProgressArea1.Localization.TotalFiles = "Total Steps:";
            }
        }


        protected void RadButtonProcess_Click(object sender, EventArgs e)
        {
            RadProgressContext context = RadProgressContext.Current;
            context.SecondaryTotal = "100";
            for (int i = 1; i < 100; i++)
            {
                context.SecondaryValue = i.ToString();
                context.SecondaryPercent = i.ToString();
                context.CurrentOperationText = "Doing step " + i.ToString();
                if (!Response.IsClientConnected)
                {
                    //Cancel button was clicked or the browser was closed, so stop processing
                    break;
                }
                // simulate a long time performing the current step
                System.Threading.Thread.Sleep(100);
            }
        }



 <telerik:RadProgressManager runat="server" ID="RadProgressManagerCode" />
    <telerik:RadProgressArea ID="RadProgressArea1" runat="server" DisplayCancelButton="True"
        ProgressIndicators="FilesCountBar,
                          FilesCountPercent,                      
                          SelectedFilesCount,                      
                          CurrentFileName,                      
                          TimeElapsed">
    </telerik:RadProgressArea>

 <telerik:RadButton ID="RadButtonProcess" runat="server" Text="Process Comparision"
                    OnClick="RadButtonProcess_Click">
                    <Icon PrimaryIconCssClass="rbConfig" PrimaryIconLeft="4" SecondaryIconTop="4" />
                </telerik:RadButton>
Plamen
Telerik team
 answered on 15 Aug 2012
Narrow your results
Selected tags
Tags
+? more
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?