Questions on UI for WPF Forum

4 answers

137 views

Exporting Hierarchical RadGridView Data shwoing Error

Hi,

I am using a Telerik RadGridView controls for my WPF Windows application.

My requirement is I want to export data from Hierarchical RadGridView to Excel. But, while exporting I am getting few errors as attached.

Any quick help on this will be highly appreciated.

Thanks & Regards,
Hirak

private void ExporttoExcel_Click(object sender, RoutedEventArgs e)

{

//RadGridNonMarketableSummary.Export(

Telerik.Windows.Controls.ExportFormat format = Telerik.Windows.Controls.ExportFormat.Html;

System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("nb-NO");

SaveFileDialog dialog = new SaveFileDialog()

{

DefaultExt = "xls",

Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", "xls", "Excel"),

FilterIndex = 1

};

if (dialog.ShowDialog() == true)

{

using (Stream stream = dialog.OpenFile())

{

Telerik.Windows.Controls.GridViewExportOptions exportOptions = new Telerik.Windows.Controls.GridViewExportOptions();

//RadGridNonMarketableSummary exportOptions = new RadGridNonMarketableSummary();

// RadGridView exportOptions = new GridView();

exportOptions.Format = format;

exportOptions.ShowColumnFooters = true;

exportOptions.ShowColumnHeaders = true;

exportOptions.ShowGroupFooters = true;

exportOptions.ShowColumnHeaders = true;

exportOptions.Culture = cultureInfo;

RadGridNonMarketableSummary.Export(stream, exportOptions);

}

private void RadGridNonMarketableSummary_ElementExporting(object sender, Telerik.Windows.Controls.GridViewElementExportingEventArgs e)

{

if (e.Element == Telerik.Windows.Controls.ExportElement.HeaderRow || e.Element == Telerik.Windows.Controls.ExportElement.FooterRow

|| e.Element == Telerik.Windows.Controls.ExportElement.GroupFooterRow)

{

//e.Background = HeaderBackgroundPicker.SelectedColor;

// e.Foreground = HeaderForegroundPicker.SelectedColor;

e.Background = Colors.LightGray;

e.Foreground = Colors.Blue;

e.FontSize = 20;

e.FontWeight = FontWeights.Bold;

}

else if (e.Element == Telerik.Windows.Controls.ExportElement.Row)

{

//e.Background = RowBackgroundPicker.SelectedColor;

//e.Foreground = RowForegroundPicker.SelectedColor;

e.Background = Colors.LightGray;

e.Foreground = Colors.Blue;

}

else if (e.Element == Telerik.Windows.Controls.ExportElement.Cell &&

e.Value != null && e.Value.Equals("Chocolade"))

{

e.FontFamily = new FontFamily("Verdana");

e.Background = Colors.LightGray;

e.Foreground = Colors.Blue;

}

else if (e.Element == Telerik.Windows.Controls.ExportElement.GroupHeaderRow)

{

e.FontFamily = new FontFamily("Verdana");

e.Background = Colors.LightGray;

e.Height = 30;

}

else if (e.Element == Telerik.Windows.Controls.ExportElement.GroupHeaderCell &&

e.Value != null && e.Value.Equals("Chocolade"))

{

e.Value = "MyNewValue";

}

else if (e.Element == Telerik.Windows.Controls.ExportElement.GroupFooterCell)

{

Telerik.Windows.Controls.GridViewDataColumn column = e.Context as Telerik.Windows.Controls.GridViewDataColumn;

Telerik.Windows.Data.QueryableCollectionViewGroup qcvGroup = e.Value as Telerik.Windows.Data.QueryableCollectionViewGroup;

if (column != null && qcvGroup != null && column.AggregateFunctions.Count() > 0)

{

e.Value = GetAggregates(qcvGroup, column);

}

private string GetAggregates(Telerik.Windows.Data.QueryableCollectionViewGroup group, Telerik.Windows.Controls.GridViewDataColumn column)

{

List<string> aggregates = new List<string>();

foreach (Telerik.Windows.Data.AggregateFunction f in column.AggregateFunctions)

{

foreach (Telerik.Windows.Data.AggregateResult r in group.AggregateResults)

{

if (f.FunctionName == r.FunctionName && r.FormattedValue != null)

{

aggregates.Add(r.FormattedValue.ToString());

}

return String.Join(",", aggregates.ToArray());

}

in XAML page I am using the following code:

<UserControl x:Class="SSG_TradeExpress.View.Trade.TradeNonMarketable"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"

xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"

xmlns:telerikControls="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls"

xmlns:Converters="clr-namespace:SSG_TradeExpress.View.Converters"

>

<UserControl.Resources>

<Converters:RangeToColorConverter x:Key="RangeConverter"></Converters:RangeToColorConverter>

</UserControl.Resources>

<Grid x:Name="GridNonMarketable" >

<telerik:RadGridView Grid.Row="0" x:Name="RadGridNonMarketableSummary" ElementExporting="RadGridNonMarketableSummary_ElementExporting" RowLoaded="RadGridNonMarketableSummary_RowLoaded" Loaded="RadGridNonMarketableSummary_Loaded" telerikControls:StyleManager.Theme="Office_Blue" IsReadOnly="True" ItemsSource="{Binding TradeNonMarketableData.NonMarketableSummaryModel}" IsFilteringAllowed="False" CanUserFreezeColumns="False" AutoGenerateColumns="False" AutoExpandGroups="True" >

<telerik:RadGridView.ChildTableDefinitions>

<telerik:GridViewTableDefinition />

</telerik:RadGridView.ChildTableDefinitions>

<telerik:RadGridView.RowStyle>

<Style TargetType="{x:Type telerik:GridViewRow}">

<Setter Property="IsExpanded" Value="True"/>

</Style>

</telerik:RadGridView.RowStyle>

<telerik:RadGridView.Columns>

<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">

<telerik:GridViewDataColumn.CellStyle>

<Style TargetType="telerik:GridViewCell">

<Setter Property="Foreground" Value="{Binding TotalRange, Converter={StaticResource RangeConverter}}" />

</Style>

</telerik:GridViewDataColumn.CellStyle>

</telerik:GridViewDataColumn>

<telerik:GridViewDataColumn Header="Total Range" DataMemberBinding="{Binding TotalRange}" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap">

<telerik:GridViewDataColumn.CellStyle>

<Style TargetType="telerik:GridViewCell">

<Setter Property="Foreground" Value="{Binding TotalRange, Converter={StaticResource RangeConverter}}" />

</Style>

</telerik:GridViewDataColumn.CellStyle>

</telerik:GridViewDataColumn>

</telerik:RadGridView.Columns>

<telerik:RadGridView.HierarchyChildTemplate>

<DataTemplate>

<telerik:RadGridView x:Name="RadGridNonMarketableDetail" telerikControls:StyleManager.Theme="Windows7" CanUserFreezeColumns="False" AutoGenerateColumns="False" IsFilteringAllowed="False" ItemsSource="{Binding NonMarketableDetailModel}" ShowGroupPanel="False" IsReadOnly="True">

<telerik:RadGridView.Columns>

<telerik:GridViewDataColumn DataMemberBinding="{Binding FundName}" Header="Fund Name" Width="200" TextWrapping="Wrap"/>

<telerik:GridViewDataColumn Header="Value / Unadjusted Value" HeaderTextAlignment="Right" TextAlignment="Right" Width="150" TextWrapping="Wrap" >

<telerik:GridViewDataColumn.CellTemplate>

<DataTemplate>

<StackPanel Orientation="Horizontal">

<TextBlock Text="{Binding Value,StringFormat={}{0:c}}"></TextBlock>

<TextBlock Text=" / "></TextBlock>

<TextBlock Text="{Binding UnAdjustedValue,StringFormat={}{0:c}}"></TextBlock>

</StackPanel>

</DataTemplate>

</telerik:GridViewDataColumn.CellTemplate>

</telerik:GridViewDataColumn>

<telerik:GridViewDataColumn DataMemberBinding="{Binding ValueDate, StringFormat={}{0:d}}" Header="Value Date" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding TotalActual, StringFormat={}{0:n3}}" Header="Total Actual" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding FundCode}" Header="Fund Code" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding CalledToDate, StringFormat={}{0:c}}" Header="Called To Date" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding Commitment, StringFormat={}{0:c}}" Header="Commitment" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding TotalDistributions, StringFormat={}{0:c}}" Header="Total Distributions" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding ToBeCalled, StringFormat={}{0:c}}" Header="To Be Called" HeaderTextAlignment="Right" TextAlignment="Right" Width="90" TextWrapping="Wrap"/>

</telerik:RadGridView.Columns>

</telerik:RadGridView>

</DataTemplate>

</telerik:RadGridView.HierarchyChildTemplate>

</telerik:RadGridView>

<!--<telerik:RadButton Name="ExporttoExcel" Margin="722,-33,0,0" Style="{DynamicResource NormalButtonStyle}" Content="Export to Excel"  Command="{Binding ExportToExcelCommand}" Width="102" HorizontalAlignment="Right" VerticalAlignment="Top" Height="27" CommandParameter="{Binding}"/>-->

<telerik:RadButton Name="ExporttoExcel" Margin="722,-33,0,0" Style="{DynamicResource NormalButtonStyle}" Content="Export to Excel" Width="102" HorizontalAlignment="Right" VerticalAlignment="Top" Height="27" Click="ExporttoExcel_Click"/>

</Grid>

</UserControl>

GridView

answered on 20 Apr 2011

5 answers

139 views

[Solved] Format Expressions: What expressions are available, eg. {C2}

Hi,

I'm reading http://www.telerik.com/help/wpf/radchart-features-format-expressions.html. The bottom of the article displays a table of examples of format expressions, eg. {C2}, however I'm unable to find an article that definitively lists all of the format expressions that are available (I would have expected this list in this help article titled "Format Expressions"). I found an example of {D} for date and guessed {T} for time, but don't know what additional formatting options there are.

In particular, I'm trying to display the Y-value in a tooltip using region specific formatting delimiters. For example, while I'm able to use {0.0} to format a number with at least one integer digit and one place after the decimal point, the region I'm working in uses a comma as a decimal point delimiter. If I try to use {0,0}, I only get one integer digit in the tooltip with no "," and no digit after the decimal point.

What format expressions are available and can this information be added to the help (and I'm guessing this information is span across your chart control over different technologies).

I also don't know which circumstances I can use a token. For example, although the documentation at the top of the page seems to indicate that I can use the #LABEL and #LEGENDLABEL tokens in a tooltip, using it only displays the string "#LABEL" in the tooltip and using the #LEGENDLABEL token displays the raw, unformatted Y value in the tooltip. I'm looking to display the label of the series displayed in the legend along with the Y-value in the tooltip so that it is easy to distinguish which series you are hovering over when there are multiple series on the chart.

Kind regards,
Dave.

Chart

answered on 20 Apr 2011

1 answer

170 views

Tabbing Order in RadComboBox

Hello Telerik Team,

In control template i have wpf grid with four columns. And each column contains listbox. Each listbox contains 5 items. How do i use tabbing order?

I am setting OpenDropDownOnFocus="True"
Now when i press Tab key, RadCombobox closed.

Any help would be highly appreciated.

Regards,
Viral

ComboBox

answered on 20 Apr 2011

1 answer

530 views

Confirmation Message before delete or save an Item from DataGrid.

Hi,

Confirmation Message before delete or save an Item from DataGrid.
I used a telerik command for deletion of row from datagrid, but user should get a confirmation message before delete of row.
I tried attached code...

<telerik:RadGridView Grid.Row="2" x:Name="orderView" ItemsSource="{Binding Order}"

AutoGenerateColumns="False" CanUserDeleteRows="{Binding IsChecked, Mode=TwoWay, ElementName=CanUserDeleteRowsCheckBox}"

IsReadOnly="{Binding IsChecked, Mode=TwoWay, ElementName=IsReadOnlyCheckBox}" SelectionMode="Extended">

<telerik:RadGridView.Columns>

<telerik:GridViewToggleRowDetailsColumn />

<telerik:GridViewSelectColumn Header="Select" x:Name="chkbox" />

<telerik:GridViewDataColumn DataMemberBinding="{Binding CustomerName}" Header="Name" />

<telerik:GridViewDataColumn DataMemberBinding="{Binding Age}" Header="Age" />

<telerik:GridViewDataColumn DataMemberBinding="{Binding Path=COActivity.ActivityDescription}" Header="Age" />

</telerik:RadGridView.Columns>

</telerik:RadGridView>

<Button Content=" Delete" Style="{StaticResource GreyButtonStyle}" Command="telerik:RadGridViewCommands.Delete" CommandTarget="{Binding ElementName=gvCustomerOrder}">

<i:Interaction.Triggers>

<i:EventTrigger EventName="Click">

<cmd:EventToCommand Command="{Binding Path=DeleteCustomerOrderCommand}" PassEventArgsToCommand="True" />

</i:EventTrigger>

</i:Interaction.Triggers>

</Button>

private RelayCommand<RoutedEventArgs> _deleteCustomerOrderCommand;

public RelayCommand<RoutedEventArgs> DeleteCustomerOrderCommand

{

get

{

if (_deleteCustomerOrderCommand == null)

{

_deleteCustomerOrderCommand = new RelayCommand<RoutedEventArgs>(param => this.DeleteCustomerOrder(param), param => this.CanDeleteCustomerOrder());

}

return _deleteCustomerOrderCommand;

}

private void DeleteCustomerOrder(RoutedEventArgs e)

{

}

private bool CanDeleteCustomerOrder()

{

string messageBoxText = "Are you sure you want to delete the selected Orders?";

string caption = "Confirm";

MessageBoxButton button = MessageBoxButton.YesNo;

MessageBoxImage icon = MessageBoxImage.Question;

MessageBoxResult result = MessageBox.Show(messageBoxText, caption, button, icon);

if (result == MessageBoxResult.Yes)

{

return true;

}

else

return false;

}

GridView

answered on 20 Apr 2011

1 answer

159 views

Internet Explorer Style Tabs (WPF)

Is there a simple way or an example to make/use an Internet Explorer or Firefox style tab control where clicking on the last empty short tab creates a new tab? In WPF, the new tab would display the same user control as other tabs (except the empty tab, of course). http://www.codeproject.com/KB/WPF/WpfTabControl.aspx shows how to extend the existing Microsoft tab control, but it would be nice if Telerik had these added features.

TabControl

answered on 20 Apr 2011

4 answers

140 views

MVVM Best practices

Hello,

Is there a MVVM Documentation for best practices with Infragistics WPF? - including the xamDataGrid... :)

Thanks for all answers!

General Discussions

answered on 20 Apr 2011

3 answers

286 views

How to build and create dynamic indicator in VB code instead of XML

So the indicator should be change according to my input value

Also I wanna change the range and the scale in VB code to make it more flexible.
in radical and simi gauge

Please let me know how to do that ASAP

Thanks in advance

Gauges

answered on 20 Apr 2011

1 answer

129 views

radGridView export to excel an open result in excel

Hello,

Just after exporting gridview datas to excel, i need to open the newly created excel file directly in excel on client side.

How can i do that ????

Thanks

Frederic
GenApi

GridView

answered on 20 Apr 2011

1 answer

109 views

How to show Data in a textblock from GridView?

I want to show Data in a textblock when user select a row in GridView.
i use a dataset as itemsource for GridView. NOw please tell me how to i do that????

GridView

answered on 20 Apr 2011

3 answers

89 views

Trying to edit grid style

I followed the instructions here http://www.telerik.com/help/wpf/radgridview-styles-and-templates-styling-radgridview.html but when I try to edit the style or template all I get is options for "empty" ones... I can't get it to let me use the existing styles as a base.

Any suggestions?

Thanks!

GridView

answered on 19 Apr 2011