Questions on UI for ASP.NET AJAX Forum

1 answer

141 views

I setup a header aggregate in a grouping but it seems to be coming up with the wrong sum total. Screenshot attached.

Very strange that the footer aggregates come up with the right total, but the header doesn't. Below is how I'm setting up the structure of the grid columns.

Private Sub BuildDataGrid(ByVal view As Views)

Try

Dim addColumn As Action(Of GridColumn) =

Sub(column) BottomSection(Of TMGrid)("dgView").MasterTableView.Columns.Add(column)

Dim addToGrouping As Action(Of GridColumn) =

Sub(column)

BottomSection(Of TMGrid)("dgView").MasterTableView.GroupByExpressions.Add(

New GridGroupByExpression(column)

)

End Sub

With BottomSection(Of TMGrid)("dgView")

.MasterTableView.Columns.Clear()

.MasterTableView.GroupByExpressions.Clear()

Select Case view

Case Views.Daily

TMGrid.AddBoundColumn(

addColumn,

Function() "tl_date",

Function() "Date",

Function() False,

Function() "{0:MMMM d}",

Sub(column)

Dim grouping As New GridGroupByExpression()

Dim selectDate As New GridGroupByField()

selectDate.FieldName = "tl_date"

selectDate.FieldAlias = "tl_date"

selectDate.FormatString = TMGrid.SHORT_DATE_FORMAT

selectDate.HeaderText = "DATE"

selectDate.HeaderValueSeparator = ": "

Dim selectTotalHours As New GridGroupByField()

selectTotalHours.FieldName = "te_hours"

selectTotalHours.FieldAlias = "te_hours"

selectTotalHours.HeaderText = "TOTAL HOURS"

selectTotalHours.Aggregate = GridAggregateFunction.Sum

selectTotalHours.FormatString = TMGrid.HOURS

selectTotalHours.HeaderValueSeparator = ": "

Dim groupByDate As New GridGroupByField()

groupByDate.FieldName = "tl_date"

groupByDate.FieldAlias = "tl_date"

grouping.SelectFields.Add(selectDate)

grouping.SelectFields.Add(selectTotalHours)

grouping.GroupByFields.Add(groupByDate)

'grouping.Expression = "tl_date [Date], Sum(te_hours) TotalHours [Total Hours] Group By tl_date"

BottomSection(Of TMGrid)("dgView").MasterTableView.GroupByExpressions.Add(grouping)

End Sub

)

TMGrid.AddBoundColumn(

addColumn,

Function() "tc_name",

Function() "ACTIVITY",

AddressOf RequireSubactivity,

Nothing,

addToGrouping

)

TMGrid.AddBoundColumn(

addColumn,

Function() "tsc_name",

Function() "SUBACTIVITY"

)

TMGrid.AddBoundColumn(

addColumn,

Function() "te_desc",

Function() "DESCRIPTION"

)

TMGrid.AddBoundColumn(

addColumn,

Function() "te_hours",

Function() "HOURS",

Function() True,

Function() "<a href='{0}'>{0:#0.00}</a>",

Sub(column)

column.ItemStyle.HorizontalAlign = HorizontalAlign.Right

column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right

column.FooterStyle.HorizontalAlign = HorizontalAlign.Right

column.Aggregate = GridAggregateFunction.Sum

column.FooterAggregateFormatString = "Total: {0:#0.00}"

End Sub

)

Case Views.Monthly

TMGrid.AddBoundColumn(

addColumn,

Function() "tl_monthname",

Function() "Month",

Function() False,

Nothing,

addToGrouping

)

TMGrid.AddBoundColumn(

addColumn,

Function() "tc_name",

Function() "ACTIVITY",

AddressOf RequireSubactivity,

Nothing,

addToGrouping

)

TMGrid.AddBoundColumn(

addColumn,

Function() "tsc_name",

Function() "SUBACTIVITY"

)

TMGrid.AddBoundColumn(

addColumn,

Function() "te_desc",

Function() "DESCRIPTION"

)

If (Convert.ToInt32(ViewState("ReportingMode")) = TMTERMSOptions.TMTERMSReportingModes.Daily) Then

