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
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();
Thanks,
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
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
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.
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!
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!