Hi,
Our company(reportdev) wants to launch an OLAP analysis and reporting tool. Everything is going fine but we are now in need of a smart, intelligent and on the fly analytical powerfull pivot-grid that has capabilities of the followings to deliver our customer's needs satisfactorily:-
# Run-time pivoting
# Dril-down
# Export to excel, pdf etc.
# Formatted cell values incl. currency symbols, rounding upto n decimal places etc.
# Charting capabilities and so many more func.
We've tested lots of grids but Infragistics xamPivotGrid seems to be an ideal amongst them. I've downloaded and install the trial version of the grid(NetAdvantage_SilverlightDVWithSamplesAndHelp_20103.exe) and developing app using adomd connection followed by the sample CustomDataProvider .
Everything goes fine but,
Our customers want an option whether they would like to view custom-formatted cell data($#,##0.00;($#,##0.00)) by a check box click.
Also, there is a problem saying 'Message: Element is already the child of another element.' while exporting a large number of data rows(for more than 3 thousands) to excel but it works great for a small amount of rows.
Is it possible to fix them up, how?
Thnx,
- Sb.
Hi Todor,
I have checkboxes in each of the PivotCellControl and I have used the same technique as you have described above,
but the checkboxes are not getting correct bool value from the inside collection.
Can you please help me on this, I have used a boolaggregator to get the bool values in the flatdatasource.
Thanks
rakesh
Thanks, that was the problem and it now works
Hi
I can not see CellValueFormat resource defined. Definitely this can cause the problem
Todor
When I use:
<UserControl.Resources> <Style x:Key="ScaledCell" TargetType="ig:PivotCellControl"> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="ig:PivotCellControl"> <Grid> <Border x:Name="Root" BorderBrush="{TemplateBinding BorderBrush}" BorderThickness="{TemplateBinding BorderThickness}" Background="{TemplateBinding Background}" /> <Grid> <Grid.ColumnDefinitions> <ColumnDefinition Width="*" /> </Grid.ColumnDefinitions> <TextBlock Name="cellPresenter" Text="{Binding RelativeSource={RelativeSource TemplatedParent}, Path=Cell.Data, Converter={StaticResource CellValueFormat}}" Grid.Column="1" VerticalAlignment="Center" HorizontalAlignment="Left" Margin="5" /> </Grid> </Grid> </ControlTemplate> </Setter.Value> </Setter> </Style> </UserControl.Resources>
I am getting
Error: Unhandled Error in Silverlight Application Code: 4009 Category: ManagedRuntimeError Message: Element is already the child of another element.
Suggestions?
Hi Salam,
You can look at this post about creating data source with code behind.
Also to control connection string you can use follow code
xmlaDataSource.ConnectionSettings =
new AdomdConnectionSettings{ CatalogName="ww", ConnectionString="connstring"}
Regards,