TMGrid.AddBoundColumn(

addColumn,

Function() "te_hours",

Function() "HOURS",

Function() True,

Function() "{0:#0.00}",

Sub(column)

column.ItemStyle.HorizontalAlign = HorizontalAlign.Right

column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right

column.FooterStyle.HorizontalAlign = HorizontalAlign.Right

column.Aggregate = GridAggregateFunction.Sum

column.FooterAggregateFormatString = "Total: {0:#0.00}"

End Sub

)

Else

TMGrid.AddBoundColumn(

addColumn,

Function() "te_hours",

Function() "HOURS",

Function() True,

Function() "<a href='{0}'>{0:#0.00}</a>",

Sub(column)

column.ItemStyle.HorizontalAlign = HorizontalAlign.Right

column.HeaderStyle.HorizontalAlign = HorizontalAlign.Right

column.FooterStyle.HorizontalAlign = HorizontalAlign.Right

column.Aggregate = GridAggregateFunction.Sum

column.FooterAggregateFormatString = "Total: {0:#0.00}"

End Sub

)

End If

TMGrid.AddBoundColumn(

addColumn,

Function() "certified_message",

Function() "CERTIFICATION"

)

TMGrid.AddBoundColumn(

addColumn,

Function() "approved_message",

Function() "APPROVAL"

)

TMGrid.AddBoundColumn(

addColumn,

Function() "te_approved_hours",

Function() "APPROVED HOURS",

Function() "{0:#,##0.00}"

)

Case Views.Annual

TMGrid.AddBoundColumn(

addColumn,

Function() "tl_year",

Function() "YEAR",

Function() False,

Nothing,

addToGrouping

)

TMGrid.AddBoundColumn(

addColumn,

Function() "tc_name",

Function() "YEAR / ACTIVITY",

AddressOf RequireSubactivity,

Nothing,

addToGrouping

)

TMGrid.AddBoundColumn(

addColumn,

Function() "tsc_name",

Function() "YEAR / ACTIVITY / SUBACTIVITY"

)

TMGrid.AddBoundColumn(

addColumn,

Function() "te_hours",

Function() "HOURS",

Function() "{0:#,##0.00}"

)

End Select

End With

Catch ex As Exception

Throw New Exception("BuildDataGrid procedure failed", ex)

End Try

End Sub

Grid

answered on 05 Jul 2011

4 answers

382 views

Tooltip working on mouseover but not for onclick event

Hi, i am trying to fire a tooltip which contains few linkbuttons when i click a rad grid row. However buttons in the tooltip works fine on mouseover event but none of the buttons work when i change the showevent as "Onclick"

ToolTip

answered on 05 Jul 2011

2 answers

99 views

[Solved] Avoid multiple DockPositionChanged events

Hi there,

Let's imagine, that we have five docked controls in one dock zone and five in second. If I move the top docked control from one zone into another I get 10 dockpositionchanged handler executions. Because I have some custom logic after each execution, handled agains database, this cause 10 executions of stored procedure behind, instead of one. Is there any way to allow this handler to be executed only for docked control currently dragged or may be any property, that might help to determine the dragged control and skip others. Thanks.

With best regards,
Stanislav

Dock

answered on 05 Jul 2011

2 answers

82 views

The RadScriptManager is incompatible with the Ajax Control Toolkit (Version number 40412 and higher)

Hi,
I am developing application in Dot Net 4.0. I am using Telerik RadControls for ASP.NET Ajax version 2010.3.1317.40 and AjaxControlToolkit version 4.1.40412.2
I have used RadAjaxManager in my page. But it gives script error. Earlier with AjaxControlToolkit version 1.0.10301.0 it was working fine.

I tried the fix provided by telerik admin
<telerik:RadScriptManager runat="server" EnableScriptCombine="false" /> but still error is comming.

Guide me to resolve this issue asap.

Ajax

answered on 05 Jul 2011

9 answers

764 views

[Solved] Radupload how save in binary

how to store the attachment file in stored to database

Thanks,
Mohamed.

Upload (Obsolete)

answered on 05 Jul 2011

1 answer

128 views

[Solved] Databinding of ImageURL

Hi,

