I have managed to display my data in a pivot grid, now I want to prevent the user dragging the columns around - anyone know how to do this? Or at least, how to stop columns just disappearing if dragged to the wrong place!
I am using a flat DataSource as per the example given here: http://community.infragistics.com/forums/t/43319.aspx?PageIndex=2
I Solved!
Thanks! =D
What is the property to give the format "1,000.00" to the numeric data cells?
Thanks.
Hi
The easiest way to hide the filter area is to use code behind. The follow code show you how to hide filter area
pivotGrid.FiltersDropControl.Visibility = System.Windows.Visibility.Collapsed;
Of course there is a way to do this and in xaml, but procedure is a little bit complicated then one from code behind. It is related with new control template of the pivot grid.
About right justification you should apply new style for pivot cell control. Below is a sample.
1. Define new style resource
2. Set HorizontalContentAlignment property to Right
<Style x:Key="ScaledCell" TargetType="igPivot:PivotCellControl">
<Setter Property="HorizontalContentAlignment" Value="Right"/>
</Style>
Apply style to the grid
<igPivot:XamPivotGrid x:Name="pivotGrid" CellStyle="{StaticResource ScaledCell}">
</igPivot:XamPivotGrid>
Hi Todor,
Thanks - I found my error - I had pasted the Style code into UserControl.Resources instead of Grid.Resources!I have made the MeasureAreaSettings the same as Row and Column, so now all I have to do is hide the "Drop Filter Fields Here" area and right-justify the numeric population fields.
I tried to define a new style as shown below but it didn't work :(
<Style TargetType="igPivotPrim:FieldsDropAreaControl" x:Key="invisibleFieldStyle">
<Setter Property ="Visibility" Value="Collapsed"/>
You need to use the code from second my post. If you have troubles, please attach you sample project, so I can see what is going on.
Todor