Thanks for the response Petar Monov

I explained myself badly, what I want is to use the data to populate a XamPivotGrid XamPieChart, like I do with XamDataChart. Is it possible?

my code is:

<UserControl x:Class="Eticadata_2.MainPage"
    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="542"
    d:DesignWidth="1273" 
    xmlns:olap="http://schemas.infragistics.com/olap"            
    xmlns:ig="http://schemas.infragistics.com/xaml"
    xmlns:m="clr-namespace:Infragistics.Controls.Charts;assembly=InfragisticsSL5.Controls.Charts.OlapAxis.v11.2"
            
             HorizontalContentAlignment="Center"
             VerticalContentAlignment="Center"
             HorizontalAlignment="Left"
             xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk"
             DataContext="{Binding}">

    <Grid x:Name="LayoutRoot">
        <Grid.ColumnDefinitions>
            <ColumnDefinition Width="888*" />
            <ColumnDefinition Width="0*" />
        </Grid.ColumnDefinitions>
        <Grid.Resources>
            <olap:XmlaDataSource x:Key="xmlaDataSource"
                                 ServerUri="http://localhost/olap/msmdpump.dll" >

            </olap:XmlaDataSource>
        </Grid.Resources>
        <TextBlock Height="Auto" Margin="7,25,9,0"
                   Name="textBlock1"
                   Text="XXXXX"
                   VerticalAlignment="Top" FontWeight="Bold"
                   FontSize="13"
                   TextAlignment="Center" Foreground="Cornsilk" />
       
        <Image Height="32"
               HorizontalAlignment="Left"
               Name="image1"
               Stretch="Fill"
               VerticalAlignment="Top"
               Width="90"
               Margin="8,4,0,0"
               Source="XXXXX" />
       
        <sdk:TabControl Height="488"
                        HorizontalAlignment="Left"
                        Margin="0,42,0,0"
                        Name="tabControl1"
                        VerticalAlignment="Top"
                        Width="1264">
           
            <sdk:TabItem Header="Selecionar Opções" Name="tabItem1">
                  <Grid>
                   
                    <ig:XamPivotDataSelector HorizontalAlignment="Stretch"
                                             Margin="3,0,0,6"
                                             Name="xamPivotDataSelector1"
                                             VerticalAlignment="Stretch"
                                             DataSource="{StaticResource xmlaDataSource}"
                                             HorizontalContentAlignment="Left"
                                             VerticalContentAlignment="Top" />
               
                 </Grid>
               
            </sdk:TabItem>
           
            <sdk:TabItem Header="Dados: Tabela" Name="tabItem2">
                <Grid>
                    <ig:XamPivotGrid DataContext="{Binding}"
                                     DataSource="{StaticResource xmlaDataSource}"
                                     HorizontalAlignment="Right"
                                     HorizontalContentAlignment="Stretch"
                                     Margin="0,1,0,6"
                                     Name="xamPivotGrid1"
                                     VerticalAlignment="Stretch"
                                     VerticalContentAlignment="Stretch"
                                     Width="1251" />
              
                </Grid>
            </sdk:TabItem>
           
            <sdk:TabItem    Header="Dados: Gráfico de barras"
                                    Name="tabItem3">
               
                <ig:XamDataChart x:Name="xmOlapDataChart1"
                                 Height="402"
                                 Width="1254"
                                 IsEnabled="True"
                                 HorizontalContentAlignment="Stretch"
                                 VerticalContentAlignment="Stretch"
                                 Margin="0"
                                 HorizontalAlignment="Stretch"
                                 VerticalAlignment="Stretch" IsSquare="False" VerticalZoombarVisibility="Visible" HorizontalZoombarVisibility="Visible" HorizontalZoomable="True" VerticalZoomable="True">
                   
                    <ig:XamDataChart.Axes>
                        <m:OlapXAxis x:Name="olapXAxis"
                                 DataSource="{StaticResource xmlaDataSource}"
                                 OlapAxisSource="Rows"        
                                 YAxis="{Binding ElementName=yAxis}"
                        AutoGenerateSeries="True"/>

                        <ig:NumericYAxis Name="yAxis"/>
                    </ig:XamDataChart.Axes>

                    <ig:XamDataChart.Series>
                        <ig:OlapColumnSeries Title="Series1"
                                     YAxis="{Binding ElementName=yAxis}"
                                     OlapXAxis="{Binding ElementName=olapXAxis}"
                                     ValueMemberPath="Europe"/>

                        <ig:OlapColumnSeries Title="Series2"
                                     YAxis="{Binding ElementName=yAxis}"
                                     OlapXAxis="{Binding ElementName=olapXAxis}"
                                     ValueMemberPath="Units"/>
                    </ig:XamDataChart.Series>
                   
                </ig:XamDataChart>

            </sdk:TabItem>
        </sdk:TabControl>
        <Grid.Background>
            <LinearGradientBrush EndPoint="1,0.5"
                                 StartPoint="0,0.5">
                <GradientStop Color="Black"
                              Offset="0" />
                <GradientStop Color="#00CC7931"
                              Offset="1" />
            </LinearGradientBrush>
        </Grid.Background>
       
    </Grid>
</UserControl>

best regard

sseixas

Hello Yohan,

Thank you for your post. I have been looking into it and I modified the sample Peter has uploaded, so now it works correctly. Basically I changed the way the DataSource’s ResultChanged event was handled.

Hope this helps you.

Hi Petar,

Thanks for providing the code. However when i try to run the project i get an error saying 

Error 1 Cannot implicitly convert type 'System.EventHandler<System.ComponentModel.AsyncCompletedEventArgs>' to 'System.EventHandler<Infragistics.Olap.ResultChangedEventArgs>' 

Below is the error line of code.

pivotGrid.DataSource.ResultChanged += new EventHandler<System.ComponentModel.AsyncCompletedEventArgs>(DataSource_ResultChanged);

Can you help me out.

Regards,

Yohan

Hi sseixas,

I am really glad to hear that. If you don’t have any further questions on the matter, please verify the thread as answered so other users can find it more easily and take advantage of it as well.

Hello Petar Monov

Excelente response. Thanks.

It´s great fine :-)

Best Regards

sseixas