Telerik Forums
UI for WPF Forum
6 answers
106 views

Hi,

i would like to change the Field Displayname of Properties used in the Pivot-Fieldlist.

I tryed to use the AddingContainerNode Event from LocalDataSourceFieldDescriptionsProvider, but it's only possible to change the

display name like

    (e.ContainerInfo as PropertyInfoFieldInfo).DisplayName = "Test"

This works for the aggregate list, but in List of fields there is always the name of property visible.

I tryed to change also the caption of ContainerNode but there is no Setter implemented.

    e.ContainerNode.Caption ="Test";  //it's not possible, but ist seems to be there right way 

Is there another way to Change the Caption.

Thanks for help.

Best regards

Stephan

Vladimir Stoyanov
Telerik team
 answered on 16 Feb 2024
1 answer
13 views

Hi Team,

   I followed the online documentation of RadPersistenceFramework to persist the selected fields of  RadPivotFieldList.   It doesn't work!  Here's my code.

 

--xmal

                <pivot:RadPivotFieldList x:Name="pfAttributes" Grid.Row="0" telerik:PersistenceManager.StorageId="pvFields"
                                     VerticalAlignment="Stretch" HorizontalAlignment="Stretch" Width="250"
                                     DataProvider="{StaticResource DataProviderKeyMetrics}" />

--save layout

            IsolatedStorageProvider isoStorageProvider = new IsolatedStorageProvider();
            isoStorageProvider.SaveToStorage();

-- load layout

            IsolatedStorageProvider isoStorageProvider = new IsolatedStorageProvider();
            isoStorageProvider.LoadFromStorage();

 

            Thanks,

 

Martin Ivanov
Telerik team
 answered on 29 Jan 2024
4 answers
53 views

Hi all,

I have a question regarding calculated fields and the TotalFormat option DifferenceFromPrevious: I am using dates to compare previous values and obviously the first date compare values will be empty as there is no date to compare to (see the uploaded image). I would like to be able to remove empty columns.  How would I accomplish that? Also, is there an option to exclude the total columns?

Regards,

Chris

Vladimir Stoyanov
Telerik team
 answered on 15 Feb 2023
2 answers
54 views

Hi all,

I´ve attached a screenshot of a behaviour within the PivotGrid I do not understand. When adding a calculated field making use of the TotalFormat "PercentDifferenceFromPrevious", the underlying column used for the calculation is formatted as percentage value? How can I overcome this issue? Changing the NumberFormat within the PropertyAggregateDescription for "Sum of Sensitivity" does not have an effect.

 

EDIT: Placing the calculated field "%-Diff. Sensitivity" before the "Sum of Sensitivity" field using Drag&Drop on the values field of the PivotFieldList eliminates this bug. I can also set the number format of "Sum of Sensitivity" then as I wish to.

Could you suggest a walkaround for me?

Regards,

Chris

Vladimir Stoyanov
Telerik team
 answered on 14 Feb 2023
1 answer
39 views
 


Hi,

Our request relates to the solution “LocalDataSourceSerialization_WPF“  on PivotGrid/Serialization/LocalDataSourceProvider in your git examples.

When we run the following scenario, we get an exception (see the attached video) :

1. Run The solution.
2. Click on “Sum of quantity” to open the menu.
3. Click on “More Calculation Options...”.
4. Choose “% Of”.
5. Choose “Date-Month” as the Base field and one of the Base Items for example “June”.
6. Press Ok.
7. Click on “Save”.
8. The system crashed with the following error (attached image).

We would be happy if you would guide us on how we could overcome the problem.

 

Dilyan Traykov
Telerik team
 answered on 07 Mar 2022
0 answers
47 views

Hi,

I tried to use the RadGridView with an OData Endpoint. 

I took a look into the documentations but didn't find any good sample.

I tried it with the QueryableDataProvider.

But my data was not loaded. It always runs into an exception:

Constructing or initializing instances of the type DynamicClass1 with the expression (Param_0 != null) is not supported.

This Exception is thrown by the OData Client.

 

Below my simplified code:

 

View:


