Hi,
I'm trying to implement xamPivotGrid with RIA Services. with below code. But pivotgrid does not return any data. I checked from code behind DataSource is showing Null value. But my Domain Source returning 22 records. Let me know if I need to do anything else in my code behind.
Please Help. Thanks in Advance.
<UserControl x:Class="BTSCSFManagement.CSFManagement"
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 "
mc:Ignorable="d"
d:DesignHeight="300" d:DesignWidth="400" xmlns:riaControls="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.DomainServices"
xmlns:my="clr-namespace: BTSCSFManagement.Web"
xmlns:ig="http://schemas.infragistics.com/xaml">
<Grid x:Name="LayoutRoot" Background="White">
<Grid.ColumnDefinitions>
<ColumnDefinition />
<ColumnDefinition Width="Auto" />
</Grid.ColumnDefinitions>
<riaControls:DomainDataSource AutoLoad="True" d:DesignData="{d:DesignInstance my:vwTranDetail, CreateList=true}" Height="0"
LoadedData="vwTranDetailDomainDataSource_LoadedData" Name="vwTranDetailDomainDataSource" QueryName="GetVwTranDetailsQuery" Width="0">
<riaControls:DomainDataSource.DomainContext>
<my:CSFContext />
</riaControls:DomainDataSource.DomainContext>
</riaControls:DomainDataSource>
<ig:XamPivotGrid
x:Name="pivotGrid"
Grid.Column="0"
DataSource="{Binding Source=vwTranDetailDomainDataSource, Path=Data}"
AllowCompactLayout="True" />
<ig:XamPivotDataSelector
x:Name="xamPivotDataSelector"
Grid.Column="1"
DataSource="{Binding Source=pivotGrid, Path=DataSource}" />
</Grid>
</UserControl>
Sandip
Hello,
Try it in this way:
xmlns:ig="http://schemas.infragistics.com/xaml"
xmlns:FlatData="clr-namespace:Infragistics.Olap.FlatData;assembly=InfragisticsSL4.Olap.FlatData.v10.2">
<Grid.Resources>
<riaControls:DomainDataSource x:Key="domainDataSource"
AutoLoad="True"
d:DesignData="{d:DesignInstance my:vwTranDetail, CreateList=true}"
LoadedData="vwTranDetailDomainDataSource_LoadedData"
Name="vwTranDetailDomainDataSource" QueryName="GetVwTranDetailsQuery">
<FlatData:FlatDataConnectionSettings x:Key="flatDataSettings"
ItemsSource="{Binding Source={StaticResource domainDataSource}, Path=Data}"/>
<FlatData:FlatDataSource x:Key="flatDataSource"
ConnectionSettings="{StaticResource flatDataSettings}">
<!-- Overriding the default meta attributes -->
<FlatData:FlatDataSource.CubesSettings>
<FlatData:CubeMetadata DataTypeFullName="[Your data items full type name here]" DisplayName="RIA Data">
</FlatData:CubeMetadata>
</FlatData:FlatDataSource.CubesSettings>
</FlatData:FlatDataSource>
</Grid.Resources>
DataSource="{StaticResource flatDataSource}"
DataSource="{StaticResource flatDataSource}"/>
Please note that in the data selector you wouldn’t have databases but the cube only. Also specify the full type name of your entity objects (the line with yellow background) in order to get friendly name to appear into cubes dropdown.
Plamen.
Thanks Palmen,
It's working at my end now. Thanks once again for quick turn around. :)