Following on from this old thread http://www.telerik.com/community/forums/aspnet-ajax/combobox/databinding-an-image-inside-of-a-radcombobox.aspx

There are a couple of methods for having images inside a combo box including using ImageURL in the ItemDataBound event and using templates. The user was asking if there will be a way to add an DataImageURLField tag to the RadComboBox. If there are tags for a DataTextField and a DataValueField then why not the ImageURL as well given that it is available in the item data bound event.

Please could this be raised as a request for addition. It must be fairly simple to add and will save us having extra code in the itemdatabound event.

Regards,

Jon

ComboBox

answered on 05 Jul 2011

3 answers

127 views

exported data mismatch in pdf and excel in radgrid

i have a radgrid ,inside the the grid i am adding a commanditem template .Inside that commanditemtemplate i am adding three labels above the header .But when i am exporting the grid to pdf ,csv and excel the commanditemtemplate is appearing in exported excel file only ,but not in pdf and csv.Below is the code i am using:

<telerik:RadGrid ID="ModifiedContentsReportGrid" runat="server" AutoGenerateColumns="false"
AllowSorting="true" AllowPaging="true" EnableOutsideScripts="true" PagerStyle-Mode="NextPrevAndNumeric"
ShowFooter="true" OnItemCreated="ModifiedContentsReportsGrid_OnItemCreated" Title="Modified Content Report">
<ExportSettings OpenInNewWindow="true" FileName="Modified Content Report" ExportOnlyData="false">
<Pdf PaperSize="A4" AllowPrinting="true" PageBottomMargin="10px" PageTopMargin="25px"
PageHeaderMargin="0px" PageLeftMargin="10px" PageRightMargin="10px" PageTitle="Modified Content Report" />
</ExportSettings>
<HeaderStyle HorizontalAlign="Center" />
<ClientSettings>
<Scrolling UseStaticHeaders="true" />
</ClientSettings>
<MasterTableView Width="100%" CommandItemDisplay="Top" CommandItemStyle-HorizontalAlign="Right" >
<CommandItemTemplate>
<table width="100%">
<tr align="right">
<td>
<asp:Label ID="lblClientName" runat="server" Text="" />
</td>
</tr>
<tr align="right">
<td>
<asp:Label ID="lblGenerateDate" runat="server" Text="" />
</td>
</tr>
<tr align="right">
<td>
<asp:Label ID="lblDateRange" runat="server" Text="" />
</td>
</tr>
</table>
</CommandItemTemplate>

Could anyone provide some solution to this problem??

Grid

answered on 05 Jul 2011

1 answer

247 views

RadEditior Image width & height fixed

Hi,

I am trying to fix the widht and height of the image chosen in telerik RadEditior, i have tried with both Javascript and C# code saperately which i found in forums, but could not resolve.
I am using V.S 2010 and telerik product version 2009.3.1103.35.

Javascript used:

function OnClientLoad(editor, args) {

editor.attachEventHandler(

"oncontrolselect", function () {

//Check if image

window.setTimeout(

function () {

var selElem = editor.getSelection().getParentElement();

alert(selElem.tagName);

if (selElem.tagName == "IMG") {

//Store current width and height

curWidth = selElem.offsetWidth;

curHeight = selElem.offsetHeight;

//Possible to resize, so attach eventhandler

selElem.onresizeend =

function (e) {

alert("I was resized");

selElem.style.width = "150";

selElem.style.height ="150";

selElem.onresizeend = null; //remove handler

//Make calculations about skaling, then re-size image

};

}

}, 0);

});

}
Code used in C#

The one which i have found in these attachements,
In page_load
{ string [] paths = new string[] { "~/Images/editor" };

RadEditor1.ImageManager.ViewPaths = paths;

RadEditor1.ImageManager.UploadPaths = paths;

RadEditor1.ImageManager.DeletePaths = paths;

RadEditor1.ImageManager.ContentProviderTypeName =

typeof(ChangeImageSizeProvider).AssemblyQualifiedName;
}

