If Me.DataType = GetType("System.Int32") OrElse Me.DataType = GetType("System.Int16") OrElse Me.DataType = GetType("System.Int64") Then
filterItem.FireCommandEvent("Filter", New Pair("EqualTo", Me.UniqueName))
The error states "Type expected".
Is there a CLEAR example for this using VB and SQL?
If not, could I get some help creating one to add here to the forum so we can all share it?
Here is my ASPX page.
| <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Copy of company_revenue.aspx.vb" Inherits="admin_accounting_reports_company_company_revenue" %> |
| <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head runat="server"> |
| <title>Untitled Page</title> |
| </head> |
| <body> |
| <p> |
| <img alt="" src="../../../../images/Header.gif" |
| style="width: 950px; height: 54px" /></p> |
| <p style="color: #638AB0; font-weight: 700; font-family: Arial; font-size: large"> |
| New Report Model</p> |
| <form id="form1" runat="server"> |
| <telerik:RadScriptManager ID="ScriptManager1" runat="server" |
| EnableTheming="True"> |
| </telerik:RadScriptManager> |
| <telerik:RadGrid ID="RadGrid1" runat="server" |
| DataSourceID="Revenue" GridLines="None" EnableLinqExpressions="False" |
| Font-Bold="False" Font-Italic="False" Font-Names="Arial" Font-Overline="False" |
| Font-Size="XX-Small" Font-Strikeout="False" Font-Underline="False" |
| ForeColor="Blue" ShowFooter="True" Skin="WebBlue" |
| AllowFilteringByColumn="True"> |
| <MasterTableView ShowGroupFooter="true" autogeneratecolumns="False" datasourceid="Revenue" |
| datakeynames="IDShpmt" groupsdefaultexpanded="False" |
| filterexpression="([ModifiedDate] =' 01/01/2100')"> |
| <RowIndicatorColumn Visible="False"> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn Visible="False" Resizable="False"> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="IDShpmt" DataType="System.Int32" |
| HeaderText="Shpmt" ReadOnly="True" SortExpression="IDShpmt" |
| UniqueName="IDShpmt" AllowFiltering="False" AutoPostBackOnFilter="True"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="ModifiedDate" |
| DataFormatString="{0:MM/dd/yyyy}" DataType="System.DateTime" |
| HeaderText="Completed Date" ReadOnly="True" SortExpression="ModifiedDate" |
| UniqueName="ModifiedDate"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Contractor" |
| HeaderText="Contractor" SortExpression="Contractor" |
| UniqueName="Contractor"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn Aggregate="Sum" DataField="RevenueTotal" |
| DataFormatString="{0:C2}" DataType="System.Decimal" |
| FooterAggregateFormatString="{0:C2}" HeaderText="Base Revenue" ReadOnly="True" |
| SortExpression="RevenueTotal" UniqueName="RevenueTotal" |
| AllowFiltering="False"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn Aggregate="Sum" DataField="AdtlItemTotal" |
| DataFormatString="{0:C2}" DataType="System.Decimal" |
| FooterAggregateFormatString="{0:C2}" HeaderText="Adtl. Item Revenue" |
| ReadOnly="True" SortExpression="AdtlItemTotal" UniqueName="AdtlItemTotal" |
| AllowFiltering="False"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn Aggregate="Sum" DataField="ShpmtTotal" |
| DataFormatString="{0:C2}" DataType="System.Decimal" |
| FooterAggregateFormatString="{0:C2}" HeaderText="Total Revenue" ReadOnly="True" |
| SortExpression="ShpmtTotal" UniqueName="ShpmtTotal" AllowFiltering="False"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn Aggregate="Sum" DataField="CompanyRevenue" |
| DataFormatString="{0:C2}" DataType="System.Decimal" |
| FooterAggregateFormatString="{0:C2}" HeaderText="Company Revenue" |
| ReadOnly="True" SortExpression="CompanyRevenue" |
| UniqueName="CompanyRevenue" AllowFiltering="False"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn Aggregate="Sum" DataField="ContractorFirstItemTotal" |
| DataFormatString="{0:C2}" DataType="System.Decimal" |
| FooterAggregateFormatString="{0:C2}" HeaderText="Cont. Base Revenue" |
| ReadOnly="True" SortExpression="ContractorFirstItemTotal" |
| UniqueName="ContractorFirstItemTotal" AllowFiltering="False"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn Aggregate="Sum" DataField="ContractorAddItemTotal" |
| DataFormatString="{0:C2}" DataType="System.Decimal" |
| FooterAggregateFormatString="{0:C2}" HeaderText="Cont AdtI. Item Revenue" |
| ReadOnly="True" SortExpression="ContractorAddItemTotal" |
| UniqueName="ContractorAddItemTotal" AllowFiltering="False"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn Aggregate="Sum" DataField="Bonus" |
| DataFormatString="{0:C2}" DataType="System.Decimal" |
| FooterAggregateFormatString="{0:C2}" HeaderText="Cont. Bonus" ReadOnly="True" |
| SortExpression="Bonus" UniqueName="Bonus" AllowFiltering="False"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn Aggregate="Sum" DataField="ContractorTotal" |
| DataFormatString="{0:C2}" DataType="System.Decimal" |
| FooterAggregateFormatString="{0:C2}" HeaderText="Contractor Total" |
| ReadOnly="True" SortExpression="ContractorTotal" |
| UniqueName="ContractorTotal" AllowFiltering="False"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| <groupbyexpressions> |
| <telerik:GridGroupByExpression> |
| <selectfields> |
| <telerik:GridGroupByField Aggregate="None" FieldAlias="Contractor" |
| FieldName="Contractor" FormatString="" HeaderText="" /> |
| </selectfields> |
| <groupbyfields> |
| <telerik:GridGroupByField FieldAlias="Contractor" FieldName="Contractor" |
| FormatString="" HeaderText="" /> |
| </groupbyfields> |
| </telerik:GridGroupByExpression> |
| </groupbyexpressions> |
| <EditFormSettings> |
| <PopUpSettings ScrollBars="None"></PopUpSettings> |
| </EditFormSettings> |
| <HeaderStyle BackColor="Blue" Font-Bold="False" Font-Italic="False" |
| Font-Overline="False" Font-Strikeout="False" Font-Underline="False" |
| ForeColor="White" Wrap="True" /> |
| <FooterStyle Font-Bold="True" Font-Size="Small" /> |
| </MasterTableView> |
| <HeaderStyle BackColor="Blue" Font-Bold="False" Font-Italic="False" |
| Font-Overline="False" Font-Strikeout="False" Font-Underline="False" |
| Wrap="True" /> |
| </telerik:RadGrid> |
| <br /> |
| <br /> |
| <br /> |
| <br /> |
| <br /> |
| <asp:SqlDataSource ID="Revenue" runat="server" |
| ConnectionString="<%$ ConnectionStrings:smsConnectionString %>" |
| SelectCommand="SELECT [IDShpmt], CAST([EnterDate] AS DateTime) AS EnterDate, [ModifiedDate], [Contractor], [RevenueTotal], [ShpmtTotal], [AdtlItemTotal], [CompanyRevenue], [ContractorFirstItemTotal], [ContractorAddItemTotal], [Bonus], [ContractorTotal] FROM [Report_Revenue_Totals] |
| WHERE [Status] = 'Completed'"> |
| </asp:SqlDataSource> |
| </form> |
| <p> |
| </p> |
| <p> |
| </p> |
| <p> |
| </p> |
| </body> |
| </html> |
<telerik:RadMaskedTextBox
id="IN_RMTB"
runat="server"
Mask="##-#######"
Skin="Office2007"
Width="65px"
EmptyMessage="00-0000000" />
##-####### (make sure you pad the number with zeros - ex: 08-0000123)
<asp:RequiredFieldValidator
id="IN_Suffix_RFV"
runat="server"
ErrorMessage=" Required"
ControlToValidate="IN_RMTB2"
Display="Dynamic" />
</EditItemTemplate>
Notice that the ControlToValidate property says "IN_RMTB2" when it should say "IN_RMTB".
Webpage Script Errors
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; WOW64; Trident/4.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.21022; InfoPath.2; .NET CLR 3.0.30618; .NET CLR 3.5.30729)
Timestamp: Fri, 19 Dec 2008 03:36:23 UTC
Message: 'this.cells.0.offsetHeight' is null or not an object
Line: 23984
Char: 1
Code: 0
URI: http://localhost/BookingSystem/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ScriptManager1_HiddenField&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d3.5.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3a8ac4a3ed-a467-4f19-a8ed-9270f6e4c6d6%3a52817a7d%3a67c678a8%3bTelerik.Web.UI%2c+Version%3d2008.3.1125.35%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aen-US%3afd794f69-50b6-4e80-a52c-60fb1a05429c%3a393f5085%3a34f9d57d%3a9703c1f0%3aa3f85c94%3a665c7bcf%3a526d426%3a80c4ad6d%3a527acb41%3adfae2b2d%3a414de951%3a6f2bcae9%3a604faffd%3ac4e0cafb%3a34a10845%3af41bbe47%3aa6b75cb4%3a81330300
Update: I've found that it only seems to be happening on the RadScheduler when it is grouped by the Room resource, and when the browser's language is set to nb-NO.
RadGrid1.ExportSettings.ExportOnlyData =
true;
RadGrid1.ExportSettings.IgnorePaging =
true;
RadGrid1.ExportSettings.OpenInNewWindow =
true;
RadGrid1.MasterTableView.ExportToExcel();
<
telerik:RadScriptBlock runat=server>
<
script type="text/javascript">
function pnlRequestStarted(ajaxPanel, eventArgs) {
if (eventArgs.EventTarget == "<%=ToolbarUniqueID %>") {
eventArgs.EnableAjax = false
;
}
}
</
script>
</
telerik:RadScriptBlock>
I'm passing the unique id of the Radtoolbar. Can I somehow get to the actual button value clicked inside of this routine?
Basically I'm lookign for logic that will allow me to do the following.
if button.value = ExporttoExcel
eventArgs.EnableAjax = false
else
eventArgs.EnableAjax = true
<configuration>
<property name="ImagesPaths">
<item>/PublishingImages/</item>
</property>
<property name="ImagesFilters">
<item>*.jp*</item>
<item>*.gif</item>
<item>*.png</item>
</property>
<property name="DocumentsPaths">
<item>/PDF/</item>
</property>
<property name="DocumentsFilters">
<item>*.pdf</item>
</property>
<property name="Skin">Default2006</property>
</configuration>
i can specify the ImagePaths, Is there an way to specify some custom SharePoint property for a list view?
regards
Sohail

I also added this JavaScript code to page...
<script type="text/javascript">
function ZoomOut()
{
alert("Hello");
var chart = document.getElementById("RadChart1");
chart.zoomOut();
//var chart = document.forms["form1"].RadChart1.ClientID;
//chart.zoomOut();
}
</script>
But I get the following error message when the page loads...
The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).
So I tried altering the following JavaScript to reach the RadChart1 control a different way...
<script type="text/javascript">
function ZoomOut()
{
alert("Hello");
var chart = document.getElementById("RadChart1");
chart.zoomOut();
}
</script>