I have been trying to find the simplest method for creating a column in my PivotGrid that displays the difference between the only other two columns being displayed in the PivotGrid. I thought this would be a 5 minute exercise that has taken me all afternoon to get to *sort of* work. I am wondering if I am going about this all wrong... let me know before you mentally get into all the details below.

What I ended up with was using a PivotGridAggregateField field, "DifferenceInHoursFromCMS", with a TotalFunction of "DifferenceFrom". The problem I am having with this is that it leaves this empty column in the output (seen in attached screenshot). Is there any way to hide that empty column?

More importantly, all I really want to see is this table structure:

Row 1, Column 1: CMS
Row 1, Column 2: G2
Row 1, Column 3: Difference

So, a sample might look like this:

15     10     5
25     22     3

It doesn't seem like this should be that hard. What is the easiest way to get that output?

Here is my grid:

    <telerik:RadPivotGrid ID="pvtCMStoG2" runat="server" DataSourceID="sqlCMStoG2TimesheetValidation" AllowPaging="True" PageSize="15" AggregatesLevel="1">
        <PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox" AlwaysVisible="True"></PagerStyle>
        <Fields>
            <telerik:PivotGridColumnField Caption="Source" DataField="Source" UniqueName="Source">
            </telerik:PivotGridColumnField>
            <telerik:PivotGridRowField Caption="Customer" DataField="CustomerIdentityString" UniqueName="CustomerIdentityString">
            </telerik:PivotGridRowField>
            <telerik:PivotGridAggregateField Aggregate="Sum" DataField="Hours" GrandTotalAggregateFormatString="" UniqueName="SumOfHours">
                <TotalFormat Axis="Rows" Level="0" SortOrder="Ascending" />
                <HeaderCellTemplate>
                    <asp:Label ID="lblHeader" runat="server" Text="Total Hours"></asp:Label>
                </HeaderCellTemplate>
            </telerik:PivotGridAggregateField>
            <telerik:PivotGridAggregateField Aggregate="Count" DataField="Hours" GrandTotalAggregateFormatString="" UniqueName="CountOfVisits">
                <TotalFormat Axis="Rows" Level="0" SortOrder="Ascending" />
                <HeaderCellTemplate>
                    <asp:Label ID="lblHeader" runat="server" Text="Service Count"></asp:Label>
                </HeaderCellTemplate>
            </telerik:PivotGridAggregateField>
            <telerik:PivotGridAggregateField Aggregate="Sum" DataField="Hours" GrandTotalAggregateFormatString="" UniqueName="DifferenceInHoursFromCMS">
                <HeaderCellTemplate>
                    <asp:Label ID="lblHeader" runat="server" Text="Difference in Hours"></asp:Label>
                </HeaderCellTemplate>
                <TotalFormat Axis="Columns" Level="0" SortOrder="Ascending" TotalFunction="DifferenceFrom" GroupName="CMS" />
            </telerik:PivotGridAggregateField>
        </Fields>
        <TotalsSettings RowGrandTotalsPosition="First" ColumnGrandTotalsPosition="None" />
        <ConfigurationPanelSettings EnableOlapTreeViewLoadOnDemand="True"></ConfigurationPanelSettings>
    </telerik:RadPivotGrid>

I have following radwindow defined on master page.

I try to open a page with anchor tags but it’s not working. But when I open page in the browser Anchor tags work fine.

 

Rad window:

<telerik:RadWindow ID="radWINDialogPostLogin" runat="server" Behavior="Close" ReloadOnShow="false"

                        Left="" VisibleTitlebar="True" Style="display: none;" Top="" Modal="False" Behaviors="Close,Move,Resize">

                  </telerik:RadWindow>

Can the MS Word Spell provider be run as a service rather than a user process?

I have a combo box that is loading its data from a webservice. When the user types in some letters the webservice uses these as a filter and returns only rows that match (using a "contains" sql call). This all works well.

I have also set "filter=contains" on the combobox so that the matching part of the filter is highlighted in the dropdown list. This looks very nice.

However, if the webservice finds no items because the filter eliminates all data (maybe the user types in ZZZZZ) then the webservice returns a single radcombobox item with value="" and text="Sorry, no match found". I also mark this item with "IsSeparator = True" so that I can style it appropriately on the client.

The problem is that the "filter=contains" filters out the "Sorry, no match found" item because it doesn't match the text "ZZZZZ"! So the user never sees my friendly message, they just get an empty dropdownlist.

If I turn off the filter=contains then the friendly message shows, but obviously I lose the highlighting in the dropdown to show how the user's input is matching up with the items in the list.

Is there a way to make the client-side "filter=contains" filter out everything except a certain item, or everything except separators?

Hello!

If I open a radwindow inside a radwindow. Just like on the attached picture, it works on all desktop browsers.

But when testing this on an iPad or iPhone, there is following problem:
If the inner Window is a lot of smaller it’s also working fine,
but when the inner window has nearly the same size (like in the picture), the
inner window will not center, it’s not fitting inside the window!

This problem only appears on Safari of iPhone / iPad. Android
and Desktop Browsers work fine!

Thank you!

Im trying to open a radwindow serverside using this code

RadWindow newWindow = new RadWindow();
newWindow.NavigateUrl = "RegistrationSent.aspx";
newWindow.Top = Unit.Pixel(22);
newWindow.VisibleOnPageLoad = true;
newWindow.Left = Unit.Pixel(0);
RadWindowManager1.Windows.Add(newWindow); 

when it runs, im getting a javascript error

Microsoft JScript runtime error: DOM Exception: INVALID_CHARACTER_ERR (5)

on this line

var _b4=($telerik.isIE)?document.createElement("<iframe name='"+_b3+"'>"):document.createElement("iframe");


im using Q1 2009 controls and IE9

I am trying to get the Ajax loading panel to work with a service that when they pick a person it does some active directory look-ups and save them to a database.  But I cannot get the control working with a textbox that has a service in it.

My text box has an autocomplete service in it that when they pick a name does a looup to AD then saves to DB.  Sometimes it takes quite a while for this to happen and I want to show a loading panel but it will not work with the service in there.  It blocks out my service.

Hi,

I've created a skin based off of the Metro skin using the Telerik Visual Style builder.

Iv'e downloaded and used a tool to put this skin into an assembly http://www.acdevsoftware.ch/Download/Default.aspx?lang=en#TOOLS

I have now put the following into my appSettings.

When my application runs however the skins don't seem to be rendering/showing up properly and i'm pretty stumped, your assistance is greatly appreciated.

Hi,

I have a case where I need to be able to turn scrolling on/off for a RadPane via javascript on the client.

I know there is a server side setting Scrolling="Both/None/X/Y".

Is there a way to do this client side?

Also I'll need this to work on an iPad as well and I noticed things are done slightly differently when mobile/touch is involved (RadTouchExtender css class etc).

Thanks,
Erik

Hi,

I trying to use a orgchart component with very large datatable, roughly about 20k records with a depth of 8

Trouble is at the moment its taking about 10 minutes for the page to render.  Any way to speed his up?

Thanks.