public class ChangeImageSizeProvider : Telerik.Web.UI.Widgets.FileSystemContentProvider
{

public ChangeImageSizeProvider(HttpContext context, string[] searchPatterns, string[] viewPaths, string[] uploadPaths, string[] deletePaths, string selectedUrl, string selectedItemTag)

: base(context, searchPatterns, viewPaths, uploadPaths, deletePaths, selectedUrl, selectedItemTag)

{

}

public override string StoreFile(UploadedFile file, string path, string name, params string[] arguments)

{
System.Drawing.Image image = System.Drawing.Image.FromStream(file.InputStream);

string physicalPath = Context.Server.MapPath(path);
int newWidth = 100;// Fixed width
int newHeight = 100;// Fixed height

System.Drawing.Image resultImage = ResizeImage(image, new Size(newWidth, newHeight));

resultImage.Save(physicalPath + name);

string result = path + name;
return result;

}

private System.Drawing.Image ResizeImage(System.Drawing.Image sourceImage, Size newSize)

{

Bitmap bitmap = new Bitmap(newSize.Width, newSize.Height);
Graphics g = Graphics.FromImage((System.Drawing.Image)bitmap);

g.InterpolationMode = InterpolationMode.HighQualityBicubic;

g.DrawImage(sourceImage, 0, 0, newSize.Width, newSize.Height);

g.Dispose();

return (System.Drawing.Image)bitmap;

}

I have a save option with which i am saving

asdf.Content = this.RadEditor1.Content;

asdf.save();

Please let me know, if I need to do anything else.

Thanks
G Krishna

Editor

answered on 05 Jul 2011

1 answer

70 views

Q2 Beta script error

I have a simple page with a toolbar on the masterpage and a treeview in the content page

I'm getting this error in firebug when paging, and doing random things like sorting

<%@ Page Title="" Language="C#" MasterPageFile="~/App_Master/Medportal.master" AutoEventWireup="true" CodeBehind="TreeList.aspx.cs" Inherits="Medportal.Skins.Medportal.Controls.TreeList" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeaderContent" runat="server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="BodyContent" runat="server">

<telerik:RadTreeList runat="server" DataKeyNames="locationID"

DataSourceID="locationsDS" ParentDataKeyNames="parentID"

AllowMultiColumnSorting="True" AllowPaging="True" AllowSorting="True"

PageSize="15" ShowFooter="True" >

<PagerStyle Mode="NextPrevNumericAndAdvanced" />

</telerik:RadTreeList>

<asp:SqlDataSource ID="locationsDS" runat="server"

ConnectionString="<%$ ConnectionStrings:authdbConnectionString %>"

SelectCommand="SELECT [locationID], [locationName], [parentID], [shortcode], [isTest], [addressID] FROM [common_location] ORDER BY [locationName]" />

</asp:Content>

Any idea?

TreeList

answered on 05 Jul 2011

3 answers

159 views

cant increase the Height of Menu

i want to increase the weight of telerik menu , i wan to make its heights similar as telerik offical website's menu
but i am unable to do so .
if height increase by increasing items height or generally increasing the height of menu bar from properties , the rollover gets distorted ,and also the looks ,last i was trying the below

<div style=

"width: 1130px; height:auto; position: relative; richness:100; top: 0px; left: 95px; color: #EEF1CD; background-color: #F7FAFE"

>

<telerik:RadMenu ID="RadMenu1" runat="server" Skin="Vista" Width="1130px"

EnableRoundedCorners="True" style="top: 0px; left: 0px; "

Font-Size="Large" Height="50px" BackColor="White"

>

<Items>

<telerik:RadMenuItem runat="server" Text="Root RadMenuItem1" width ="200" >

</telerik:RadMenuItem>

<telerik:RadMenuItem runat="server" Text="Root RadMenuItem2" width ="200" >

</telerik:RadMenuItem>

<telerik:RadMenuItem runat="server" Text="Root RadMenuItem3" width ="200" >

</telerik:RadMenuItem>

<telerik:RadMenuItem runat="server" Text="Root RadMenuItem4" width ="200" >

</telerik:RadMenuItem>

<telerik:RadMenuItem runat="server" Text="Root RadMenuItem5" width ="200" >

</telerik:RadMenuItem>

</Items>

</telerik:RadMenu>

</div>

Menu

answered on 05 Jul 2011