Questions on UI for ASP.NET AJAX Forum

110,814 questions

2 answers

82 views

Hi ,
I have a Page (page1.aspx) that have RadSplitter and RadWindow , I have another Page ( page2.aspx) that have a radgrid .
page2.aspx is contentpane , when user click a button content load in leftpane of splitter . I want access radwindow from content page(page2.aspx) but I can only see page2.aspx controls.

Splitter

answered on 15 Aug 2012

1 answer

110 views

Filter feature

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?

Grid

answered on 15 Aug 2012

1 answer

113 views

RAD Editor Control Issue

Telerik Support,

I am receiving the following error “The operation could not be completed. Invalid FORMATETC structure” when 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

Editor

answered on 15 Aug 2012

1 answer

69 views

Ajax and jQuery - IE8

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

Ajax

answered on 15 Aug 2012

12 answers

1.2K+ views

[Solved] Menu problem: 'Error Creating Control' at design time

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?

answered on 15 Aug 2012

5 answers

133 views

User-based Sort Order

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:

Go to another page produces a blank page (no grid at all because it's empty.)
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>

Grid

answered on 15 Aug 2012

2 answers

254 views

Add icon in select button

Is there a way to add an icon in select button?

AsyncUpload

answered on 15 Aug 2012

5 answers

345 views

Edit Template with multiple rows

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

Grid

answered on 15 Aug 2012

2 answers

110 views

Can I autosize the width of an ItemTemplate?

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

answered on 15 Aug 2012

1 answer

117 views

Best Control to Use

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

Grid

answered on 15 Aug 2012

Top users last month