or
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
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
<
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
>
<
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
>
<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> |
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> |
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
<
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
>