<Window x:Class="ODataClientTest.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"
        xmlns:oDataClientTest="clr-namespace:ODataClientTest"
        xmlns:pivot="http://schemas.telerik.com/2008/xaml/presentation/pivot"
        mc:Ignorable="d"
        Title="MainWindow" Height="450" Width="800"
        d:DataContext="{d:DesignInstance oDataClientTest:MainWindowViewModel}">
    <Grid>

        <Grid.RowDefinitions>
            <RowDefinition Height="*" />
        </Grid.RowDefinitions>

        <Grid.ColumnDefinitions>
            <ColumnDefinition Width="*" />
            <ColumnDefinition Width="Auto" />
        </Grid.ColumnDefinitions>
        
        <pivot:RadPivotGrid Grid.Row="0" Grid.Column="0" DataProvider="{Binding ReportElements}" />
        
        <pivot:RadPivotFieldList Grid.Row="0" Grid.Column="1" DataProvider="{Binding ReportElements}" />

    </Grid>
</Window>


ViewModel

 


using System.Diagnostics;
using Telerik.Pivot.Queryable;

namespace ODataClientTest;

public class MainWindowViewModel : BaseNotifyPropertyChanged
{
    public MainWindowViewModel()
    {
        MyOdataContext dataContext = new();

        ReportElements = new()
                         {
                             Source = dataContext.ReportElements,
                             DeferUpdates = true
                         };

        ReportElements.StatusChanged += (sender, args) =>
                                        {
                                            if (args.Error != default)
                                                Debugger.Break(); // Here I can see the exception
                                        };
    }

    public QueryableDataProvider ReportElements
    {
        get => GetValue<QueryableDataProvider>();
        set => SetValue(value);
    }
}

 

 

My Question now: Is there any way to connect my OData Source to a PivotGrid?

Unfortunalety I could not use the LocalDataProvider, as the OData API returns a lot of data which must be filtered beforehand.

 

I also tried to use the normal GridView with works perfectly with the QueryableDataServiceCollectionView. But: It does not fit our needs, like Grouping, Creating dynamic aggregates (sum, average, etc.).

We are currently using .Net 4.7.2.

 

Many thanks!


 

Sebastian
Top achievements
Rank 1
 asked on 23 Feb 2022
1 answer
101 views

I was wondering how I can create a new Aggregation Function and add it to this list of existing Functions in "More Aggregation Options"
In this article I see that they managed to create the 'Sqrt Of Sum' function in WinForms

-> https://docs.telerik.com/devtools/winforms/controls/pivotgrid/custom-aggregation

I would like to know how I can be doing the same to add an Aggregation Function in Options in PivotGrid WPF:

Explanatory Image below:

 

Thank you!

Dilyan Traykov
Telerik team
 answered on 06 Dec 2021
1 answer
86 views
Good morning people, I'm having problems trying to create a new Calculated Field or a new Aggregate Function.

I need to add a weighted average function with the values ​​using the last column of the PivotGrid as the weight.

I happen to make the examples from the documentation and even so, the examples don't even work, the Calculates in the component are not added. Is there another way to do this?
Dilyan Traykov
Telerik team
 answered on 06 Dec 2021
1 answer
67 views
Hello,

In RadPivotFieldList, how could we remove the NumberFormat part on the Dropdwnlist in the values part?

Thanks
Stenly
Telerik team
 answered on 10 Nov 2021
3 answers
69 views
In my pivot grid, I would like to display my configured formats item by item.


for example suppose I have already defined the format $ for item1, £ for item2 and m² for item3, I want to display this

Feat1
     Item1 $12 $13 $15 $19

     Item2 £22 £23 £25 £29

     Item3 32m² 33m² 35m² 39m²

instead of displaying them all in one global format as (currently possible)

     Item1 $12 $13 $15 $19

     Item2 22 $ 23 $ 25 $ 29

     Item3 32 $ 33 $ 35 $ 39

how could this be handled?

Thank you very much
Dilyan Traykov
Telerik team
 answered on 04 Nov 2021
Narrow your results
Selected tags
Tags
+? more
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?