Hi,

I am exporting RadGridView data to excell.

I wanted to know, how to export data of aggregate function in excell sheet.

My XAML page is:

<telerik:GridViewDataColumn Header="Investment Category Name" DataMemberBinding="{Binding InvestmentCategoryName}" IsVisible="False"   />
                <telerik:GridViewDataColumn Header="Asset Class Name" DataMemberBinding="{Binding AssetClassName}"  IsVisible="False"  />
                <telerik:GridViewDataColumn Header="Sbu" DataMemberBinding="{Binding SbuName}" Width="125" TextWrapping="Wrap"/>
                <telerik:GridViewDataColumn Header="Total Value" DataMemberBinding="{Binding TotalValue, StringFormat={}{0:c}}" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap">
                    <telerik:GridViewDataColumn.AggregateFunctions>
                        <telerik:SumFunction Caption="Total :" ResultFormatString="{}{0:c}" />
                    </telerik:GridViewDataColumn.AggregateFunctions>
                </telerik:GridViewDataColumn>
                <telerik:GridViewDataColumn Header="Target Min" DataMemberBinding="{Binding TargetMin, StringFormat={}{0:n2}}"  HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>
                <telerik:GridViewDataColumn Header="Target Max" DataMemberBinding="{Binding TargetMax, StringFormat={}{0:n2}}"  HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>
                <telerik:GridViewDataColumn Header="Target Total" DataMemberBinding="{Binding TargetTotal, StringFormat={}{0:n2}}"  HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>
                <telerik:GridViewDataColumn Header="Total Actual" DataMemberBinding="{Binding TotalActual, StringFormat={}{0:n2}}"  HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>
                <telerik:GridViewDataColumn Header="Variance" DataMemberBinding="{Binding Variance, StringFormat={}{0:n2}}"  HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap">


Please, let me know any quick solution to this.

Regards,
Hirak

Hello,
I've googled a bit around but was not able to find an answer.... do WPF enabled GPU acceleration for normal UI Controls as GridViews? or just for multimedia usercontrols? Thanks

Paolo

Hello,

my ItemsSouce is a Dictonary (Dictionary<DateTime, Dictionary<Enum, long>).

With this i want display data by a StackedBar100. My DateTime should be the XCategory and the nested Dictionary the stacked values. My ItemsSource is binded via MVVM.

How can i bind this?

Thanks in advance

Ralf

Hi all,

My client requirement is make filter behavior as in winForm( there is one row under column header. there is one textbox and filter button in each column row)  for some RadGridView in WPF app. Need still use wpf's RadGridview not host winForm's RadGridview.
 
If there is a property to set or I should custom RadGridView ? How do I implement it?  Thanks


Good luck
zacky

I have a sparkline bound to an observable collection created from entity framework data

Y values used are a nullable double.

All works fine until a bound value is changed.

If value is say 12.5 and set to 14.7, works ok, spakline is updated
however
If value is changed from 12.5 to null and exception is thown - stack trace below

   at Telerik.Windows.Controls.Sparklines.DataPointsCollectionView.OnItemPropertyChanged(Object sender, PropertyChangedEventArgs e) in c:\Builds\WPF_Scrum\Release_WPF\Sources\Development\Controls\DataVisualization\Sparklines\Data\DataPointsCollectionView.cs:line 251
   at System.ComponentModel.PropertyChangedEventHandler.Invoke(Object sender, PropertyChangedEventArgs e)
   at System.Data.Objects.DataClasses.StructuralObject.OnPropertyChanged(String property)
   at System.Data.Objects.DataClasses.EntityObject.ReportPropertyChanged(String property)
   at RatifTest2.Data.SampleData.set_NO(Nullable`1 value) in C:\DEV\AQ Modernisation\RatifTest2\RatifTest2\Data\RatModel.Designer.cs:line 220

If the sparkline is taken out of the equation and the data bound to say a RadGridView, setting value to null is handled correctly

How to add icon in dropdown menu?

Hi,
From your WPF Demo \ "Data Virtualization\ First Look"  (2011 - Q1 ),
I think there is bug behavior with the VirtualQueryableCollectionView if i try to filter with more than one field it's give me wrong result,
or if I apply filter in one field then cancel it and apply filter again with other field it's give me the first result.

any help?

Best regards,

I have RadGrid into RadExpander and grid's scrollbars don't work. I see them, but they are not active.
Here is my code, please tell me where my mistake is?

Hi Guys,

reffering to your WPF-Demo "Tree to Grid Drag": How can I prevent
a Drag-Operation from the GridView by dragging the Header instead of
the item?

The behavior makes no sense. In your corresponding Silverlight-Example
you can´t drag the Header.

Bye, Michael

Hi there,

I'm having a problems with the transitions in this particular scenario:
I want to change in code behind the Content of my RadTransitioncontrol, as well as the ContentTemplate and the Transition.
So i wrote the following code:


But the transition doesn't work in two cases:
1) The first time i change to TILE mode
2) Every time i change to TILE mode after a NotifyPropertyChanged of the Property "ImageSrc" happend.

Some help would be nice,
Thanks,
Ângelo Moreira.